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 2011-05-25 11:36
on 2011-05-25 11:42
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 2011-05-25 11:46
On 25 May 2011 09:41, Damian Steer <pldms@mac.com> 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.
on 2011-05-25 11:56
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 Schttel
on 2011-05-25 12:19
2011/5/25 Reto Schüttel <reto@schuettel.ch>: > > If you like you can add the jar to tomcat's lib folder Are you talking about ojdbc.jar?
on 2011-05-25 14:30
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 2011-05-27 10:34
2011/5/25 Reto Schüttel <reto@schuettel.ch>: > 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.
on 2011-05-27 21:28
On 27 May 2011 18:58, Dick Davies <rasputnik@gmail.com> 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.
on 2011-05-28 23:56
On 27 May 2011 19:27, Mauro <mrsanna1@gmail.com> wrote: > On 27 May 2011 18:58, Dick Davies <rasputnik@gmail.com> 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 2011-05-29 00:02
On Sat, May 28, 2011 at 11:53 PM, Mauro <mrsanna1@gmail.com> 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
on 2011-05-29 00:04
On 28 May 2011 22:01, Christian MICHON <christian.michon@gmail.com> 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 2011-05-29 00:07
On Sun, May 29, 2011 at 12:03 AM, Mauro <mrsanna1@gmail.com> 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
on 2011-05-29 00:14
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.
Enable email notification
Enable multi-page viewPlease log in before posting. Registration is free and takes only a minute.
Existing account
(Switch to SSL-encrypted connection)
NEW: Do you have a Google/GoogleMail or Yahoo account? No registration required!
Log in with Google account | Log in with Yahoo account
Log in with Google account | Log in with Yahoo account
No account? Register here.