Forum:

JDBC and Relational Databases

How to get XMLType column value from Oracle using JDBC ?

Greenhorn

Posts: 5

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

Can anyone help me out how to get XMLType Column value from Oracle using JDBC. I'm unable to get the the CLOB.. Is there any other way to get the XMLType column value? Below is the query that i'm using..

"SELECT XMLCOLUMN FROM DATA_TABLE" - XMLCOLUMN is my XMLTYPE column..

Any help on this will be appreciated

Thanks,
Dee Kay

Jan Cumps

Bartender

Posts: 2662

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Welcome to JavaRanch!

OCUP UML fundamental and ITIL foundation

Dennis Patel

Greenhorn

Posts: 5

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Dee Kay wrote:Hi,

Can anyone help me out how to get XMLType Column value from Oracle using JDBC. I'm unable to get the the CLOB.. Is there any other way to get the XMLType column value? Below is the query that i'm using..

"SELECT XMLCOLUMN FROM DATA_TABLE" - XMLCOLUMN is my XMLTYPE column..

Any help on this will be appreciated

Thanks,
Dee Kay

Hi All,

I found the way to get this done.

David O'Meara

Rancher

Posts: 13459

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Posting links like this to your own site is called astroturfing and is not considered very nice

Scott Selikoff

author

Posts: 4356

I like...

posted 14 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Dennis Patel wrote:I found the way to get this done.

Why not post your solution here for others that might have the same problem?

[OCP 21 Professional Study Guide] [OCP 17 Complete Study Guide] [OCP 17 Practice Tests] [OCP 11 Complete Study Guide] [OCP 11 Programmer I] [OCP 11 Programmer II] [OCP 11 Practice Tests] [OCA 8] [OCP 8] [OCP 8 Practice Tests Book] [Blog]

Java 8 (verified skill)
Skill verified by Scott Selikoff

Sam Zou

Ranch Hand

Posts: 40

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Scott Selikoff wrote:

Dennis Patel wrote:I found the way to get this done.

Why not post your solution here for others that might have the same problem?

True, you get information from forums but you have to share your knownledge too !

Sam<p>"Life is difficult"<br /> -Scott Peck-</p>