users@glassfish.java.net

RE: Re: Connection Pool Issue

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Wed, 12 Apr 2006 09:34:59 +0530

Hi Jason,
No, GlassFish AS does not build the URL.
Please let us know if you have used an implementation where the URL is
automatically constructed. (for any driver)

Thanks,
-Jagadish

On Tue, 2006-04-11 at 11:21 -0500, Jason Lee wrote:
> Adding the URL property did the trick. Being new to GF (and SJSAS), I
> assumed you had to let it build the URL for you. Thanks for the
> tip! :)
>
> --
> Jason Lee
> Programmer/Analyst
>
>
>
>
>
> ______________________________________________________________________
> From: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> Sent: Monday, April 10, 2006 10:53 PM
> To: users_at_glassfish.dev.java.net
> Cc: Jason Lee
> Subject: Re: Connection Pool Issue
>
>
>
>
> Hi Jason,
> Can you post the server.log stack trace that you get during ping.
>
> It seems like URL property is not specified or specified in incorrect
> format.
> >From the website you have mentioned, dev guide explains about the URL
> format.
>
> Try specifying the URL property like this.
> <property name="URL"
> value="jdbc:sequoia://hostname:port_number/database_name" />
>
> Thanks,
> -Jagadish
>
> On Mon, 2006-04-10 at 16:42 -0500, Jason Lee wrote:
>
> > I'm trying to add a connection pool for Sequoia
> > (http://sequoia.continuent.org). I have it added, but when I ping it, I
> > get:
> >
> > Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
> > Target exception message: Connection could not be allocated because:
> > Invalid null URL in connect
> >
> > That's all the information I can find on it. The driver is available to
> > the server, and I'm pretty sure the class name is correct, though I'll
> > double check. The properties for the pool are:
> >
> > <jdbc-connection-pool allow-non-component-callers="false"
> > connection-validation-method="auto-commit"
> > datasource-classname="org.continuent.sequoia.driver.DataSource"
> > fail-all-connections="false" idle-timeout-in-seconds="300"
> > is-connection-validation-required="false"
> > is-isolation-level-guaranteed="false"
> > max-pool-size="32" max-wait-time-in-millis="60000"
> > name="SequoiaInvyPool"
> > non-transactional-connections="false" pool-resize-quantity="2"
> > res-type="javax.sql.DataSource" steady-pool-size="8">
> > <property name="serverName" value="localhost"/>
> > <property name="user" value="foo"/>
> > <property name="databaseName" value="inventorycontrol"/>
> > <property name="password" value="foo"/>
> > <property name="datasourceName" value="inventorycontrol"/>
> > <property name="port" value="25322"/>
> > </jdbc-connection-pool>
> >
> > Any hints on how to track this down, or does anything stand out to
> > anyone? :) Thanks a lot!
> >
> > --
> > Jason Lee
> > Programmer/Analyst
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >