Oracle JDBC jar and ConnectionPool

[Former Member]

I am using BLOB and I need to access oracle.* package.

I have got an exception

java.lang.ClassCastException

at oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnection.java:5126)

I have read topics about this problem... only one reason I have found is ClassLoader problem.

I have 2 jdbc jar (in connection pool and application *.par)

I don't know how to solve this problem. Is it possible to make connection pool jar available for par application?

[Former Member]

Hi Sergey:

You have two options here:

If you are developing a .par application you can include your .jar files inside the PORTAL-INF/lib folder, from which you can access them.

If you want to create a pooled connection and be able to use it in your portal app and in other apps as well, create a JDBC Connector connection using the visual admin for Oracle and reference from your code. I believe I've seen examples in the forums.

Regards

Gonzalo

[Former Member]

I have connection pool alredy. The problem is that BLOB doesn't work. I'm casting com.sap.engine.services.dbpool.cci.ConnectionHandle to OracleConnection.