Re: Setting up DSPACE for Postgres access - Mailing list pgsql-general

From Ashwin Kutty
Subject Re: Setting up DSPACE for Postgres access
Date
Msg-id Pine.A41.4.31.0310231400190.136178-100000@is.dal.ca
Whole thread Raw
In response to Re: Setting up DSPACE for Postgres access  (Dardo D Kleiner <dkleiner@cmf.nrl.navy.mil>)
Responses Re: Setting up DSPACE for Postgres access  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Agreed, however if its working fine on someone else's end then the problem
is local to my environment.  People do have difficulties setting up DSPACE
but I currently have the front-end running fine.  The dependencies are
just crazy along with third party apps for DSPACE.  However, all that is
done, its working and the front-end is up.  I have what most others dont
and dont have what most others do.  The jar part of it really gets me
cause all it needs is the CLASSPATH env var pointing to the appropriate
jar as I have done so many times in the past.

I know Java is on ok cause I have Tomcat running on the server fine as
well which is required for DSPACE as well.  I just dont get why the
program cannot find the jar var.  The create-administrator script runs the
script such that the call tends to be:
java -Xmx256m -classpath $FULLPATH "org.dspace.administer.CreateAdministrator"

Where, $FULLPATH=$CLASSPATH:$JARS:$DSPACEDIR/config
Where $JARS=`echo $DSPACEDIR/lib/*.jar | sed 's/ /\:/g'`

Now, the postgresql.jar gets pointed to twice; once from the script with
the JARS var and the second with the pointing to it from the $CLASSPATH
var set by me.  I even echo the $FULLPATH var right before it hits the
java command and the echo brings up the huge PATH created by the script
that contains the jar files and the directories.  I dont get however how
the script can have it in the $FULLPATH var but not use it when sent to
the command line?

On Thu, 23 Oct 2003, Dardo D Kleiner wrote:

> Whenever I need to use the postgresql JDBC driver in my programs, I
> have to manually include the line:
>
> Class.forName("org.postgresql.Driver");
>
> somewhere *before* I call DriverManager.getConnection.
>
> Try this in your test program and see if it works.  Unfortunately,
> you may not be able to modify the installer to support this, but
> there might be another way?
>
> HTH!
>
> --
> Dardo D. Kleiner
> Connection Machine Facility, Center for Computational Sciences
> Naval Research Laboratory (Washington, DC)
> dkleiner@cmf.nrl.navy.mil -- 202.404.7019
>
>
>

---
"The difference between genius and stupidity is that genius has its
limits."  - Albert Einstein

Ashwin
kutty..
Systems Administrator
Dalhousie University Libraries
(902) 494-2694


pgsql-general by date:

Previous
From: Ashwin Kutty
Date:
Subject: Re: Setting up DSPACE for Postgres access
Next
From: Adam Kavan
Date:
Subject: CLUSTER