Results 1 to 2 of 2
  1. #1
    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 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.

  2. #2
    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:
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts