remmons wrote: > > I am trying to use HSQLDB for container authentication in Tomcat. When > I start Tomcat, I get this message in the catalina.YYYY-MM-DD.log: > > INFO: Starting Servlet Engine: Apache Tomcat/5.5.23 > Aug 2, 2007 3:10:29 PM org.apache.catalina.realm.JDBCRealm start > SEVERE: Exception opening database connection > java.sql.SQLException: The database is already in use by another > process: [EMAIL PROTECTED] > =\\localhost\data\Auth.lck, exists=false, locked=false, valid=false, fl > =null]: java.io.FileNotFoundException: \\localhost\data\Auth.lck (The > network path was not found) > > Apparently, Tomcat cannot find my database files. Without success, I > have located them in various places: > > webbapps/MyApp/WEB-INF/data > webbapps/MyApp/WEB-INF/classes/data > webbapps/MyApp/WEB-INF/lib/data > webapps/data > > I am using the following connectionURL: > > connectionURL="jdbc:hsqldb://localhost/data/Auth" > > where Auth is the name of my HSQLDB database with the following files: > > data/Auth.log > data/Auth.properties > data/Auth.script > > I setup my realm in server.xml as follows: > > <Realm className="org.apache.catalina.realm.JDBCRealm" > driverName="org.hsqldb.jdbcDriver" > connectionURL="jdbc:hsqldb://localhost/data/Auth" > connectionName="SA" connectionPassword="" > userTable="USER" userNameCol="USERNAME" > userCredCol="PASSWORD" > userRoleTable="USER_ROLE" roleNameCol="ROLENAME" /> > > Can someone tell me where to put the database files so Tomcat can find > them? I am using Tomcat 5.5. > > -- > Robert Emmons, P.E., Aurigen Inc. > [EMAIL PROTECTED], http://www.aurigen.com > Computer Programming and Consulting > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > >
In case anyone is interested, I found the secrets to getting Tomcat to use my HSQLDB database for container authentication: * Locate hsqldb.jar in %CATALINA_HOME%/common/lib * Locate the HSQLDB database files in webapps/myApp/data * Use the following Realm element in server.xml: <Realm className="org.apache.catalina.realm.JDBCRealm" driverName="org.hsqldb.jdbcDriver" connectionURL="jdbc:hsqldb:data/Auth" connectionName="SA" connectionPassword="" userTable="USER" userNameCol="USERNAME" userCredCol="PASSWORD" userRoleTable="USER_ROLE" roleNameCol="ROLENAME" /> That is the same Realm element as I used above, except for the connectionURL: * Correct: connectionURL="jdbc:hsqldb:data/Auth" * Incorrect: connectionURL="jdbc:hsqldb:/localhoast/data/Auth" -- View this message in context: http://www.nabble.com/Using-HSQLDB-for-Authentication-tf4208687.html#a12293244 Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]