problems setting up Oracle connection pool

[ChrisAdkin]

I'm trying to create a database connection pool based on the thin driver which comes with Oracle 11g (ojdbc6.jar). I copy the jar from the Oracle jdbc/lib directory to the geronimo/repository directory> The app server then creates an ojdbc6.jar directory under geronimo/default. However, when I go through the wizard to setup the connection pool, Geronimo states that it is unable to load the JDBC driver class oracle.jdbc.OracleDriver from this jar. The wizard claims that I should see the documentation for "your JDBC driver", I'm miffed as to what is wrong with this as I have used the same JDBC driver jar with both JBoss and WebSphere without any issues, does anyone have any ideas as to why this is not working ?. Also, this jar works fine when I use it create a database connection from within Eclipse.

Does anyone have any ideas ?

[djencks]

On Jun 16, 2009, at 12:57 AM, ChrisAdkin wrote:


Which geronimo version?

>
> I'm trying to create a database connection pool based on the thin  
> driver
> which comes with Oracle 11g (ojdbc6.jar). I copy the jar from the  
> Oracle
> jdbc/lib directory to the geronimo/repository directory>

Where exactly?  I recommend installing jars by using the install jar  
to repo portlet and supplying reasonable groupId (probably com.oracle)  
and artifactId (ojdbc) and version (6) (??)

> The app server then
> creates an ojdbc6.jar directory under geronimo/default. However,  
> when I go
> through the wizard to setup the connection pool, Geronimo states  
> that it is
> unable to load the JDBC driver class oracle.jdbc.OracleDriver from  
> this jar.

Where did this directory come from?   From running through the db pool  
wizard?


> The wizard claims that I should see the documentation for "your JDBC
> driver", I'm miffed as to what is wrong with this as I have used the  
> same
> JDBC driver jar with both JBoss and WebSphere without any issues, does
> anyone have any ideas as to why this is not working ?. Also, this  
> jar works
> fine when I use it create a database connection from within Eclipse.

Can you please show the plan that the wizard came up with?  Most  
likely it doesn't include a correct dependency on the oracle jar.

thanks
david jencks

>
> Does anyone have any ideas ?
> --
> View this message in context: http://www.nabble.com/problems-setting-up-Oracle-connection-pool-tp24049436s134p24049436.html
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>

[ChrisAdkin]

Its 2.1, I've since found out what the problem was, for some reason when I deployed my ear file it was creating an ojdbc6.jar directory which only resembled the driver jar file in name only. I un-deployed this and then put the correct one in the repository and it works fine now. But thanks for the quick response, I'm amazed at how fast people pick new responses up on this forum.

Regards,

Chris

djencks wrote:

On Jun 16, 2009, at 12:57 AM, ChrisAdkin wrote:


Which geronimo version?

>
> I'm trying to create a database connection pool based on the thin  
> driver
> which comes with Oracle 11g (ojdbc6.jar). I copy the jar from the  
> Oracle
> jdbc/lib directory to the geronimo/repository directory>

Where exactly?  I recommend installing jars by using the install jar  
to repo portlet and supplying reasonable groupId (probably com.oracle)  
and artifactId (ojdbc) and version (6) (??)

> The app server then
> creates an ojdbc6.jar directory under geronimo/default. However,  
> when I go
> through the wizard to setup the connection pool, Geronimo states  
> that it is
> unable to load the JDBC driver class oracle.jdbc.OracleDriver from  
> this jar.

Where did this directory come from?   From running through the db pool  
wizard?


> The wizard claims that I should see the documentation for "your JDBC
> driver", I'm miffed as to what is wrong with this as I have used the  
> same
> JDBC driver jar with both JBoss and WebSphere without any issues, does
> anyone have any ideas as to why this is not working ?. Also, this  
> jar works
> fine when I use it create a database connection from within Eclipse.

Can you please show the plan that the wizard came up with?  Most  
likely it doesn't include a correct dependency on the oracle jar.

thanks
david jencks

>
> Does anyone have any ideas ?
> --
> View this message in context: http://www.nabble.com/problems-setting-up-Oracle-connection-pool-tp24049436s134p24049436.html
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>