dev@glassfish.java.net

Re: Urgent help: Connection Pool Properties

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Tue, 17 Jun 2008 20:03:50 +0530

Is postgres jdbc driver available for GlassFish ?
eg: GF_INSTALL_DIR/domains/<domainname>/lib

You can refer :
http://blogs.sun.com/JagadishPrasath/entry/jdbc_connection_pool_templates_glassfish
for appropriate properties for Postgres.

Thanks,
-Jagadish


On Tue, 2008-06-17 at 11:21 -0300, Lee Andrew wrote:
> Hi,
>
> I am setting up a connection pool that points to a PostgreSQL
> database. Both, the application server and the database are
> installed in the same server.
>
> I am receiving the error message "Class name is wrong or classpath is
> not set for : org.postgresql.ds.PGSimpleDataSource"
> when I press the "Ping" button in the General tab of the connection
> pool.
>
> The general settings are:
> Name: LocalPostgreTest
> DataSource Classname: org.postgresql.ds.PGSimpleDataSource
> Resource type: javax.sql.DataSource
>
> The additional parameters are:
> databaseName=test
> portNumber=5432
> driverClass=org.postgresql.Driver
> URL=jdbc:postgresql://localhost:5432/test
> serverName=localhost
> password=125015%hort
> user=alea
>
> The database is configured to accept local connections and I
> also have another application server in my desktop that is
> accessing the database normally using the fixed IP address
> instead of the localhost and is working fine.
>
> Can anybody help me fix this issue?
>
> Regards,
>
> --
> Lee Andrew | Development | Alea Management & Technology Solution