Dear all,
Like several persons, I got this "null DataSource". I read several
mails, but i didn't find any answer.(example:
http://www.mail-archive.com/tomcat-user@jakarta.apache.org/msg44065.html).
So I am trying to define the problem as accurate as possible :
Environment definition :
------------------------
- Running Tomcat v4.02 under Linux (installation directory :
/usr/local/jakarta-tomcat-4.0.2)
- Starting developping my web application with asimple JSP page
(installation directory : /home/james/myWebProject/)
- Creating subdirectrories /home/james/myWebProject/WEB-INF/ and
/home/james/myWebProject/WEB-INF/lib/
- Using Oracle 8 on my database server named ukki, and copying the
Oracle
driver in /home/james/myWebProject/WEB-INF/lib/
- The instance of my databse is named : develdb
My server.xml file (in /usr/local/jakarta-tomcat-4.0.2/conf) :
--------------------------------------------------------------
...
<!-- Define the Tomcat Stand-Alone Service -->
<Service name="Tomcat-Standalone">
...
<!-- Define the top level container in our container hierarchy -->
<Engine name="Standalone" defaultHost="localhost" debug="0">
...
<!-- Define the default virtual host -->
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true">
...
<Context path="/Test" docBase="/home/james/myWebProject/"
debug="4" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_test." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/myDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myDB">
<parameter>
<name>user</name>
<value>james</value>
</parameter>
<parameter>
<name>password</name>
<value>bond007</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:oracle:thin:@ukki:1521:develdb</value>
</parameter>
</ResourceParams>
</Context>
...
</Host>
</Engine>
</Service>
...
and my "web.xml" file (in /home/james/myWebProject/WEB-INF/) :
--------------------------------------------------------------
...
<resource-ref>
<description>
Resource reference to a factory for
java.sql.Connection
</description>
<res-ref-name>jdbc/myDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
...
To start Tomcat :
-----------------
/usr/local/jakarta-tomcat-4.0.2/bin/startup.sh
and i got the following traces :
2002-02-15 15:15:42 StandardContext[/Test]: Starting
2002-02-15 15:15:42 StandardContext[/Test]: Processing start(), current
available=false
2002-02-15 15:15:42 StandardContext[/Test]: Configuring default
Resources
2002-02-15 15:15:42 StandardContext[/Test]: Configuring non-privileged
default Loader
2002-02-15 15:15:42 StandardContext[/Test]: Configuring default Manager
2002-02-15 15:15:42 StandardContext[/Test]: Processing standard
container startup
2002-02-15 15:15:42 WebappLoader[/Test]: Deploying class repositories to
work directory /usr/local/jakarta-tomcat-4.0.2/work/localhost/Test
2002-02-15 15:15:42 WebappLoader[/Test]: Deploy JAR
/WEB-INF/lib/oracledr.jar to
/home/james/myWebProject/WEB-INF/lib/oracledr.jar
2002-02-15 15:15:42 WebappLoader[/Test]: Reloading checks are enabled
for this Context
2002-02-15 15:15:42 StandardManager[/Test]: Seeding random number
generator class java.security.SecureRandom
2002-02-15 15:15:42 StandardManager[/Test]: Seeding of random number
generator has been completed
2002-02-15 15:15:42 ContextConfig[/Test]: ContextConfig: Processing
START
2002-02-15 15:15:43 StandardContext[/Test]: Setting deployment
descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application
2.3//EN'
2002-02-15 15:15:43 StandardContext[/Test]: Setting deployment
descriptor public ID to '-//Sun Microsystems, Inc.//DTD Web Application
2.2//EN'
2002-02-15 15:15:43 ContextConfig[/Test]: Scanning web.xml tag libraries
2002-02-15 15:15:43 ContextConfig[/Test]: Scanning library JAR files
2002-02-15 15:15:43 ContextConfig[/Test]:
tldConfigJar(/WEB-INF/lib/oracledr.jar): java.io.IOException: No such
file or directory
2002-02-15 15:15:43 Authenticator[/Test]: No SingleSignOn Valve is
present
2002-02-15 15:15:43 ContextConfig[/Test]: Configured an authenticator
for method BASIC
2002-02-15 15:15:43 ContextConfig[/Test]: Pipline Configuration:
2002-02-15 15:15:43 ContextConfig[/Test]:
org.apache.catalina.authenticator.BasicAuthenticator/1.0
2002-02-15 15:15:43 ContextConfig[/Test]:
org.apache.catalina.core.StandardContextValve/1.0
2002-02-15 15:15:43 ContextConfig[/Test]: ======================
2002-02-15 15:15:43 StandardContext[/Test]: Configuring application
event listeners
2002-02-15 15:15:43 StandardContext[/Test]: Sending application start
events
2002-02-15 15:15:43 StandardContext[/Test]: Starting filters
2002-02-15 15:15:43 StandardContext[/Test]: Posting standard context
attributes
2002-02-15 15:15:43 StandardWrapper[/Test:default]: Loading container
servlet default
2002-02-15 15:15:43 default: init
2002-02-15 15:15:43 StandardWrapper[/Test:invoker]: Loading container
servlet invoker
2002-02-15 15:15:43 invoker: init
2002-02-15 15:15:43 jsp: init
2002-02-15 15:15:44 StandardContext[/Test]: Starting completed
<<<< 1st PROBLEM >>>>
2002-02-15 15:15:43 ContextConfig[/Test]: Scanning library JAR files
2002-02-15 15:15:43 ContextConfig[/Test]:
tldConfigJar(/WEB-INF/lib/oracledr.jar): java.io.IOException: No such
file or directory
<<<< 1st PROBLEM >>>>
Then I use a simple jsp page to execute a simple SQL statement :
----------------------------------------------------------------
...
// Obtain our environment naming context
initCtx = new javax.naming.InitialContext();
envCtx = (Context) initCtx.lookup("java:comp/env");
// Look up our data source
DataSource ds = (DataSource) envCtx.lookup("jdbc/myDB");
<<<< 2nd PROBLEM >>>>
=> Then the DataSource is always null.
<<<< 2nd PROBLEM >>>>
Did someone already find a solution ?
Thanks in advance for your answers,
Fred.
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
