jdbcrealm MYSQL autoReconnect problem

P

PC

I'm using jdbcrealm to connect mySQL DB.
The following is from my server.xml.
It works well except autoReconnect part.
Every morning when I try to connect I get "Invalid username/password" error
message once.
and when I try again it connects.
Have any one had this problem?
Thanks.


*************************************************
<ResourceParams name="jdbc/mydb">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to
handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>

<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>

<!-- Maximum time to wait for a dB connection to become
available
in ms, in this example 10 seconds. An Exception is thrown
if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>30000</value>
</parameter>

<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>myname</value>
</parameter>
<parameter>
<name>password</name>
<value>mypw</value>
</parameter>

<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>

<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that
the
JDBC Driver will automatically reconnect if mysqld closed
the
connection. mysqld by default closes idle connections
after
8 hours.
-->
<parameter>
<name>url</name>

<value>jdbc:mysql://myserver.comom/mydb?autoReconnect=true</value>
</parameter>

<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>



</ResourceParams>
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="com.mysql.jdbc.Driver"

connectionURL="jdbc:mysql://myserver.com/mydb?user=myname&amp;password=mypw"
userTable="users"
userNameCol="user_login"
userCredCol="user_password"
userRoleTable="user_role"
roleNameCol="user_role"/>
<!--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,795
Messages
2,569,644
Members
45,358
Latest member
TreyTritt8

Latest Threads

Top