E
Ed
Trying to connect to two different databases and utilizing the password
protection in my application using similar code below:
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="sun.jdbc.odbc.JdbcOdbcDriver"
connectionURL="jdbcdbc:Test"
connectionName="anything"
connectionPassword="anything"
digest="SHA"
userTable="Users" userNameCol="UserName"
userCredCol="UserPassword"
userRoleTable="Users" roleNameCol="RoleTomcat" />
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="sun.jdbc.odbc.JdbcOdbcDriver"
connectionURL="jdbcdbc:Test2"
connectionName="anything"
connectionPassword="anything"
digest="SHA"
userTable="Users" userNameCol="UserName"
userCredCol="UserPassword"
userRoleTable="Users" roleNameCol="RoleTomcat" />
When I use the above code it only authenticates against the first database
via the ODBC connection Test and not Test2.
Essentially what I want to do is to declare more then one connectionURL
because all the other information is the same. Is this possible or am I on
the wrong track?
Thanks for any help!
Ed
protection in my application using similar code below:
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="sun.jdbc.odbc.JdbcOdbcDriver"
connectionURL="jdbcdbc:Test"
connectionName="anything"
connectionPassword="anything"
digest="SHA"
userTable="Users" userNameCol="UserName"
userCredCol="UserPassword"
userRoleTable="Users" roleNameCol="RoleTomcat" />
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="sun.jdbc.odbc.JdbcOdbcDriver"
connectionURL="jdbcdbc:Test2"
connectionName="anything"
connectionPassword="anything"
digest="SHA"
userTable="Users" userNameCol="UserName"
userCredCol="UserPassword"
userRoleTable="Users" roleNameCol="RoleTomcat" />
When I use the above code it only authenticates against the first database
via the ODBC connection Test and not Test2.
Essentially what I want to do is to declare more then one connectionURL
because all the other information is the same. Is this possible or am I on
the wrong track?
Thanks for any help!
Ed