|
»
»
Forward: From Rich Manalang on Oracle w/ JNDI configuration question
|
View:
New views
9 Messages
—
Rating Filter:
Alert me
|
 |
Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by Thomas E Enebo
::
Rate this Message:
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 |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by Nick Sieger-2
::
Rate this Message:
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 |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by kofno
::
Rate this Message:
The driver line "should" be optional. It's there to make sure the right flavor of SQL is generated. We try to do our best to find what driver is actually being used by the JNDI datasource, but that code hasn't been thoroughly tested.
On Feb 7, 2008 4:18 PM, Thomas E Enebo <tom.enebo@...> wrote: We are having an issue with subscribing to our mailing lists (which I -- Ryan L. Bell http://kofno.wordpress.com http://kofno.blogspot.com |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by Chris Evans-8
::
Rate this Message:
Our primary db is DB2 and I'm pretty pumped about JRuby so I'd be
willing to help out as much as I can. I might need some hand holding at first to get started. Chris 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 > > > --------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by deanholdren
::
Rate this Message:
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 |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by Nick Sieger-2
::
Rate this Message:
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. |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by manalang
::
Rate this Message:
Hey Nick. I'll volunteer to set up a CI for Oracle. Unfortunately, I
don't have a public facing server I can run this on, but I can set up ar-jdbc's and ar's test to run under CruiseControl and have an email shoot out to someone if something breaks... question is, is there a ar-jdbc list I can point it to... or do you have a preference for receiving build failures? Also, let us know how to run these tests. I checked out ar-jdbc trunk last night and read the README on how to run the tests, but I couldn't get it to work properly. Rich On Feb 8, 2008 7:27 AM, Nick Sieger <nicksieger@...> wrote: > 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 > > > > > > > > > --------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by manalang
::
Rate this Message:
Yeah... we at ORCL need to get with it re: Oracle DB on different
platforms. Put in an idea at https://mix.oracle.com. One of the most popular ideas is for an OSX version of Oracle XE. Rich On Feb 8, 2008 7:27 AM, Nick Sieger <nicksieger@...> wrote: > 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 > > > > > > > > > --------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email |
|
|
Re: Forward: From Rich Manalang on Oracle w/ JNDI configuration question
by Nick Sieger-2
::
Rate this Message:
On Feb 8, 2008, at 12:11 PM, Rich Manalang wrote:
> Hey Nick. I'll volunteer to set up a CI for Oracle. Unfortunately, I > don't have a public facing server I can run this on, but I can set up > ar-jdbc's and ar's test to run under CruiseControl and have an email > shoot out to someone if something breaks... question is, is there a > ar-jdbc list I can point it to... or do you have a preference for > receiving build failures? > > Also, let us know how to run these tests. I checked out ar-jdbc trunk > last night and read the README on how to run the tests, but I couldn't > get it to work properly. I have an action item to write something up on this. If you look in ar- jdbc trunk's Rakefile there is a test_oracle task, see if you can connect the dots from there... /Nick > > > Rich > > On Feb 8, 2008 7:27 AM, Nick Sieger <nicksieger@...> wrote: >> 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 >>> >>> >>> >> >> >> > > --------------------------------------------------------------------- > 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 |
| Free embeddable forum powered by Nabble | Forum Help |
