Hi all,
this is the first time I try to connect to a database from Tomcat.
So I searched for (and found) examples and tutorials on how to do it. Most
noticeably
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html
.
The thing is ... it doesn't work.
In server.xml I defined this:
<Context path="/sp2" debug="10" docBase="sp2" reloadable="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="sp2."
suffix=".log" />
<Resource name="jdbc/sp2" auth="Container" type="javax.sql.DataSource" />
<ResourceParams name="jdbc/sp2">
<parameter> <name>driverClassName</name>
<value>org.postgresql.Driver</value> </parameter>
<parameter> <name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter>
<parameter> <name>username</name> <value>stnt1</value> </parameter>
<parameter> <name>password</name> <value></value> </parameter>
<parameter> <name>url</name> <value>jdbc:postgresql://127.0.0.1
/sp2</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>
</ResourceParams>
</Context>
and this in the application's web.xml:
<resource-ref>
<res-ref-name>jdbc/sp2</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Then I try to get a connection by
private Connection conn;
DataSource ds = null;
try
{
InitialContext initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
ds = (DataSource)envContext.lookup("jdbc/sp2");
}
catch (javax.naming.NamingException ne) { /* ... */ }
try
{ conn = ds.getConnection(); }
catch (java.sql.SQLException se) { /* ... */ }
and in a jsp I try to send some select statements to the database.
The error I'll get in the browser is:
org.apache.jasper.JasperException: Cannot create JDBC driver of class ''
for connect URL 'null', cause: No suitable driver
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
[ ... ]
and the root cause is
javax.servlet.ServletException: Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:536)
[ ... ]
Of ourse I'm getting NullPointers and SQLExceptions as well. The
SQLExceptions are saying the same thing as the Jasper- and
ServletExceptions. The NullPointers occur because none of the database
related variables is being initialised.
The driver jar file is in the CLASSPATH as well as in the application's
WEB-INF/lib directory. Looks fine.
Any help or pointers appreciated ... it seems like I'm the first one ever
to have this error ;-)
Regards
B. Burkhart
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]