Well some where in the java code for dspace there will be a call to Class.forName(then the postgresql db driver class name).newInstance() . That call should have failed if it were taking place and the class was not found (unless it is wrapped in something like this try{ call class for name } catch(Exception e) { then nothing here just swallow the error }. I know nothing about dspace, but I program java apps all the time. Have you written to a mailing list for dspace before? I don't believe dspace is included in the RH packages. Anyways, you need to make sure that the postgresql.jar file is definitely where it should be. You should also make sure that you have a build of dspace which is not broken. The best place in my estimation would be the projects home and mailing lists. Wade -----Original Message----- From: redhat-list-admin@xxxxxxxxxx [mailto:redhat-list-admin@xxxxxxxxxx] On Behalf Of Ashwin Kutty Sent: Monday, October 27, 2003 8:52 AM To: redhat-list@xxxxxxxxxx Subject: Setting up DSPACE for Postgres access I am currently testing a product by the name of dspace (http://www.dspace.org) and require installing java since dspace is completely java based. The problem is that during its installation it needs to talk to pgsql via jdbc and I am getting the error: Exception occurred:org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Driver not found for URL: jdbc:postgresql://dspace.library.dal.ca:5432/dspace org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Driver not found for URL: jdbc:postgresql://dspace.library.dal.ca:5432/dspace at 0x40268e17: java.lang.Throwable.Throwable(java.lang.String) (/usr/lib/./libgcj.so.3) at 0x4025bcd2: java.lang.Exception.Exception(java.lang.String) (/usr/lib/./libgcj.so.3) at 0x4025f592: java.lang.RuntimeException.RuntimeException(java.lang.String) (/usr/lib/./libgcj.so.3) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e504: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e504: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e58a: _Jv_InterpMethod.run_synch_object(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e58a: _Jv_InterpMethod.run_synch_object(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e504: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x402fcc68: java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/./libgcj.so.3) at 0x402fcb8b: java.sql.DriverManager.getConnection(java.lang.String) (/usr/lib/./libgcj.so.3) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e504: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e504: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e504: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x40242dd8: gnu.gcj.runtime.FirstThread.call_main() (/usr/lib/./libgcj.so.3) at 0x402ad02d: gnu.gcj.runtime.FirstThread.run() (/usr/lib/./libgcj.so.3) at 0x4024fc4c: _Jv_ThreadRun(java.lang.Thread) (/usr/lib/./libgcj.so.3) at 0x4021c8ac: _Jv_RunMain(java.lang.Class, byte const, int, byte const, boolean) (/usr/lib/./libgcj.so.3) at 0x08048910: ?? (??:0) at 0x420156a4: __libc_start_main (/lib/tls/libc.so.6) at 0x080486c1: ?? (??:0) I have tried the basic psql.class example provided by Postgres and get the no class found error again. I cannot ofcourse go beyond this since they have to talk to each other and if that doesnt happen nothing else is going to work. In terms of the system and the env var's; here goes: RH Linux 9 (kernel 2.4.20) j2sdk1.4.2_01 dspace - 1.1.1 postgres - 7.3.4 environment var's: CLASSPATH=/home/dspace/j2sdk1.4.2_01:/dspace/lib/postgresql.jar:/dspace/ lib:/usr/local/pgsql/share/java:/dspace/config:/dspace/lib:/dspace/lib/a ctivation.jar:/dspace/lib/commons-cli.jar:/dspace/lib/commons-collection s.jar:/dspace/lib/commons-dbcp.jar:/dspace/lib/commons-pool.jar:/dspace/ lib/cos.jar:/dspace/lib/dspace.jar:/dspace/lib/handle.jar:/dspace/lib/je na.jar:/dspace/lib/log4j.jar:/dspace/lib/lucene.jar:/dspace/lib/mail.jar :/dspace/lib/oaicat.jar:/dspace/lib/oro.jar:/dspace/lib/servlet.jar:/dsp ace/lib/xalan.jar:/dspace/lib/xerces.jar:/home/dspace/j2sdk1.4.2_01/lib: /home/dspace/j2sdk1.4.2_01:/home/dspace/j2sdk1.4.2_01/jre/lib:/home/dspa ce/j2sdk1.4.2_01/jre/javaws:/home/dspace/dspace-1.1.1-source/build/class es:/usr/local/pgsql/share/java:/usr/local/pgsql/share/java/postgresql.ja r PGDATA=/usr/local/pgsql/data PGSQL_HOME=/usr/local/pgsql/bin JAVA_HOME=/home/dspace/j2sdk1.4.2_01 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/pgsq l/bin:/home/dspace/j2sdk1.4.2_01:/home/dspace/j2sdk1.4.2_01/bin:/home/ds pace/bin JAVA_OPTS=-Xmx512M -Xms64M -Dfile.encoding=UTF-8 I have never had any problems setting jdbc up before; but this time around I cant see why this is happening. Is there something specific to RH9 or am I missing something? I have tried to ask the PGSQL-General, PGSQL-JDBC & DSPACE-Tech lists and they have no idea; am hoping something comes up here that could solve this. Any help would be greatly appreciated. Thanks. -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list