Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question

> I suppose that's true, I just haven't had the time to download it and set it
> up. I'd have to run it inside a Parallels VM, and it's just not as
> convenient.
>
> It would be nice if Oracle offered XE for Solaris.
>
> /Nick
>
>
>
> On Feb 8, 2008, at 8:50 AM, Dean Holdren wrote:
> If it's a matter of software, Oracle offers 10g Express Edition for free.
>
>
> On Feb 7, 2008 9:49 PM, Nick Sieger <nicksieger@...> wrote:
>
> > The other recent thread has a similar NPE error, but the configuration
> > is quite different. My recommendation to Rich would be the same -- add
> > a debug line to try to see what the connection error is.
> >
> > We could really use some community members to step up and help support
> > Oracle and DB2, because Ola and I don't have much access to those
> > systems.
> >
> > Even just setting up continuous integration, so we could get feedback
> > when something breaks on the proprietary databases would be great.
> >
> > /Nick
> >
> >
> >
> >
> > On Feb 7, 2008 3:18 PM, Thomas E Enebo <tom.enebo@...> wrote:
> > > We are having an issue with subscribing to our mailing lists (which I
> > > have reported).  Here is an email from Rich:
> > >
> > > Has anyone had any success with using jndi connection pools using
> > > JRuby 1.1RC1/activerecord-jdbc-0.7.1 on Oracle?  I followed the
> > > instructions on the JRuby wiki
> > >
> (http://wiki.jruby.org/wiki/Goldspike#Using_a_connection_from_a_pool_via_JNDI)
> > > and when that didn't work, I tried several variations.
> > >
> > >
> > > Here's how I currently have this configured:
> > >
> > > database.yml:
> > >
> > > development:
> > >   adapter: jdbc
> > >    jndi: java:comp/env/jdbc/mydb
> > >   driver: oracle.jdbc.driver.OracleDriver
> > >
> > > I've also tried this:
> > >
> > > development:
> > >    adapter: jdbc
> > >    jndi: jdbc/mydb
> > >    driver: oracle.jdbc.driver.OracleDriver
> > >
> > > I get an exception with these two configurations -> jdbc_adapter.rb
> > > (line 303) throws "Failed to load Rails: The driver encountered an
> > > error: java.lang.NullPointerException: null"
> > >
> > > I've also tried this (this is how it's specified on the JRuby wiki...
> > > I get a "can't find oracle driver" exception with this):
> > >
> > > development:
> > >    adapter: jdbc
> > >    jndi: java:comp/env/jdbc/mydb
> > >    driver: oracle.jdbc.driver.OracleDriver
> > >
> > > I've also tried excluding the driver attribute, but get this exception:
> > >
> > > "Failed to load Rails: The driver encountered an error: can't convert
> > > nil into String" -- jdbc_adapter.rb (line 303)
> > >
> > > My web.xml has the following in it:
> > >
> > > ...
> > >     <resource-ref>
> > >       <res-ref-name>jdbc/mydb</res-ref-name>
> > >       <res-type>javax.sql.DataSource</res-type>
> > >       <res-auth>Container</res-auth>
> > >      </resource-ref>
> > > ...
> > >
> > > And... I've configured my container (Oracle app server, aka, OC4J
> > > 10.3) with the requisite data source and connection pool
> > > configurations and tested that I can connect to them.
> > >
> > > One thing I'm not clear on is why the driver has to be specified in
> > > the database.yml if it's a jndi resource.  I'm going to try this on
> > > Jetty to see if it's a container issue, but if anyone out there know's
> > > what I'm doing wrong, please let me know.
> > >
> > > Thanks.
> > >
> > > Rich Manalang
> > > https://mix.oracle.com
> > >
> > >
> > > --
> > > Blog: http://www.bloglines.com/blog/ThomasEEnebo
> > > Email: enebo@... , tom.enebo@...
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe from this list, please visit:
> > >
> > >     http://xircles.codehaus.org/manage_email
> > >
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe from this list, please visit:
> >
> >    http://xircles.codehaus.org/manage_email
> >
> >
> >
>
>
>