wood burning stoves 2.0*
The moose likes JDBC and the fly likes clob.setCharacterStream(1); Unsupported feature Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "clob.setCharacterStream(1); Unsupported feature" Watch "clob.setCharacterStream(1); Unsupported feature" New topic
Author

clob.setCharacterStream(1); Unsupported feature

Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 573
I am trying to insert a CLOB into a Oracle Database. Oracle 9i.

In my SP I insert an empty CLOB and then return a clob as an out parameter which I then set a writer to so that I can write to the clob.

But when I run my application I get the following Error.


Exception Class...:java.sql.SQLException
Exception Message.:Unsupported feature
Failing Class..... racle.jdbc.dbaccess.DBError
Failing Method....:throwSqlException
Failing File...... BError.java
Failing Line No...:134
Previous Exception:null

From Code :

opDVO.setOUTParameter("ERROR_COL",_DatabaseUtility.CLOB_TYPE);

System.out.println("MISDAO StoreProcEnterMISData()Get a Clob");
Clob clob =
(Clob)results.getOutParameter("ERROR_COL");

System.out.println("Clob size
"+clob.length());

System.out.println("MISDAO
StoreProcEnterMISData()Set up a writer");

Writer writer = clob.setCharacterStream(1);

Is setCharacterStream no longer supported or is it a misleading error message.

Thanks for any help.

Tony
 
Don't get me started about those stupid light bulbs.
 
subject: clob.setCharacterStream(1); Unsupported feature
 
Similar Threads
Support localization in CLOB file in DB through Java
Support localization in CLOB filed in DB through java
Two Store Procedure questions
Weblogic temporary clob not getting written to or not reflecting text written to it.
Help with updating CLOB