How to include ojdbc14.jar in my war file

To connect to oracle database I’ve put ojbdc.jar unde JRUBY_HOME/lib.
Under development it works.
Now I’ve run warble to create my war file, I’ve deployed under tomcat6
but connectino to oracle doesn’t work.
Where I have put ojdbc.jar file?

On 25/05/11 10:36, Mauro wrote:

To connect to oracle database I’ve put ojbdc.jar unde JRUBY_HOME/lib.
Under development it works.
Now I’ve run warble to create my war file, I’ve deployed under tomcat6
but connectino to oracle doesn’t work.
Where I have put ojdbc.jar file?

I put it in MY_RAILS_APP/lib. Works fine.

Damian

On 25 May 2011 09:41, Damian S. [email protected] wrote:

On 25/05/11 10:36, Mauro wrote:

To connect to oracle database I’ve put ojbdc.jar unde JRUBY_HOME/lib.
Under development it works.
Now I’ve run warble to create my war file, I’ve deployed under tomcat6
but connectino to oracle doesn’t work.
Where I have put ojdbc.jar file?

I put it in MY_RAILS_APP/lib. Works fine.

I have various rails app that use the same drivers: ojdbc and postgres.
There a way to share these files between all rails app?
With my java apps I put the jars under tomcat/lib but it seems that
with rails it doesn’t work.

Am 25.05.2011 um 11:36 schrieb Mauro:

To connect to oracle database I’ve put ojbdc.jar unde JRUBY_HOME/lib.
Under development it works.
Now I’ve run warble to create my war file, I’ve deployed under tomcat6
but connectino to oracle doesn’t work.
Where I have put ojdbc.jar file?

Hi Mauro

If you like you can add the jar to tomcat’s lib folder (or whatever
server you use). If you use maven you should set the scope to provided
to let it know that it doesn’t have to be package into the war. I
personally prefer the option where I can use a vanilla tomcat, so I
package it as well.

Cheers
Reto S.

2011/5/25 Reto Schüttel [email protected]:

If you like you can add the jar to tomcat’s lib folder

Are you talking about ojdbc.jar?

2011/5/25 Reto Schüttel [email protected]:

Am 25.05.2011 um 12:19 schrieb Mauro:

If you like you can add the jar to tomcat’s lib folder

Are you talking about ojdbc.jar?

Yes i do. All jars in tomcat’s lib folder can be imported by any application in
the container.

I’ve tried but it doesn’t work.
I’ve delete ojdbc14.jar from my rails app lib directory and put under
tomcat/lib.
Oracle connection doesn’t work.
Then I’ve deleted ojdbc14.jar from tomcat/lib and put it under my
rails lib directory and it works.

Am 25.05.2011 um 12:19 schrieb Mauro:

If you like you can add the jar to tomcat’s lib folder

Are you talking about ojdbc.jar?

Yes i do. All jars in tomcat’s lib folder can be imported by any
application in the container.

Cheers,
Reto

On 27 May 2011 18:58, Dick D. [email protected] wrote:

What version of Tomcat?

Tomcat6 with linux debian.
I use also grails and grails sees the jars that I put under tomcat lib
directory while rails seems not.

What version of Tomcat?

On 27 May 2011 19:27, Mauro [email protected] wrote:

On 27 May 2011 18:58, Dick D. [email protected] wrote:

What version of Tomcat?

Tomcat6 with linux debian.
I use also grails and grails sees the jars that I put under tomcat lib
directory while rails seems not.

I’ve do that:
put ojdbc14.jar under Rails.root/lib, then I run bundle exec warble to
create the war file, deploy under tomcat and all is ok.
After I delete ojdbc14.jar from Rails.root/lib, run bundle exec warble
and deploy under tomcat.
Then I put ojdbc14.jar under tomcat/lib, but the oracle connection
doesn’t work.
Am I doing something wrong?

On 28 May 2011 22:01, Christian MICHON [email protected]
wrote:

put ojdbc14.jar under Rails.root/lib, then I run bundle exec warble to

I’m not familiar with oracle db, having used it once outside of rails/jruby dev.

But I believe in the tomcat logs, you should find why the connection
seems not to work.

Now I’m not in my production server and I can’t view tomcat logs, but
I know that the connection works if I leave ojdbc14.jar under
Rails.root/lib

On Sat, May 28, 2011 at 11:53 PM, Mauro [email protected] wrote:

create the war file, deploy under tomcat and all is ok.

I’m not familiar with oracle db, having used it once outside of
rails/jruby dev.

But I believe in the tomcat logs, you should find why the connection
seems not to work.


Christian

That’s the right place on Tomcat 6, those classes should be available to
tomcat (if you want to configure a connection pool at that level) and
all webapps
(if you just want straight JDBC connections).

You need to check logs to get any further I think.

On Sun, May 29, 2011 at 12:03 AM, Mauro [email protected] wrote:

I’ve do that:
http://xircles.codehaus.org/manage_email
I know that the connection works if I leave ojdbc14.jar under
Rails.root/lib


To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

maybe you could setup tomcat with a jndi, pointing to the oracle db
through ojdbc14.jar

I haven’t done that myself yet with H2, but you can easily find
pointers on how to change your database.yml once the jdbi is set up
properly.


Christian