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)
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)
Actually, I use a DataSource, provided by Struts 1.1b2, which in turn uses
DBCP. 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).
The responsibles from the server park (university owned) swear that
they aren't doing anything wrong, whatever that means. So maybe the
problem is there, who knows when you don't run your own servers.
Does anybody can give me a hint on how to proceed? Time is running away
and -- as usual -- the application should have been stable last week...
Please send a CC to [EMAIL PROTECTED]
Thanks for your time,
Holger
____________
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
