What docs are you reading that say this? This used to be the case in
6.5 of postgres, but the main class has been org.postgresql.Driver since
7.0.
thanks,
--Barry
Nikola Milutinovic wrote:
> Hi all.
>
> I'm crossposting this to two mailing lists, I think poth parties are concerned.
>
> Finaly got some time to work on my project on Tomcat and I ran into problems.
> Mostly these problems stem from the inconsistent documentation that accompanies
> Tomcat 4.0 distribution. And it would appear that PostgreSQL is also in error
> (see below).
>
> I have:
>
> - Tru64 UNIX 4.0D (a.k.a. Digital UNIX)
> - Java 1.3.0 SDK
> - Tomcat 4.0 final release
> - PostgreSQL 7.1.0
> - PostgreSQL JDBC 2.0 compliant driver
>
> QUESTION 1: How do I go about setting it up with Tomcat?
>
> I have tried the following:
>
> - placed postgresql.jar in ${CATALINA_HOME}/common/lib/
> - added CATALINA_OPTS="-Djdbc.drivers=postgresql.Driver"
> - restarted Tomcat
>
> My JSP file is:
>
> <%-- My first go at PostgreSQL and JSP --%>
> <%@ page info="test" import="java.sql.*, javax.sql.*" %>
> <%!
> Connection conn = DriverManager.getConnection(
> "jdbc:postgresql://localhost/mercury", "test", "test00" );
> String query = "SELECT * FROM div";
> %>
>
> [SNIP]
>
> </html>
>
> When I run it, I get the following error:
>
> -------------------------------------------------------------------
> org.apache.jasper.JasperException: Unable to compile class for JSP
> ...
>
> Root Cause:
>
> java.lang.NumberFormatException: postgresql
> ...
> -------------------------------------------------------------------
>
> This would imply that I'm either using a wrong connection string or the driver
> isn't loaded, right?
>
> QUESTION 2: Now this may sound dumb, but... PostgreSQL docs state that I should
> load driver with "-Djdbc.drivers=posgresql.Driver", but if I list postgresql.jar
> file, I see it is "org.postgresql.Driver". Is this a typo in the docs?
>
> Nix.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
