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.