Using HSQLDB for Authentication 2007-08-02 - By Robert J Emmons
Back
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: org.hsqldb.persist.NIOLockFile@(protected)[file
=\\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.
remmons@(protected), http://www.aurigen.com
Computer Programming and Consulting
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
|
|
