Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

oracle blob class problem

Hello again.

I have the following code:

java.sql.ResultSet resultSetForUpdate = stat.executeQuery("select picture from some_table where some_id=" + someId + " for update");
java.sql.Blob blob = resultSetForUpdate.getBlob(1);
// here is some code that types the class of the blob
logger.info("blob class is: "+blob.getClass());

now the problem is that the class returned with blob.getClass is different on 2 portals... on 1 portal I get oracle.sql.BLOB (this is the expected result) but on the other I get com.inqmy.services.dbpool.remote.RemoteBlobImpl

does anyone have any idea why this is happening and how can I do so that I always get the oracle.sql.BLOB class?

more information: both portal installations are ep6 sp2 with (I think) identical patch levels (35 if I remember correctly). the database they access is the same one. the dbpool definitions (in visual administrator) look similar.

thanks in advance.

silviu.

Not what you were looking for? View more on this topic or Ask a question