oracle.sql.clob java.sql.clob,java.lang.NoClassDefFoundError: oracle/sql/CLOB

Hello,

We are porting the J2EE app to WAS. WE are getting the following error. Any ideas.

source code snippet:

import java.sql.*;

import java.util.*;

import oracle.sql.CLOB;

import oracle.sql.BLOB;

ResultSet rs = ps.executeQuery();

while (rs.next()) {

int count = 1;

Iterator lobListIter = lobList.iterator();

while(lobListIter.hasNext()) {

LobData lobData = (LobData)lobListIter.next();

if(lobData.isByteArrayData()) {

if(lobData.getByteArrayData() != null) {

Blob blobData = rs.getBlob(count);

((oracle.sql.BLOB)blobData).putBytes(1,

lobData.getByteArrayData());

}

} else {

if(lobData.getStringData() != null) {

Clob clobData = rs.getClob(count);

((oracle.sql.CLOB)clobData).putString(1, lobData.getStringData());

}

}

++count;

}

}

rs.close();

} catch (SQLException e) {

error: Caused by: java.lang.NoClassDefFoundError: oracle/sql/CLOB

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:240)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

Caused by: java.lang.NoClassDefFoundError: oracle/sql/CLOB

at com.dicarta.infra.persistence.server.WebsphereLobHandler.updateClobData(WebsphereLobHandler.java:52)

at com.dicarta.infra.persistence.server.AbstractJDBCPersister.updateClobData(AbstractJDBCPersister.java:277)

at com.dicarta.appfound.contract.server.persistence.AbstractContractPersister.update(AbstractContractPersister.java:93)

at com.dicarta.appfound.contract.server.bo.ContractBO.submitDraft(ContractBO.java:1642)

at com.dicarta.appfound.contract.server.bo.ContractBO.submitDraft(ContractBO.java:1531)

at com.dicarta.appfound.contract.server.bo.ContractBO.submitDraft(ContractBO.java:1511)

at com.dicarta.app.kmgr.server.bo.ContractServicesBO.submit(ContractServicesBO.java:2390)

at com.dicarta.app.kmgr.server.ContractServicesEJB.submit(ContractServicesEJB.java:781)

at com.dicarta.app.kmgr.server.IContractServicesObjectImpl40.submit(IContractServicesObjectImpl40.java:7509)

Thank you,

Kumar

cSoftgroup