users@glassfish.java.net

Re: simple question about "connection pools" and datasource

From: Shreedhar Ganapathy <Shreedhar.Ganapathy_at_Sun.COM>
Date: Thu, 22 May 2008 11:47:25 -0700

Could you try doing the ping after restarting GF domain admin server
after placing the jar in the lib dir ?

glassfish_at_javadesktop.org wrote:
> Hello everybody, excuse me for my bad english.
>
> I am trying to create a datasource for hsql in the glassfish server admin console
> So, I first have to create a connection pool.
> For the "datasource classname" property, I set: org.hsqldb.jdbc.jdbcDatasource and I put hsqldb.jar in $GLASSFISH_HOME/lib/
> But after steps, when I try to use the ping from the server admin console, I have the following error:
> "Class name is wrong or classpath is not set for : org.hsqldb.jdbc.jdbcDatasource"
>
> Should I copy hsqldb.jar somewhere else?
>
> Thank you in advance.
>
>
> (
> As I am a beginner with j2e application servers, I will write here properties I edit myself during the creation of my connection pool in case someone see an error:
>
> password | apassword
> user | auser
> database | mydatabasename
> url | hsqldb:hsql://localhost
>
> There is something else not really clear for me, in report with datasources.
> When we create a datasource from an xml file for hsqldb, generally, the only class we have to set is: <driver-class>org.hsqldb.jdbcDriver</driver-class>
> But if I use this in the "datasource classname", I have the following error:
> "org.hsqldb.jdbcDriver cannot be cast to javax.sql.DataSource"
> I suppose it comes from the difference between connection pool and data source, but it's strange for me (and the org.hsqldb.jdbcDriver is never required apparently during the datasource creation process with the server admin console). So, it is not really clear for me.
>
> )
> [Message sent by forum member 'rageice' (rageice)]
>
> http://forums.java.net/jive/thread.jspa?messageID=275956
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>