Tomcat Realm

[Naseem Khan]

Hi,
I have set JDBC Realm in Tomcat container as:

<Realm className="org.apache.catalina.realm.JDBCRealm" 
debug="99" driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@localhost:1521:XE"
connectionName="scott"
connectionPassword="tiger"
userTable="users" userNameCol="user_name" userCredCol="user_pass"
userRoleTable="user_roles" roleNameCol="role_name" digest="SHA"/>

Now, I want to insert record in one more table (say reports table). How do I configure this table in Realm.

One option is by simply getting connection from connection pool, but in that case, I have to configure in my <Resource> tag within <Context> tag.

Can I configure my new table in the Realm without looking jndi datasource.

Thanks

[Ulf Dittmer]

Realms have no facilities for inserting/updating/deleting records, or accessing tables other than the ones used for authentication.

You need to define the database as a DataSource as well; why wouldn't you want to do that?