case sensitivity with JDBCRealm

[Stephen Charles Huey <st...@fastmail.fm>]

Here's our server.xml's Realm element:

<Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@192.168.1.144:1523:orcl"
connectionName="scott" connectionPassword="tiger" userTable="users"
userNameCol="username" userCredCol="password" userRoleTable="roles"
roleNameCol="role" />

Basically out of the textbook...but the problem is, we're moving from
MySQL to Oracle, and the MySQL database wasn't case sensitive when
checking the username.  Is there any way to turn off case sensitivity on
the JDBCRealm side of things when checking the username in the Oracle
database?

Thanks...

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org