padmasambhava
asked on
javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null'
I don't seem to be able to get to my database. Thanks
for taking a look...
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletExcep tion: Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.jasper.runtime. PageContex tImpl.doHa ndlePageEx ception(Pa geContextI mpl.java:8 48)
org.apache.jasper.runtime. PageContex tImpl.hand lePageExce ption(Page ContextImp l.java:781 )
org.apache.jsp.index2_jsp. _jspServic e(org.apac he.jsp.ind ex2_jsp:16 5)
org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:97)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 802)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 22)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:291)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:241)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 802)
root cause
org.apache.tomcat.dbcp.dbc p.SQLNeste dException : Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.tomcat.dbcp.dbc p.BasicDat aSource.cr eateDataSo urce(Basic DataSource .java:780)
org.apache.tomcat.dbcp.dbc p.BasicDat aSource.ge tConnectio n(BasicDat aSource.ja va:540)
org.apache.jsp.index2_jsp. _jspServic e(org.apac he.jsp.ind ex2_jsp:92 )
org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:97)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 802)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 22)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:291)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:241)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
for taking a look...
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletExcep
org.apache.jasper.runtime.
org.apache.jasper.runtime.
org.apache.jsp.index2_jsp.
org.apache.jasper.runtime.
javax.servlet.http.HttpSer
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
root cause
org.apache.tomcat.dbcp.dbc
org.apache.tomcat.dbcp.dbc
org.apache.tomcat.dbcp.dbc
org.apache.jsp.index2_jsp.
org.apache.jasper.runtime.
javax.servlet.http.HttpSer
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
And that the driver class name is specified correctly.
ASKER
Here's the code that's giving me fits...
Context iniCtx = new InitialContext();
Context envCtx = (Context) iniCtx.lookup("java:comp/e nv");
DataSource ds = (DataSource) envCtx.lookup("jdbc/someth ing");
Connection con = ds.getConnection();
Statement st = con.createStatement();
And here's the server.xml code as well...
<Resource name="jdbc/something"
auth="Container"
type="javax.sql.DataSource "
driverClassName="org.postg resql.Driv er"
url="jdbc:postgresql://127 .0.0.1:543 2/somethin g"
username="something" password="password"
maxActive="20" maxIdle="10" maxWait="-1"/>
<!--
<Resource name="jdbc/something" auth="Container"
type="javax.sql.DataSource ">
</Resource>
<ResourceParams name="jdbc/something">
<parameter>
<name>factory</name>
<value>org.apache.commons. dbcp.Basic DataSource Factory</v alue>
</parameter>
<parameter>
<name>removeAbandoned</nam e>
<value>true</value>
</parameter>
<parameter>
<name>driverClassName</nam e>
<value>org.postgresql.Driv er</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:postgresql:som ething</va lue>
</parameter>
<parameter>
<name>username</name>
<value>something</value>
</parameter>
<parameter>
<name>password</name>
<value>password</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 iniCtx = new InitialContext();
Context envCtx = (Context) iniCtx.lookup("java:comp/e
DataSource ds = (DataSource) envCtx.lookup("jdbc/someth
Connection con = ds.getConnection();
Statement st = con.createStatement();
And here's the server.xml code as well...
<Resource name="jdbc/something"
auth="Container"
type="javax.sql.DataSource
driverClassName="org.postg
url="jdbc:postgresql://127
username="something" password="password"
maxActive="20" maxIdle="10" maxWait="-1"/>
<!--
<Resource name="jdbc/something" auth="Container"
type="javax.sql.DataSource
</Resource>
<ResourceParams name="jdbc/something">
<parameter>
<name>factory</name>
<value>org.apache.commons.
</parameter>
<parameter>
<name>removeAbandoned</nam
<value>true</value>
</parameter>
<parameter>
<name>driverClassName</nam
<value>org.postgresql.Driv
</parameter>
<parameter>
<name>url</name>
<value>jdbc:postgresql:som
</parameter>
<parameter>
<name>username</name>
<value>something</value>
</parameter>
<parameter>
<name>password</name>
<value>password</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>
-->
WHere is your driver jar located?
ASKER
Hey objects,
I forgot to mention that I'm a newbie, so how do I tell where my driver jar is located?
Thanks!
I forgot to mention that I'm a newbie, so how do I tell where my driver jar is located?
Thanks!
You need to put the jar file containing the jdbc driver in either <tomcat>/common/lib or <webapp>/WEB-INF/lib
ASKER
Ok, the jar file was already there and I downloaded a newer version just to see if that
helped, but I still get the same error.
helped, but I still get the same error.
whats the error in the log say?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
thanks for grade
and that you have specified the correct connect url string