Is Oracle driver (classes111.zip) visible to Tomcat. I had to modify (in Linux) catalina.sh script to add driver's path to the internal CLASSPATH used by catalina.
Martin Miranda wrote: > > Hello > > Im having problems creating a DataSource in a StandAlone Tomcat 4.0.1 > with Windows XP. The InitialContext find the DataSource but it cames > null > > This is the Code: > > <% > InitialContext ctxinit = new InitialContext(); > %> > <%= ctxinit.lookup("java:/comp/env/jdbc/testDB") %> << NULL > You get EnabledDataSource instance above so you have to cast. May it's be better like this: <% DataSource ds = (DataSource) ctxinit.lookup("java:/comp/env/jdbc/testDB") %> <%= ds %> Also all examples doing this way: Context ctx = new InitialContext(); Context envCtx = (Context)ctx.lookup("java:comp/env"); ds = (DataSource)envCtx.lookup("jdbc/testDB"); Try that just in case. So your case must work!! Though I don't advise you to use EnabledDataSource (Tyrex stuff) for production - it doesn't provide connection pool. Use commons/dbcp. I tested it - it works fine (besides Tomcat 4.0.4-b1 - nothing work there). > In the web application deployment descriptor (web.xml) i have this code: > > <resource-ref> > <description>Resource reference to a factory for java.sql.Connection > instances that may be used for talking to a particular database that is > configured in the server.xml file.</description> > <res-ref-name>jdbc/testDB</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > In the server.xml file: > > <Context path="/test" docBase="test/" debug="1" privileged="true" > reloadable="true" useNaming="true"> > > <Resource name="jdbc/testDB" auth="Container" > type="javax.sql.DataSource" description="Default Database for > Applications" /> > > <ResourceParams name="jdbc/testDB"> > <parameter> > <name>driverClassName</name> > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>driverName</name> > <value>jdbc:oracle:thin:@dir</value> > </parameter> > <parameter> > <name>user</name> > <value>usuario1</value> > </parameter> > <parameter> > <name>password</name> > <value>password1</value> > </parameter> > </ResourceParams> > </Context> > > When i use debug level 1 in the context the logs seems normal: > > XmlMapper: org.apache.catalina.core.StandardContext.setSessionTimeout( > 30) > XmlMapper: org.apache.catalina.core.StandardContext.addMimeMapping( > html, text/html) > XmlMapper: org.apache.catalina.core.StandardContext.addMimeMapping( txt, > text/plain) > XmlMapper: org.apache.catalina.core.StandardContext.addWelcomeFile( > index.jsp) > XmlMapper: org.apache.catalina.core.StandardContext.addWelcomeFile( > index.html) > XmlMapper: new null org.apache.catalina.deploy.ContextResource > resource-ref ContextResource[name=null, scope=Shareable] > XmlMapper: org.apache.catalina.deploy.ContextResource.setDescription( > Resource reference to a factory for java.sql.Connection instances that > may be used for talking to a particular database that is configured in > the server.xml file.) > XmlMapper: org.apache.catalina.deploy.ContextResource.setName( > jdbc/testDB) > XmlMapper: org.apache.catalina.deploy.ContextResource.setType( > javax.sql.DataSource) > XmlMapper: org.apache.catalina.deploy.ContextResource.setAuth( > Container) > XmlMapper: Calling org.apache.catalina.core.StandardContext.addResource > ContextResource[name=jdbc/testDB, description=Resource reference to a > factory for java.sql.Connection instances that may be used for talking > to a particular database that is configured in the server.xml file., > type=javax.sql.DataSource, auth=Container, scope=Shareable] > XmlMapper: pop resource-ref org.apache.catalina.deploy.ContextResource: > ContextResource[name=jdbc/testDB, description=Resource reference to a > factory for java.sql.Connection instances that may be used for talking > to a particular database that is configured in the server.xml file., > type=javax.sql.DataSource, auth=Container, scope=Shareable] > > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> -- Lev Assinovsky Peterlink Web Programmer St. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>