|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: How to populate or update a long varchar from jdbc (Clob)
From: Dittmar, Daniel (daniel.dittmar
sap.com)
Date: Fri Jul 04 2003 - 11:29:18 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> All java.sql.Clob 'update' methods (setString,
> setCharacterStream, etc)||
> throw 'unimplemented' exceptions, is there a way ?
LONG columns can't be updated through the Clob and Blob interfaces.
Use a PreparedStatement with an INSERT or UPDATE and use setString or setCharacterStream for the parameter corresponding to the LONG column.
This means that you have to replace the whole LONG, you cannot overwrite parts.
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
daniel.dittmarsap.com
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]