tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roberts, Eric" <Eric.Robe...@one.at>
Subject RE: help with DataSourceRealm in 4.1.17
Date Fri, 20 Dec 2002 10:09:58 GMT
Hi,

Try just "jdbc/db".

HTH

-----Original Message-----
From: Kevin HaleBoyes [mailto:kzboyes@yahoo.com]
Sent: Donnerstag, 19. Dezember 2002 20:05
To: tomcat-user@jakarta.apache.org
Subject: help with DataSourceRealm in 4.1.17


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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


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


Mime
View raw message