Discussions

General J2EE: doing CLOB or BLOB operations

Bookmark and Share Get thread feed

  1. doing CLOB or BLOB operations (6 messages)

    Is any body did BLOB or CLOB opration using a database connection obtained from weblogic TxnDataSource or connection Pool.??

    Is it possible.


    Nazilin
    Reply to this

    Threaded Messages (6)

  2. doing CLOB or BLOB operations[ Go to top ]

    BLOB and CLOB in CMP's are supported starting only from 6.1 i think. You can use a suitable driver like the jdbc20 driver and using normal SQL's can perform operations on BLOB and CLOB's.

    Shiva.
    Reply to this Reply to original

  3. doing CLOB or BLOB operations[ Go to top ]

    Yes - only when you use WebLogic's jDriver/Oracle to create the connection pool. Oracle's drivers will not work.
    Reply to this Reply to original

  4. doing CLOB or BLOB operations[ Go to top ]


    We've used a standard connection pool of Oracle thin drivers and used it succesfully to read and write CLOB and BLOB data. We use SQL operations however to read and write in chunks, and not the setBlob and setCLOB methods.
    Reply to this Reply to original

  5. doing CLOB or BLOB operations[ Go to top ]

    Which version of WebLogic Server do you use? What is the name of the class that you cast the object from ResultSet.getBlob() to?
    Reply to this Reply to original

  6. doing CLOB or BLOB operations[ Go to top ]

    WebLogic 6.0
    Reply to this Reply to original

  7. doing CLOB or BLOB operations[ Go to top ]

    I am using that weblogic's oracle driver only.
    It gives me errors.

    It seems like ResultSet.getClob() returns an RMI (kind of ) object
    instead of the Clob object.

    thanks
    N.
    Reply to this Reply to original