users@glassfish.java.net

Strange problem GF2 and PostgreSQL

From: <glassfish_at_javadesktop.org>
Date: Mon, 10 Dec 2007 23:56:21 PST

Hi all,
I use GF2, NB6 and JDK6.

While developing my app with NB6 and the bundled GF2 all was fine. I am using Postgres and so on I was using its JDBC drivers (note I use JDBC3 drivers, compiled for JDK5, without any problem).

Later, I downloaded a GF2 distro from the web site, and install following the installation steps without problem, to use a production server (putting drivers into my domain lib directory).

The problem is the same app that runs fine while developing (without any problem log) its crasing when running in the "production" server. I the warning I recive is:

[#|2007-12-11T08:40:12.521+0100|SEVERE|sun-appserver9.1|javax.enterprise.system.container.web|_ThreadID=16;_ThreadName=httpSSLWorkerThread-8080-1;_RequestID=5a7dfbff-3559-4316-82e2-a8b3e6408d3c;|StandardWrapperValve[Faces Servlet]: PWC1406: Servlet.service() for servlet Faces Servlet threw exception
java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3Connection.getClientInfo()Ljava/util/Properties;
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
...
...

If I change the drivers of Postgre to JDBC4 (that use JDK6) and it seems to work but I recevice constantly the log:

[#|2007-12-11T08:44:28.389+0100|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=15;_ThreadName=httpSSLWorkerThread-8080-0;_RequestID=26fc603e-7029-4538-b29e-6f1f7256d31a;|RAR7114: Unable to get ClientInfo for connection
org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4Connection.getClientInfo() is not yet implemented.
        at org.postgresql.Driver.notImplemented(Driver.java:728)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.getClientInfo(AbstractJdbc4Connection.java:73)
        at org.postgresql.jdbc4.Jdbc4Connection.getClientInfo(Jdbc4Connection.java:21)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
...
...
[#|2007-12-11T08:44:28.391+0100|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=15;_ThreadName=httpSSLWorkerThread-8080-0;_RequestID=26fc603e-7029-4538-b29e-6f1f7256d31a;|RAR7115: Unable to set ClientInfo for connection
java.sql.SQLClientInfoException: Not implemented.
        at org.postgresql.jdbc4.AbstractJdbc4Connection.setClientInfo(AbstractJdbc4Connection.java:63)
        at org.postgresql.jdbc4.Jdbc4Connection.setClientInfo(Jdbc4Connection.java:21)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
...
...


Why it is running ok while developing with the bundled GF of NB6 and not in a manually installed server?

Any ideas will be appreciate.
Thanks in advice.
[Message sent by forum member 'asantiago' (asantiago)]

http://forums.java.net/jive/thread.jspa?messageID=249457