users@glassfish.java.net

Re: Connection Pool Issue

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Tue, 11 Apr 2006 09:22:51 +0530

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
>