Postgres datasource problems with J2EE

Hello All

I'm having problems trying to connect to a postgres database through a datasource. I'm a little new to this all so i'll try to be as detailed as possible.

This is a simple two step client app, 1 client publishes to a topic, another client app consumers off of it. The publisher runs fine, but the consumer (whichis suppose to consume messages off the topic and submit it to a database), keeps throwing this exception:

SEVERE: RAR5099 : Wrong class name or classpath for Datasource Object : {0}

java.lang.ClassNotFoundException: org.postgresql.jdbc3.Jdbc3PoolingDataSource

at java.net.URLClassLoader$1.run(URLClassLoader.java:200)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:188)

at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)

at java.lang.ClassLoader.loadClass(ClassLoader.java:251)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:164)

at etc

\

In the admin console, I've set up the postgres db as a connection pool using org.postgresql.jdbc3.Jdbc3PoolingDataSource as the datasource class and javax.sql.ConnectionPoolDataSource as it's resource type. It pings fine.

I've also (as was recommended in the forums) added my postgresql-8.1-404.jdbc3.jar to my classpath suffix of my JVM and added -Djdbc.drivers=org.postgresql.Driver to my JVM options.

Any ideas on what this exception might be from?

[1677 byte] By [sitkilla] at [2007-10-2 11:34:37]