Arch Linux

poliocertes

Member

From: Poland

Registered: 2010-02-19

Posts: 29

java postgres jdbc

I'm trying to be a programmer. Just installed java, postgres, and postgres-jdbc, but when I'm trying to compilea sample code i got:

Exception in thread "main" java.lang.ClassNotFoundException: org.postgresql.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:190)
	at Test.main(Test.java:8)
 

After a short google searching a found a info about a CLASSPATH but still don'n know hot to set this up. Can anybody help me with this?

Just added into my ~/.bashrc following

CLASSPATH=/usr/share/java/postgresql-jdbc/postgresql-9.2-1002.jdbc4.jar
export CLASSPATH

but error is the same as it was before.

Last edited by poliocertes (2013-10-28 19:43:36)

kpiche

Forum Fellow

From: Ottawa, ON, Canada

Registered: 2004-03-30

Posts: 246

Website

Re: java postgres jdbc

Is your .bashrc being picked up?  You can also specify the path on the command line to test:  java -cp .:/usr/share/java/postgresql-jdbc/postgresql-9.2-1002.jdbc4.jar samplecode

poliocertes

Member

From: Poland

Registered: 2010-02-19

Posts: 29

Re: java postgres jdbc

Solution was really simple. Just download a jdbc up to date version of driver and put it into the /opt/java/jre/lib/ext/

Last edited by poliocertes (2013-11-02 12:44:00)