quality@glassfish.java.net

Re: GFv3 and Oracle

From: Kedar Mhaswade <Kedar.Mhaswade_at_Sun.COM>
Date: Fri, 22 Aug 2008 07:47:40 -0700

Wouter,

It looks to me that it's a problem that we have to solve. Creating a pool
is a pure, config-only operation. When you try to ping the pool on the
other hand, the data-source class has to be loaded dynamically. This is
probably not happening as expected.

Can you file a bug?

Thanks,
Kedar

Wouter van Reeven wrote:
> Hi again,
>
> On Fri, Aug 22, 2008 at 10:51:31AM +0200, To quality wrote:
>> On build 20 I am trying to setup a JDBC Connection Pool to an Oracle database. I
>> downloaded the ojdbc6.jar from Oracle's website and copied it into <gf
>> install>/glassfish/lib and restarted GlassFish. Next, I setup a connection pool
>> with the command
>>
>> ./bin/asadmin create-jdbc-connection-pool --datasourceclassname
>> oracle.jdbc.pool.OracleDataSource --restype javax.sql.DataSource --property
>> "user=astro:password=astro:url=jdbc:oracle:thin:@localhost:1521:xe" astro
>
> I found out that I need to escape the colons in the url property with \\ in
> order for the url to be set correctly. This, unfortunately, is not the cause of
> the error. I still get a ClassNotFoundException.
>
>
> Greets, Wouter
>