This is a reposting since I haven't got any answer yet.
It is about the NullPointerException in class Connection
of MySQL Connector/J 2.0.14.
I just changed the driver to MySQL Connector/J 2.0.14.
But I'm still getting this NullPointerException once in
a while. The new StackTrace is:
java.lang.NullPointerException
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.Connection.setAutoCommit(Unknown Source)
at
org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnect
ion.java:237)
at
org.apache.commons.dbcp.PoolableConnectionFactory.activateObject(PoolableCon
nectionFactory.java:273)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown
Source)
at
org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool
.java:117)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja
va:110)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3
12)
at
org.apache.struts.util.GenericDataSource.getConnection(GenericDataSource.jav
a:276)
at de.mytest.fe.BaseAction.getConnection(BaseAction.java:36)
The application works for a long time and the exception occurs just
once in a while. I still don't know where to look for the cause.
The application gets its connections through a DataSource defined in
Struts' config file (struts-config.xml), which in turn uses Jakarta's
DBCP 1.0 (Database Connection Pool). I'm using Struts 1.1b2.
The parameters for the DataSource are as follows:
<data-source>
<set-property property="autoCommit"
value="true"/>
<set-property property="description"
value="Data Source for MySQL"/>
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver"/>
<set-property property="maxCount"
value="10"/>
<set-property property="minCount"
value="2"/>
<set-property property="password"
value="*******"/>
<set-property property="url"
value="jdbc:mysql://localhost:3306/somedb?autoReconnect=true"/>
<set-property property="user"
value="******"/>
<set-property property="autoReconnect"
value="true"/>
</data-source>
(The double "autoReconnect" was used to make sure, DBCP auto reconnects.
Since we have no access to the Servers, we couldn't figure out, which one
does the job -- the one in the url, or the extra paramter. However, this
is not the problem. AutoReconnect works).
Help greatly appreciated!
Thanks in advance,
Holger
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Holger Wiechert wrote:
> Hi,
>
> I'm having a quite serious problem. I wrote a web application that uses
> MySQL via ConnectorJ V2.0.6 in combination with Apache's DBCP 1.0
> (Jakarta Commons Database Connection Pool).
> The web application is installed on a server, I don't have access to.
> The same for the MySQL server.
> Once in a while, I get a NullPointerException and have no clue about
> the reason: DBCP, the JDBC driver, or MySQL.
> Once the exception occurred, it comes up with every new connection
> retrieval.
> I really wonder about the NullPointerexception, which seems to me like
> a ConnectorJ-Bug, but I'm not sure at all.
>
> java.lang.NullPointerException
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:863)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:857)
> at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:474)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Connector/J Package Names start with com.mysql.jdbc
This is not MySQL Connector/J, it is MM.MySQL, which is what MySQL
Connector/J used to be called (and a rather old version at that).
Please try upgrading to MySQL Connector/J 2.0.14 or 3.0.5 from
http://www.mysql.com/products/connector-j/ and see if your problem goes
away.
-Mark
____________
Virus checked by G DATA AntiVirusKit
Virus news: www.antiviruslab.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
