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

> 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
>
>