Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Can anyone write XMLType to Oracle 9iR2 DB from WL 7 sp2?

1 view

Skip to first unread message

Rick Bradshaw

unread,

Jul 5, 2003, 8:02:43 PM7/5/03

I am having trouble writing XMLType to the database (Oracle 9.2.0.1.0). I have
tried using a PreparedStatement:

update = "update xmlDoc set xml = ? where id = 9"

PreparedStatement toPrepStmt = toConnection.prepareStatement( update );

Object o = rs.getObject(14); // XMLType retrieved from another database
in Opaque type
oracle.sql.OPAQUE fromOpaque = (oracle.sql.OPAQUE) o;
XMLType xt = XMLType.createXML( fromOpaque );

toPrepStmt.setObject(1, xt);
>>> toPrepStmt.execute(); <<< CRASH
toPrepStmt.close();
------------------------
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:369)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
..
-------------------------
Anyone have success writing XMLType to the database from WL 7 SP2?

Thanks,

Rick

0 new messages