PostgreSQL JDBC DataSource class

[luckm]

Hello,
i'm trying to start PostgreSQL based Seam project. During seam setup I selected /home/.../postgresql-8.3-604.jdbc3.jar (downloaded prior to setup, jar path entered correctly) for JDBC Driver and org.postgresql.jdbc3.Jdbc3ConnectionPool as DataSource class. In JbossTools I can connect to DB, reverse-engineered entities are successfully generated, but after project is redeployed, on every page using entities I got exception:

Caused by: java.sql.SQLException: Error in allocating a connection. Cause: org.postgresql.jdbc3.Jdbc3ConnectionPool cannot be cast to javax.sql.DataSource
     at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:115)
     at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
     ... 114 more

Can someone help me get PostgreSQL to work with Seam? Thanks for any advices.

Regards, Luck

[luckm]

Finally I figured it out. I didn't mentioned that I'm deploying to Glassfish. But to make it clear: you can look at http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/PostgreSQL%20with%20Glassfish. Connection pool data source should be configured in GF admin console as javax.sql.ConnectionPoolDataSource instead of default javax.sql.DataSource. After that I had to run command:


asadmin set domain.resources.jdbc-connection-pool.<POOL_NAME>.property.JDBC30DataSource=true


That did the trick - everything worked for me.