Using an XML String to Insert into Oracle Database

Question

I have parsed (not sure if that is the correct terminology) a set of data into an xml string so that its something like this:

    <Data>
    <Books DataType = 'String' Values = 'Hello World', 'Hi'..../>
    ....
    </Data>

However, I now want to 'INSERT' that set of data into an oracle database using SQL. Everything I looked up uses DOM or some kind of document builder that I dont want/need in my program. The closest thing I have found is CLOB.

Is there any special methods that I can use in JAVA that would help me?

you can read your xml into variables using xpath and then insert? It can become complicated if your xml has varying layouts, but if your xml has a standard layout it's pretty usefull — Jeremy C., Jun 25 '15 at 07:13
you can use jaxb to get java object from your xml and work on it. — Sujit Chaitanya, Jun 25 '15 at 07:14
thank you guys, I will try both ways and get back to you guys! — Java Apprentice, Jun 25 '15 at 07:19

score 0 · Accepted Answer · edited May 23 '17 at 12:29

0

Why don't you store them into Strings ? How to store unlimited characters in Oracle 11g?

Or you can try mix JPA and JAX-B with somthing like this :

import javax.persistence.Entity;
import javax.xml.bind.annotation.XmlRootElement;

@XmlRootElement
@Entity
public class Book {
...
}

and

import javax.persistence.Entity;
import javax.xml.bind.annotation.XmlRootElement;

@XmlRootElement
@Entity
public class Data {    
    private List<Book> books;
...
}

edited May 23 '17 at 12:29

Community

1
1

answered Jun 25 '15 at 07:22

Karbos 538

2,977
1
23
34

ill gladly look into this too! however, I also wanted to keep the program simple – Java Apprentice Jun 25 '15 at 07:36

Using an XML String to Insert into Oracle Database

1 Answers1