JDBC realm doesn't work with Mac OX X

[Paul Phillips <pa...@partitura.com>]

I have an Application that is running fine with Tomcat 4.03 on Solaris with 
Java 1.4.  This application uses JDBC Realm for form based authentication. 
Mysql is the database backend.

I decided to move the application to Mac OS X (Version 10.1.4).  I moved 
the database over, checked it out, it is fine.  I installed Tomcat, it 
starts up fine - ran a couple of the example servlets, fine.  I installed 
the mysql jdbc driver just like it is installed on the Solaris box.

Then I moved over my application, and copied the server.xml file from the 
Solaris box.  Now, Tomcat won't start!!  If I comment out the Realm lines 
in the server.xml file, then Tomcat will startup (but of course 
authentication won't work).

I have run a test java program from the console, and find that it can 
connect to the database and perform a task using jdbc, so the database and 
jdbc seem to function Ok under OS X.

I can't even think of what might be wrong.  Here are the realm lines from 
my server.xml:

<Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
             driverName="org.gjt.mm.mysql.Driver"
 
connectionURL="jdbc:mysql://localhost/dbName?user=dbUser&amp;password=dbPas
sword"
              userTable="dbTable" userNameCol="login" userCredCol="password"
          userRoleTable="roles" roleNameCol="role" />

If these lines are in server.xml, then tomcat won't even start - the log 
file reports that it hangs right after seeding the random generator for my 
application.

Any ideas of where I should begin looking for problems?

Thanks!
Paul Phillips

PS - By the way, I have tried changing the URL to remove the &amp - that 
doesn't fix the problem...



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