aspose file tools*
The moose likes JDBC and the fly likes How to Convert a java.sql.CLOB object to String Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to Convert a java.sql.CLOB object to String" Watch "How to Convert a java.sql.CLOB object to String" New topic
Author

How to Convert a java.sql.CLOB object to String

Ankit Gandhi
Greenhorn

Joined: Nov 03, 2006
Posts: 27
Hi,

I have a PL/SQL procedure �reorganize_report� which returns a CLOB object. This proc is being called through a java file named ReportDAO.java in the following way-

csmt = con.prepareCall("{call report_spk.reorganize_report(?,?,?,?) }");
csmt.setObject(1,(Object)reportId,java.sql.Types.CHAR);
csmt.registerOutParameter(7,java.sql.Types.CLOB);
csmt.registerOutParameter(8,java.sql.Types.CLOB);
csmt.registerOutParameter(9,java.sql.Types.CLOB);
csmt.execute();


I am retrieving the Clob�s like this � (the CLOB object is of java.sql.CLOB class)
Clob sourcelocationLst = csmt.getClob(7);
Clob newlocationLst = csmt.getClob(8);
Clob fileNameLst = csmt.getClob(9);

Now I need to convert this CLOB into a String object.
I tried using the toString() function present for CLOB�s but it gives me the following o/p - oracle.sql.CLOB@66c9b250

Can anybody help me out with this?
Freddy Wong
Ranch Hand

Joined: Sep 11, 2006
Posts: 959

If you look at the java.sql.Clob, there's a method called getCharacterStream() that returns a Reader. You can use the Reader and convert it into String.

Hope that helps.


SCJP 5.0, SCWCD 1.4, SCBCD 1.3, SCDJWS 1.4
My Blog
 
Don't get me started about those stupid light bulbs.
 
subject: How to Convert a java.sql.CLOB object to String