| ORA-01729: for XMLType [message #91954] |
Sat, 06 December 2003 07:00 |
rabbit
Messages: 6
Registered: October 2003
|
Junior Member |
|
|
Hi all,
i want to insert the xml data in my table with xmltype. At first i store these xml daten in another table as clob. But i get always the error message
ORA-01729: database link name expected
during the insert the xml data in xmltype column.
For the clobtable:
PreparedStatement pstmt_clob = con.prepareStatement("INSERT INTO clobtable VALUES(?, ?)");
...
pstmt_clob.setInt(1, f+1);
pstmt_clob.setCharacterStream(2, new java.io.FileReader(f_ordner[[f+1]]), (int)f_ordner[[+1]].length());
pstmt_clob.execute();
For the xmltable:
Connection conn = connect();
stmt.executeUpdate("UPDATE xmltable SET xml_dok = XMLTYPE.createXML(" + conn + "," + rs.getClob(2) + ")WHERE id =" + nr);
Code for connection:
public Connection connect() throws Exception {
Class.forName("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection(
"jdbc:oracle:oci:@zeus", "zhou", "diplom");
return conn;
}
I don't know, what's wrong with my programm. Can you help me?
thank you very much and greeting from germany
rabbit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
