xml « Operation « Java Database Q&A

1. Insert the xml file data into a database using java? stackoverflow.com

I wanted to insert data from a XML file to a database. This includes creating table, followed by inserting data in that from the XML file. I am looking for a solution ...

2. query on an XML Database coderanch.com

Hi i am working on an oracle database my query is: - select * from aaa aaa is: -create table aaa ( aaID integer not null , aaDESCR XMLTYPE ) how can i obtain the aaDESCR from the table aaa? i want to retreave the whole xmldocument. does the resultSet have any function that can return XML, the getString function is ...

3. How to query xml data the best way? coderanch.com

4. query on an XML Database coderanch.com

5. Reployment of Porlet with change to deployment descriptor(portlet.xml) not updating database. coderanch.com

For example, If the portlet.xml file references a webservice url and this webservice url is changed, after deployment the preference does not change and still references the original url. It works if this is the first deployment of the portlet. We have not changed a property in portlet-ext.properties file that would stop auto deployment of the portlet. Any ideas where I ...

6. program for reading data from xml file and insert reading data into DB forums.oracle.com

public class ReadAndPrintXMLFile{ public static void main (String argv []){ try { Class.forName("com.sap.dbtech.jdbc.DriverSapDB"); String url="jdbc:sapdb://192.168.1.36/J2E?sqlmode=ORACLE"; Connection con=DriverManager.getConnection(url,"SAPJ2EDB","abcd1234"); //PreparedStatement stmt=con.prepareStatement("insert into TAB_PERSON values(?,?,?)"); // con.setAutoCommit(false); DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance(); DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder(); Document doc = docBuilder.parse (new File("book.xml")); // normalize text representation doc.getDocumentElement ().normalize (); System.out.println ("Root element of the doc is " + doc.getDocumentElement().getNodeName());

7. updating the xml database forums.oracle.com

8. updating the xml database forums.oracle.com

9. take input of a xml file, parse it, and insert into database forums.oracle.com

My approach to this: - Create a data object that can hold whatever data structure that's in your xml. - Create a sax parser that parses the file into an object of the above class or a collection of them (you can probably find that in the links provided above) - Store each object into the database (many ways to do ...