Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Question Unanswered: JDBC Updating Clob

    Background information:
    * IBM WebSphere Application 5.1
    * Oracle 9i Release 9.2.0.1.0
    * JDK 1.3.1, JDBC 2.0 (limitation of WebSphere)
    * EJB 2.0 Session Bean
    * US7ASCII Char. Set in Oracle
    * oci8 driver

    Problem:
    I am trying to update a row in my pr_problemreports table, the row contains a CLOB.

    The steps I am completing:
    1. Inserting an empty record into the database.
    2. I do a SELECT FOR UPDATE
    3. Get oracle.sql.CLOB object (ie. tempClob = (oracle.sql.CLOB rs.getClob("DETAILS");)
    4. I do: tempClob.putString(0, detailsString);

    I am getting the following error:
    java.sql.SQLException: Invalid argument(s) in call: putString()
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
    at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava:1130)
    at oracle.sql.CLOB.putString(CLOB.java:623)
    ...

    I have been googling, reading OTN Docs, and asking advice from my co-workers for 4 weeks now. I am very frustrated, I have tried thousands (it seems) of examples. I have tried changing my database type from US7ASCII to UTF8 and back.

    I have attached the code.

    Thanks,
    Chad.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2003
    Posts
    15

    Lightbulb JDBC Updating Clob

    Hi,
    The following messeage may be useful.

    http://dbforums.com/arch/92/2002/9/510928

    Regards
    Chenna

Posting Permissions

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