| guest |
Fri May 08 16:43:15 BST 2009 |
| |
Hi,
I need to extract the JDBC native connection from a Primrose pooled connection.
My RDBMS is Oracle 9iR2 ( ojdbc.jar JDBC Driver library).
Each time I invoke the getRealConnection() method I get a
oracle.jdbc.driver.OracleConnection
and not an
oracle.jdbc.OracleConnection
This is a major problem since some custom Oracle JDBC method like the following one:
BLOB oBlob = oracle.sql.BLOB.createTemporary(oConn, false, oracle.sql.BLOB.DURATION_SESSION);
will throw a Java exception caused by a wrong Connection implementation ( oracle.jdbc.driver.OracleConnection is required ).
Thanks. |
| |
| guest |
Fri May 08 16:44:53 BST 2009 |
| |
ops.... I meant:
will throw a Java exception caused by a wrong Connection implementation ( oracle.jdbc.OracleConnection is required ).
Thanks. |
| guest |
Fri May 08 16:48:20 BST 2009 |
| |
I'm using:
- Tomcat 6.0.18
- JDK 16
- Primrose 3.0.13
- Global server.xml pool configuration |
| sedj |
Fri May 08 17:44:17 BST 2009 |
| |
Primrose will just return a handle to the original Connection object created by the Driver you have specified to use - if you use the class oracle.jdbc.driver.OracleDriver, then that does return an orage.jdbc.driver.OracleConnection.
I've used orage.jdbc.driver.OracleConnection to create temporary blobs and structs with no problem. Are you sure the issue is not something else ?
BTW, make sure you do NOT close the "real connection" - you must close the primrose connection object. |
| guest |
Mon May 11 11:44:54 BST 2009 |
| |
Thanks. As I supposed it was not Primrose's fault!
That particular web context loaded a tricky third third party jar file including a very old version of the whole Oracle JDBC driver classes.
So classLoader chose that particular implementation each time DriverManager.getConnection method was invoked.
Primrose is a great product.
Thanks for your support. |
| guest |
Fri Jun 04 13:08:00 BST 2010 |
| |
| 8sJdmv hytrptrxsmxl, [url=http://afhbrywvtgbm.com/]afhbrywvtgbm[/url], [link=http://hfwktfdlqape.com/]hfwktfdlqape[/link], http://uqsvjiiiorqx.com/ |
| guest |
Fri Jun 04 13:08:00 BST 2010 |
| |
| 8sJdmv hytrptrxsmxl, [url=http://afhbrywvtgbm.com/]afhbrywvtgbm[/url], [link=http://hfwktfdlqape.com/]hfwktfdlqape[/link], http://uqsvjiiiorqx.com/ |
|
