JDBC - Requirements for setup
От | Ashwin Kutty |
---|---|
Тема | JDBC - Requirements for setup |
Дата | |
Msg-id | Pine.A41.4.31.0310311039460.41656-100000@is.dal.ca обсуждение исходный текст |
Список | 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.
В списке pgsql-jdbc по дате отправления: