DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SELECT FROM A TABLE WHICH HAS XMLTYPE DATA IN A COLUMN

400012Jul 27 2003 — edited Jul 29 2003

Hi,
I am trying to select, update and insert an XMLDocument instance in Oracle XML DB Release2 9i using examples given in the document "XML Database Developer’s Guide - Oracle XML DB" Chaptor 9 starting from page 407 of the PDF GUIDE.
I don't compile error, at run time I get this error message

Exception in thread "main" java.lang.NoSuchMethodError
at oracle.xdb.XMLType.initConn(XMLType.java:2072)
at oracle.xdb.XMLType.<init>(XMLType.java:903)
at oracle.xdb.XMLType.createXML(XMLType.java:493)
at oracle.xdb.XMLTypeFactory.create(XMLTypeFactory.java:65)
at oracle.sql.OPAQUE.toClass(OPAQUE.java:558)
at oracle.sql.OPAQUE.toJdbc(OPAQUE.java:469)
at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.jav
a:5719)
at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.jav
a:5622)
at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.
java:739)
at MyClass.accessXML(MyClass.java:110)
at MyClass.main(MyClass.java:56)
This only happens when I try to display/store XMLType value in string, using methods given in the above mentioned document.

Can any one identify the problem.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2003

Added on Jul 27 2003

#general-xml, #xml

2 comments

602 views