DO NOT REPLY [Bug 22677] - JNDI not working in Default Context

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22677>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22677

JNDI not working in Default Context





------- Additional Comments From [EMAIL PROTECTED]  2003-10-20 11:10 -------
I have been dealing with the same problem for a few days and managed to find 
one solution for it.
I'm using Tomcat 4.1.27 and Sybase database running on Win2K(also tried in XP 
and same assembly worked fine).

In my server.xml I have Context under <host> as follows:

<Context path="/MyApp" 
         docBase="MyApp"
         debug="5" 
         reloadable="true" 
         crossContext="true">           
   <Resource name="jdbc/dbref"
             auth="Container"
             type="javax.sql.DataSource"/>      
  <ResourceParams name="jdbc/dbref">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>10</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
     <name>username</name>
     <value>report</value>
    </parameter>
    <parameter>
     <name>password</name>
     <value>report</value>
    </parameter>
    <parameter>
       <name>driverClassName</name>
       <value>com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource</value>
    </parameter>        
    <parameter>
      <name>url</name>
      <value>jdbc:sybase:Tds:xxx:5000/dbname</value>
    </parameter>            
    <parameter>
      <name>removeAbandoned</name>
      <value>true</value>
          </parameter>
          <parameter>
      <name>removeAbandonedTimeout</name>
      <value>60</value>
    </parameter>
  </ResourceParams>
</Context>      

In my web.xml I have:

<resource-ref>
   <description>Sybase Datasource</description>
   <res-ref-name>jdbc/dbref</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <res-auth>Container</res-auth>
</resource-ref>

,and in Java:
Context initContext = new InitialContext();
Context envContext  = (Context)initContext.lookup("java:/comp/env");
dataSource = (javax.sql.DataSource)envContext.lookup(dataSourceName);
Connection con = dataSource.getConnection();

I installed Java 2 Runtime Environment 1.4.2_01 and modified system variables:
JAVA_HOME = "j2re 1.4.2_01 install dir"
CLASSPATH = "3rd party database driver jar directory"
CATALINA_HOME = "Tomcat install dir"

Although Jakarta Tomcat 4.1 "JNDI Datasource HOW-TO" docs adviced not to 
install 3rd party database drivers anywhere else than in 
$CATALINA_HOME/common/lib I tried adding jar into CLASSPATH and it worked fine.
Make sure you have jre installed and JAVA_HOME set into that dir and it should 
work fine.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]