Re: Setting up DSPACE for Postgres access

> Given everything else you've tried, I think you might be on the right track
> here and somehow your environment variables are getting clobbered. How or why
> I couldn't say (I'd suspect Tomcat, but you say you can't even run the
> create-administator app).

Tomcat only uses the minor few and runs like a charm.  It doesnt seem to
be only the create-administrator app.  As I mentioned earlier, this occurs
with any app trying to connect to pgsql via jdbc.  I used the psql.java
file to compile and test that comes bundled in the postgres source.  The
error I received was as follows:

Exception in thread "main" java.lang.NoClassDefFoundError: loaded class
psql was in fact named example.psql
   at 0x40268e17: java.lang.Throwable.Throwable(java.lang.String)
(/usr/lib/./libgcj.so.3)
   at 0x4025bc8e: java.lang.Error.Error(java.lang.String)
(/usr/lib/./libgcj.so.3)
   at 0x4025d6b6: java.lang.LinkageError.LinkageError(java.lang.String)
(/usr/lib/./libgcj.so.3)
   at 0x4025eb36:
java.lang.NoClassDefFoundError.NoClassDefFoundError(java.lang.String)
(/usr/lib/./libgcj.so.3)
   at 0x4022d555: ?? (??:0)
   at 0x4022c96e: _Jv_ClassReader.handleClassBegin(int, int, int)
(/usr/lib/./libgcj.so.3)
   at 0x4022ab61: _Jv_ClassReader.parse() (/usr/lib/./libgcj.so.3)
   at 0x4022a97f: _Jv_DefineClass(java.lang.Class, byte[], int, int)
(/usr/lib/./libgcj.so.3)
   at 0x40247e6f: java.lang.ClassLoader.defineClass0(java.lang.String,
byte[], int, int, java.security.ProtectionDomain) (/usr/lib/./libgcj.so.3)
   at 0x4025aaa3: java.lang.ClassLoader.defineClass(java.lang.String,
byte[], int, int, java.security.ProtectionDomain) (/usr/lib/./libgcj.so.3)
   at 0x4025aa13: java.lang.ClassLoader.defineClass(java.lang.String,
byte[], int, int) (/usr/lib/./libgcj.so.3)
   at 0x402f1f2e: java.net.URLClassLoader.findClass(java.lang.String)
(/usr/lib/./libgcj.so.3)
   at 0x40248197:
gnu.gcj.runtime.VMClassLoader.findClass(java.lang.String)
(/usr/lib/./libgcj.so.3)
   at 0x4025a904: java.lang.ClassLoader.loadClass(java.lang.String,
boolean) (/usr/lib/./libgcj.so.3)
   at 0x402488d9: _Jv_FindClass(_Jv_Utf8Const, java.lang.ClassLoader)
(/usr/lib/./libgcj.so.3)
   at 0x40244cdd: java.lang.Class.forName(java.lang.String, boolean,
java.lang.ClassLoader) (/usr/lib/./libgcj.so.3)
   at 0x40244d9f: java.lang.Class.forName(java.lang.String)
(/usr/lib/./libgcj.so.3)
   at 0x402ad01d: 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)


> The only other thing I can think of is that for some reason it's looking for
> the wrong class. If dspace comes with the source, it might be worth checking
> whether there isn't a mistake in the Class.forname() call.

Put it this way, the build works for the rest and after some testing found
that outside of create-admin I cant connect to it.

> I must admit, I don't know much java - can you use "strace" to track system
> calls, or is there a similar utility that would let you see what files it is
> searching for?

strace revealed nothing really that could explain this behaviour.

Thanks a lot for all the assistance btw, I really appreciate it.

Hope you have some more ideas to help out.