aspose file tools*
The moose likes JDBC and the fly likes query on an XML Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "query on an XML Database " Watch "query on an XML Database " New topic
Author

query on an XML Database

omar bili
Ranch Hand

Joined: Aug 13, 2004
Posts: 177
Hi
i am working on an oracle database
my query is:
- select * from aaa

aaa is:
-create table aaa (
aaID integer not null ,
aaDESCR XMLTYPE
)

how can i obtain the aaDESCR from the table aaa?
i want to retreave the whole xmldocument.
does the resultSet have any function that can
return XML, the getString function is returning 'null'
thx
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24166
    
  30

This is an JDBC/Oracle question, so I'm going to move it to our JDBC forum.


[Jess in Action][AskingGoodQuestions]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: query on an XML Database
 
Similar Threads
Derby database
Problem in Seperating Core Servlet to Database Query Java
query on an XML Database
query a resultset like CFQUERY
Attempt to modify an identity column