07-13-04, 12:51 #1Registered User
- Join Date
- Jul 2004
Unanswered: Handling Character large objects in Java application
In my Java application, I have a stream of character data in a java.io.Reader object.
I am using a PreparedStatement object to insert data into a table containing such a large object column (datatype - text). I am using the following API call:
PreparedStatement.setCharacterStream(colIndex, reader, size);
In order to find the size in the above statement, I read the stream and find the length.
Because of this I am getting the following error message and the data is not getting inserted:
Exception during insertion : Failed for MYTABLE Reason [Microsoft][SQLServer 2000 Driver for JDBC]Transliteration failed.
Is there any alternate method to handle this? Please help.
07-13-04, 13:01 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
Are you executing the statement within a loop? If that's the case, - see if this will help:
http://knowledgebase2.datadirect.com...F?OpenDocument"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."