NumberFormatException on initializePropsFromServer

maydox <[email protected]> Fri, 14 Sep 2007 08:46:49 -0700 (PDT)
Newsgroups gmane.comp.db.mysql.java
Message-ID <[email protected]>
Our mysql 4.1 DB recently hit the maximum number of allowed connections,
immediate effects were that replication began to fail and our Java apps
running through tomcat could no longer establish connections (even after
more became available).

Here is the stack trace (using mysql-connector-java-5.0.5.jar):

java.lang.NumberFormatException
MESSAGE: For input string: ""

STACKTRACE:
java.lang.NumberFormatException: For input string: ""
at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:468)
at java.lang.Integer.parseInt(Integer.java:497)
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4031)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2756)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

...

What is puzzling is that the PHP applications continued to function while
the driver continued to throw this stack trace.  Tomcat was only able to
reestablish a connection through the connector after the db was restarted.  

Has anyone seen this type of behavior before?  I searched the bug database
and this archive and haven't seen anything quite like this.


-- 
View this message in context: http://www.nabble.com/NumberFormatException-on-initializePropsFromServer-tf4443445.html#a12678206
Sent from the MySQL - Java mailing list archive at Nabble.com.


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]