 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | Problems connecting to db | Problems connecting to db 2004-01-23 - By fachhochschule.burkhart@(protected)
Back
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 (See http://cat-4.ora-code.com).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 (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 (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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
|
