Setting up DSPACE for Postgres access

[Ashwin Kutty]

Hi all,

I sent this message to the jdbc list and received no response there and so
am posting to this list hoping I could get some help here.

Thanks in advance.

---------- Forwarded message ----------
Date: Fri, 17 Oct 2003 11:54:19 -0300 (ADT)
From: Ashwin Kutty <ak****@dal.ca>
Reply-To: Ashwin Kutty <As**********@Dal.Ca>
To: pg********@postgresql.org
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

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/activation.jar:/dspace/lib/commons-cli.jar:/dspace/lib/commons-collections.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/jena.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:/dspace/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/dspace/j2sdk1.4.2_01/jre/javaws:/home/dspace/dspace-1.1.1-source/build/classes:/usr/local/pgsql/share/java:/usr/local/pgsql/share/java/postgresql.jar
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/pgsql/bin:/home/dspace/j2sdk1.4.2_01:/home/dspace/j2sdk1.4.2_01/bin:/home/dspace/bin
JAVA_OPTS=-Xmx512M -Xms64M -Dfile.encoding=UTF-8
JSSE_HOME=/home/dspace/j2sdk1.4.2_01/jre/lib

Any help would be greatly appreciated.

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Richard Huxton]

On Thursday 23 October 2003 14:20, Ashwin Kutty wrote:

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

It's complaining that it cannot find a driver. The obvious steps are:
1. Check you have your JDBC driver installed and configured.
2. Check you can connect using it.
3. Check it is in the relevant PATH
How far along this process have you got?

If you've done all those, we'll have to figure out why it can't find the
driver.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Ashwin Kutty]

> It's complaining that it cannot find a driver. The obvious steps are:

1. Check you have your JDBC driver installed and configured.
Yes. I have done so. Included in the Classpath env var as well. I have
gone so far as to downloading it from jdbc.postgresql.org rather than
using the compiled one I have. Still no luck.
2. Check you can connect using it.
Via a test program? Done, no luck.. Same ol same ol..
3. Check it is in the relevant PATH
Besides the Classpath, does it need to be in the Path as well? If so, no
I havent added it in, but will do so if its required.
How far along this process have you got?
I am actually to the point of pulling teeth, cause I have added every jar
file I can think of and find in the classpath, re-installed everything and
still the case remains the same. I am guessing its just not finding it
due to some foolish little quirk I am missing some place. I even have tcp_ip
turned on btw in postgres to accept connections both from the box itself
and another machine through which I am using pgadmin and connecting fine.
If you've done all those, we'll have to figure out why it can't find the
driver.

I thought and still under the impression that its looking in the classpath
for this and I have edited /etc/profile to include it, checked env before
running the program and it according to it the jar file is included fine
and the classpath does have it; but still nothing. Checked file
permissions on the jar file and its fine as well. I have made changes to
the user's bash_profile as well to see if its a user related issue and
still nothing. Su'ed in as root and tried it out and yet nothing. Its
like for some reason the file just cant be found.

Any ideas and assistance would be greatly appreciated.

Thanks.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Richard Huxton]

On Thursday 23 October 2003 15:52, Ashwin Kutty wrote:

I thought and still under the impression that its looking in the classpath
for this and I have edited /etc/profile to include it, checked env before
running the program and it according to it the jar file is included fine
and the classpath does have it; but still nothing. Checked file
permissions on the jar file and its fine as well. I have made changes to
the user's bash_profile as well to see if its a user related issue and
still nothing. Su'ed in as root and tried it out and yet nothing. Its
like for some reason the file just cant be found.

Looking at the dspace docs (system prerequisites):
"Then when PostgreSQL has compiled, copy the new postgresql.jar to
dspace-1.1/lib."

Strikes me as a bit strange it won't just use the classpath, but have you got
the jar in there too?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Ashwin Kutty]

> Looking at the dspace docs (system prerequisites):

"Then when PostgreSQL has compiled, copy the new postgresql.jar to
dspace-1.1/lib."

Strikes me as a bit strange it won't just use the classpath, but have you got
the jar in there too?

Yes and in j2sdk's lib directory and in pgsql's share directory and it is
all being called in the classpath.. no luck, still..
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster