doing CLOB or BLOB operations

Discussions

General J2EE: doing CLOB or BLOB operations

  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

    Threaded Messages (6)

  2. 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.
  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.
  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.
  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?
  6. doing CLOB or BLOB operations[ Go to top ]

    WebLogic 6.0
  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.