users@glassfish.java.net

Glassfish v3 connection pool problems

From: <glassfish_at_javadesktop.org>
Date: Thu, 29 Oct 2009 09:05:25 PDT

Hi to all. Continuing my journy with Glassfish v3 I began to port a project from Glassfish v2.1 with eclipselink to Glassfish v3 b70 (latest) build. I use MySql database and I set all standart settings in the web admin console connection pool. I put the mysql jdbc driver in .../glassfish/domains/domain1/lib folder. When I try to [b] Ping [/b] i get the following exception:
[code]
SEVERE: jdbc.exc_jb_val
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
...

Caused by: java.lang.RuntimeException: The connection property 'largeRowSizeThreshold' only accepts integer values. The value '' can not be converted to an integer.
        at com.mysql.jdbc.ConnectionPropertiesImpl.setLargeRowSizeThreshold(ConnectionPropertiesImpl.java:4293)
        ... 75 more
Caused by: java.sql.SQLException: The connection property 'largeRowSizeThreshold' only accepts integer values. The value '' can not be converted to an integer.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
...

[/code]

So I change the property 'largeRowSizeThreshold' to 10 to be an int and different from empty string '' and saved. When i again clicked the [b] Ping [/b] button I get:
[code]
java.sql.SQLException: "Unable to create properties transform instance '' due to underlying exception: java.lang.ClassNotFoundException: " com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:663) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:277) com.mysql.jdbc.jdbc2.op...[/code]

When I stop and start the application server again I get the same error. It the server.log i have the following:[code]WARNING: Connection could not be allocated because: Unable to create properties transform instance '' due to underlying exception: java.lang.ClassNotFoundException: [/code]

Any idea what could be wrong?
[Message sent by forum member 'dpandulev' (deyan.pandulev_at_gmail.com)]

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