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