• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Oracle's XMLType.createXML() fails...

 
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello all,
I recently was able to insert/select an xml document from the database using a CLOB. We have a need to do the same thing using the Oracle XMLType object.
We are currently running Oracle 9i (9.2.0.1) on a Solaris Server.
My java environment is WSAD 5.0.1 with Oracle XDK 9.2.0.5.0 running on Win2k.
Now my xml document appears to be well-formed (i even tried hard coding the string "<test>foo</test>"). But when I try to create an instance of the Oracle XMLType to set in my PreparedStatement I get an error. I have tried 2 of this type�s overloaded methods and each causes a different type of error...
XMLType xml = XMLType.createXML(con, doc); always assigns null to xml. I don't get any exception and my connection object is fine because I prepare my statement before this line is hit.
XMLType xml = XMLType.createXML(con, xmlString); throws a ClassCastException. I am not sure why this is happening. But my log4j logger says that the class cast exception is coming from the OracleConnectionProxy.
Does anyone have any thoughts on this?
Any help would be greatly appreciated.
Thanks

EDIT: The method is XMLType.createXML() not XMLType.Crate().
[ December 09, 2003: Message edited by: Heath Lilley ]
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello, I get exactly the same results.

I found some hints that the problem arises because the Oracle XDB-Package is not installed (see the second reply in this thread: http://forums.oracle.com/forums/message.jspa?messageID=791302).

I checked and the statement mentioned ("select 1 from all_users where username='XDB'") returns nothing on my Oracle-installation. My Oracle people will help me to install the package and I will post the results here.

After reading the Oracle documentation I had the impression that XDB is always part of Oracle and therefore is always part of an installation.

kind regards.

Thomas G�nther
[ October 10, 2005: Message edited by: Thomas G�nther ]
 
Thomas G�nther
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I got the xdb-Package installed and sorry, no luck.

If anybody finds a solution to the problem, I am really interested to know what is wrong.

kind regards,

Thomas
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Has this issue been resolved? I'm getting a similiar 'error' after an Oracle upgrade from 9i to 10g
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic