tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Federico Fernandez Cruz <feder...@dilmun.ls.fi.upm.es>
Subject Jndi and Postgresql datasource.
Date Tue, 13 Jan 2004 13:02:16 GMT
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.doHandlePageException(PageContextImpl.java:867)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
	org.apache.jsp.dbtest.index_jsp._jspService(index_jsp.java:76)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
	javax.servlet.http.HttpServlet.service(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-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@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message