Setting a JDBCStore question

[Renaud Casanova <re...@windriver.com>]

Hello,

I have been trying to set up a mysql JDBC Store with tomcat 4.0.3
After creating the database and setting the right permissions I modified
the
server.xml accordingly:

<Manager className="org.apache.catalina.session.PersistentManager"
  debug="99"
  saveOnRestart="true"
  maxActiveSessions="-1"
  minIdleSwap="-1"
  maxIdleSwap="-1"
  maxIdleBackup="-1">
  <Store className="org.apache.catalina.session.JDBCStore"
  driverName="com.mysql.jdbc.Driver"

connectionURL="jdbc:mysql://localhost/tomcatsessions?user=test;password=test"

  sessionTable="sessions"
  sessionIdCol="id"
  sessionDataCol="data"
  sessionValidCol="valid"
  sessionMaxInactiveCol="maxinactive"
  sessionLastAccessedCol="lastaccess"
  checkInterval="60"
  debug="99" />
 </Manager>

After restarting tomcat I get the following error in my web app log
file:
2002-08-16 10:28:59 JDBCStore[/renapp]: A SQL exception occurred
java.sql.SQLExc
eption: General error: Access denied for user: '@localhost' to database
'tomcats
essions'

It looks like the user and password parameters are not read from the
connection URL.

Am I missing something obvious here?

Any help appreciated

Thanks

    Renaud


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>