how to use postgresql in Java

Question

I Installed postgresql and its driver which is "postgresql-9.3-1102.jdbc41.jar".

And my directory seems like :

> SQL
>     myJDBC.java
>     postgresql-9.3-1102.jdbc41.jar

I have tried :

javac -cp postgresql-9.3-1102.jdbc41.jar myJDBC.java
java -cp postgresql-9.3-1102.jdbc41.jar myJDBC

It compiles fine but when I try to execute it, I get error which is :

Error: Could not find or load main class myJDBC

What am I missing ?

Reimeus · Accepted Answer · 2014-11-07 16:45:39Z

2

The current directory needs to be added to the runtime classpath

java -cp .:postgresql-9.3-1102.jdbc41.jar myJDBC
         ^

edited Nov 7, 2014 at 16:45

answered Nov 7, 2014 at 16:34

Reimeus

160k16 gold badges225 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Vivian Maya Over a year ago

When I do that I get : java.lang.ClassNotFoundException: org.postgreql.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:191)

mwarren Over a year ago

There ought to be a letter 's' in org.postgreql.Driver, check your code

VH-NZZ Over a year ago

Sorry, my edit and comment had become obsolete in light of your ClassNotFoundException.

Vivian Maya Over a year ago

@okiharaherbst I'm truly sorry I'm kind of newbie I didn't get it what do you mean, The Jar file and myJDBC in same directory already ? how can use fully qualified package name ?

Vivian Maya Over a year ago

@okiharaherbst oh my god, I get it now what a mistake,I'm grateful,thank you for your attention...

|

Collectives™ on Stack Overflow

how to use postgresql in Java

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related