This discussion is archived
6 Replies Latest reply: Mar 4, 2011 1:34 PM by mannamal RSS

getting XML from ORDImage problem

836274 Newbie
Currently Being Moderated
I have table with ORDImage type column
I want to extract xml field <DateTime tag="306">some_date</DateTime> from ORDImage picture meaning when picture was taken

the following code:

OracleResultSet rset = (OracleResultSet) stmt.executeQuery(query);
OrdImage media = (OrdImage) rset.getORAData(1, OrdImage.getORADataFactory());
XMLType[] xml = media.getMetadata("EXIF");
if (xml.length > 0) {
System.out.println(xml[0].extract("//DateTime", null).getStringVal());

gives "*java.lang.NoClassDefFoundError: oracle/jdbc/oci8/OCIDBAccess*" at line XMLType[] xml = media.getMetadata("EXIF");
I'm using JDBC OCI8 driver and things like upload/browsing images, generating/browsing thumbnails works fine
I have following jar's added to project:
- ordhttp.jar
- ordim.jar
- ojdbc6.jar
- xdb.jar
- xmlparserv2.jar

what can cause above exception?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points