can't connect to my Datasource Oracle

[Yannick Monclin]

hi,
i try to configure my datasource in order to use it with oracle, all is 
ok, but when i execute my jsp, he find the jndi name create the 
datasource (i think.... because i don't know how to see it ? in the logs 
?) and when he execute ds.getConnection() i have no answer, no error 
from my server but connexion isn't created....and he stop to execute 
code here

someone could help me
thanks
Yannick


I use an oracle 7.3, i have tomcat 4.1.18, driver classes111.jar, jdk 
1.4, XP
this is my server.xml and my web.xml

<Context className="org.apache.catalina.core.StandardContext" 
cachingAllowed="true" 
charsetMapperClass="org.apache.catalina.util.CharsetMapper" 
cookies="true" crossContext="true" debug="0" displayName="Tomcat Heures 
Comp" docBase="c:\Tomcat 4.1\webapps\heurescomp" 
mapperClass="org.apache.catalina.core.StandardContextMapper" 
path="/heurescomp" privileged="false" reloadable="true" 
swallowOutput="false" useNaming="true" 
wrapperClass="org.apache.catalina.core.StandardWrapper">
         <Logger className="org.apache.catalina.logger.FileLogger" 
debug="9" directory="logs" prefix="heures_comp" suffix=".txt" 
timestamp="true" verbosity="4"/>
         <Resource auth="Container" name="jdbc/myoracle" 
scope="Shareable" type="javax.sql.DataSource"/>
         <ResourceParams name="jdbc/myoracle">
           <parameter>
             <name>validationQuery</name>
             <value>select * from tab;</value>
           </parameter>
           <parameter>
             <name>password</name>
             <value>xxxx</value>
           </parameter>
           <parameter>
             <name>maxWait</name>
             <value>10000</value>
           </parameter>
           <parameter>
             <name>maxActive</name>
             <value>4</value>
           </parameter>
           <parameter>
             <name>url</name>
             <value>jdbc:oracle:thin:@192.168.1.1:1521:ccomp</value>
           </parameter>
           <parameter>
             <name>driverClassName</name>
             <value>oracle.jdbc.driver.OracleDriver</value>
           </parameter>
           <parameter>
             <name>username</name>
             <value>xxxx</value>
           </parameter>
           <parameter>
             <name>maxIdle</name>
             <value>2</value>
           </parameter>
         </ResourceParams>
       </Context>



web.xml

<web-app>
 <resource-ref>
    <description>Oracle Datasource</description>
   <res-ref-name>jdbc/myoracle</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <res-auth>Container</res-auth>
 </resource-ref>
</web-app>
and my jsp code
.....
// connexion datasource JNDI
Context initCtx = new InitialContext();
System.out.println("Creation Context ok= "+initCtx);
Context envCtx = (Context)initCtx.lookup("java:/comp/env");
System.out.println("init context ok= "+envCtx);
DataSource ds = (DataSource)envCtx.lookup("jdbc/myoracle");
System.out.println("init datasource ok= "+ds);
Connection conn = ds.getConnection();
System.out.println("Connecté");
....
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]