I've been using JDBCRealm successfully in my application but
jumped on the DataSourceRealm when I saw it in 4.1.17.
So, I replaced my JDBCRealm definition to the DataSourceRealm
but have run into a problem. I have the following in the
CATALINA_HOME/webapps/cml.xml file:
<Context path="/cml"
docBase="/usr/local/jakarta/cml"
debug="99"
privileged="false">
<Resource name="jdbc/Db" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/Db">
<parameter><name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>
<parameter><name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:oracle:thin:@200.65.6.188:1521:tiggs9i</value></parameter>
<parameter><name>username</name>
<value>cml</value></parameter>
<parameter><name>password</name>
<value>cml</value></parameter>
<parameter><name>maxActive</name>
<value>20</value></parameter>
<parameter><name>maxIdle</name>
<value>10</value></parameter>
<parameter><name>maxWait</name>
<value>-1</value></parameter>
<parameter><name>validationQuery</name>
<value>select sysdate from
dual</value></parameter>
</ResourceParams>
<Realm className="org.apache.catalina.realm.DataSourceRealm"
debug="99"
dataSourceName="java:comp/env/jdbc/Db"
userTable="mmis_users"
userNameCol="user_name"
userCredCol="user_pass"
userRoleTable="mmis_user_roles"
roleNameCol="role_name"
digest="MD5"
/>
</Context>
I know the jdbc/Db JNDI resource is configured properly because
I'm able to access the datasource from the application using:
Context initCtx = new InitialContext();
Context envCtx = (Context)initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/Db");
return ds.getConnection();
but when Tomcat starts up I get the following error:
2002-12-19 14:55:01 DataSourceRealm[/cml]: Exception performing
authentication
javax.naming.NameNotFoundException: Name java:comp is not bound in
this Context
at
org.apache.naming.NamingContext.lookup(NamingContext.java:811)
at
org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at
org.apache.catalina.realm.DataSourceRealm.open(DataSourceRealm.java:463)
at
org.apache.catalina.realm.DataSourceRealm.start(DataSourceRealm.java:582)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3543)
etc...
I even tried using
dataSourceName="java:/comp/env/jdbc/Db"
in the Realm definition (note the slash after the colon as
was shown in the Realm HOW-TO) but this gave a similar exception.
Does anyone know what name I should use for the data source?
Thanks,
Kevin.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
