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.
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 |
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 |