Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-06-25T00:27:33Z by DGawron
RaghuV
RaghuV
1 Post
ACCEPTED ANSWER

Pinned topic WSJdbcDataSource with OracleDataSource

‏2012-06-22T07:52:17Z |
Regarding Oracle CLOB - Java Development
Error:
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource incompatible with oracle.jdbc.pool.OracleDataSource
I am a Java Developer. Need Support for working Oracle CLOB Via JNDI Oracle Connection Using OracleDatasource.

I am unable Insert data on Oracle CLOB Data Type in Oracle 10G.I have used thin Driver -ojdbc14.jar. My Java Runtime Environment is Java1.5.

As per Oracle Documenation to use CLOB ,
for insering data via preparedstatment , it is required to get oracle.jdbc.CLOB as below.
This required OracleConnection instead of interface java.sql.Connection.

// If the temporary CLOB has not yet been created, create new
tempClob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION);

So for this i get an error during lookup at following line.

myDataSource = (OracleDataSource) initCtx.lookup(strDSN);

Exception:
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource incompatible with oracle.jdbc.pool.OracleDataSource
Updated on 2012-06-25T00:27:33Z at 2012-06-25T00:27:33Z by DGawron
  • DGawron
    DGawron
    251 Posts
    ACCEPTED ANSWER

    Re: WSJdbcDataSource with OracleDataSource

    ‏2012-06-25T00:27:33Z  in response to RaghuV
    This group is for questions related to working with Web Experience Factory and databases. It sounds like you are not using Web Experience Factory. You'll get a better response if you post this question to a WebSphere specific group.