JDBC - Requirements for setup

From: Ashwin Kutty <akutty(at)dal(dot)ca>
To: Undisclosed recipients: ;, "Undisclosed(dot)recipients:"(at)is(dot)dal(dot)ca
Subject: JDBC - Requirements for setup
Date: 2003-10-31 15:22:40
Message-ID: Pine.A41.4.31.0310311039460.41656-100000@is.dal.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc


My last email on this to the list:

What is required besides the following for accessing PGSQL via JDBC?

PGSQL JDBC driver compiled from source.
CLASSPATH=/home/dspace/j2sdk1.4.1/jre:.:/home/dspace/jakarta-tomcat-4.1.27/common/lib:/dspace/lib/postgresql.jar:/usr/local/pgsql/share/java/postgresql.jar
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/dspace/apache-ant-1.5.4/bin:/usr/local/pgsql/share/java:/usr/local/pgsql/bin:/home/dspace/j2sdk1.4.1:/home/dspace/j2sdk1.4.1/bin:/home/dspace/bin
JAVA_HOME=/home/dspace/j2sdk1.4.1
ANT_HOME=/home/dspace/apache-ant-1.5.4
JAVA_OPTS=-Xmx512M -Xms64M -Dfile.encoding=UTF-8
JSSE_HOME=/home/dspace/j2sdk1.4.2_01/jre/lib
CATALINA_HOME=/home/dspace/jakarta-tomcat-4.1.27

Its on a RH9 linux platform running PGSQL 7.3.4 ..

The accessing url is as:
jdbc:postgresql://localhost:5432/db

Thats failing saying:
Exception occurred:org.apache.commons.dbcp.DbcpException:
java.sql.SQLException: Driver not found for URL:
jdbc:postgresql://localhost:5432/dspace

The tcp_ip option is on in PGSQL, its running, so is tomcat.

I have tried this on RH8 and the same thing happens, so I guess Im missing
something in the config of the JDBC driver. I have tried including the
dir that has the jdbc driver in ld.so.conf and have re-ran ldconfig; with
no success.

The driver has been tried in the lib directory, in the share/java dir of
pgsql, in the ext dir of j2sdk and still nothing. Pointing to all of them
accessing it still fails. I have tried the psql.class example that comes
bundled with the pgsql source and that fails as well.

I have even tried using the driver from the jdbc site directly but no luck
there as well (pg73b1jdbc3.jar).

Any other ideas?

Thanks.

Browse pgsql-general by date

  From Date Subject
Next Message Michael Meskes 2003-10-31 15:33:25 Re: Problem with ecpg
Previous Message Tom Lane 2003-10-31 14:41:14 Re: problem with huge joins

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alessandro Polverini 2003-10-31 17:24:07 Generated Keys
Previous Message Thomas Kellerer 2003-10-30 22:38:38 Re: I want to download mysql driver