 | 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
|
|
|
| | | Jndi and Postgresql datasource. | Jndi and Postgresql datasource. 2004-01-13 - By Federico Fernandez Cruz
Back
Hi all!
I am trying to connect to a Postgresql database using DBCP but I allways
get this exception.
javax.servlet.ServletException  : Cannot create JDBC driver of class '' for
connect URL 'null', cause: No suitable driver
org.apache.jasper.runtime.PageContextImpl
(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl (PageContextImpl
.java:800)
org.apache.jsp.dbtest.index_jsp._jspService(index_jsp.java:76)
org.apache.jasper.runtime.HttpJspBase (HttpJspBase.java:133)
javax.servlet.http.HttpServlet (HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper (JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet (JspServlet.java:301)
org.apache.jasper.servlet.JspServlet (JspServlet.java:248)
javax.servlet.http.HttpServlet (HttpServlet.java:856)
in server.xml a have configured the Datasource to my database using the
administration tool.
<GlobalNamingResources>
<Resource name="jdbc/mydb" type="javax.sql.DataSource "/>
<ResourceParams name="jdbc/mydb">
<parameter>
<name>url</name>
<value>jdbc:postgresql://myserver.ip.es/mydb?charSet=iso-8859 (See http://iso-8859.ora-code.com)-1</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.postgresql.Driver </value>
</parameter>
<parameter>
<name>username</name>
<value>add</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
And in my web.xml I have the following....
<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/mydb</res-ref-name>
<res-type>javax.sql.DataSource </res-type>
<res-auth>Container</res-auth>
</resource-ref>
What's the problem? I think I am doing everything ok, but...
I am using Tomcat 5.0.16 on windows... If I do a resource link using the
administration tool (instead of web.xml fragment) , then all goes fine...
Any help?
Thanks in advance
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
|
