• 1 reply
  • Latest Post - ‏2012-06-25T00:27:33Z by DGawron
1 Post

Pinned topic WSJdbcDataSource with OracleDataSource

‏2012-06-22T07:52:17Z |
Regarding Oracle CLOB - Java Development
Error: 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: incompatible with oracle.jdbc.pool.OracleDataSource
Updated on 2012-06-25T00:27:33Z at 2012-06-25T00:27:33Z by DGawron
  • DGawron
    251 Posts

    Re: WSJdbcDataSource with OracleDataSource

    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.