Sorry, further testing showed that Tomcat was locating one of my databases,
but not the one I thought. It was locating a database in
%CATALINA_HOME%/data. So the database location and connectionURL which I
posted previously are not consistent. Here is the corrected database
location:
* Locate the HSQLDB database files in %CATALINA_HOME%/data
Here is the complete corrected Info:
* Locate hsqldb.jar in %CATALINA_HOME%/common/lib
* Locate the HSQLDB database files in %CATALINA_HOME%/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" />
--
View this message in context:
http://www.nabble.com/Using-HSQLDB-for-Authentication-tf4208687.html#a12478808
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]
