Trouble with installing JDBC for Postgres

Question

I would like to use JDBC. My code:

import java.sql.*;
import java.util.ArrayList;
import java.util.Properties;

public class test {

Connection conn;

public test() throws ClassNotFoundException, SQLException{
    Class.forName("org.postgresql.Driver");
    String url = "jdbc:postgresql://localhost/tb";
    Properties props = new Properties();
    props.setProperty("user","user");
    props.setProperty("password","passwd");
    conn = DriverManager.getConnection(url, props);
    System.out.println(conn.isClosed());
}

public static void main(String[] args) {
    try{
        test t = new test();
    } catch (Exception e){
        e.printStackTrace();        
    }
}
}

My soft: postgres 9.1, java 1.7

My try:

ziel@gad ~/java/test $ ls
postgresql-9.1-902.jdbc4.jar  test.java
ziel@gad ~/java/test $ javac test.java 
ziel@gad ~/java/test $ java -cp postgresql-9.1-902.jdbc4.jar test
Error: Could not find or load main class test

According to people from google this should load the driver. What am I doing wrong?

Michael Simons · Accepted Answer · 2012-07-24 09:28:53Z

3

Use java -cp postgresql-9.1-902.jdbc4.jar:. test under Linux / Unix / OS X

answered Jul 24, 2012 at 9:28

Michael Simons

4,9301 gold badge31 silver badges39 bronze badges

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

Comments

M Abbas · Accepted Answer · 2012-07-24 09:21:16Z

3

Thats because when you did -cp postgresql-9.1-902.jdbc4.jar, you defined the jar postgresql-9.1-902.jdbc4.jar as the only location of your class files and the class test isn't in this jar. To resolve the problem you have to execute this cmd java -cp postgresql-9.1-902.jdbc4.jar;. test

answered Jul 24, 2012 at 9:21

M Abbas

6,4994 gold badges37 silver badges48 bronze badges

2 Comments

zie1ony Over a year ago

If I do java -cp 'postgresql-9.1-902.jdbc4.jar;.' test I get the same: Error: Could not find or load main class test.

M Abbas Over a year ago

do you have the file test.class in ~/java/test? why did you use simple quotes ' in your cmd?

Srinivas · Accepted Answer · 2012-07-24 09:36:03Z

1

i guess you are using linux os, so try this java -cp postgresql-9.1-902.jdbc4.jar:. test. In windows java -cp postgresql-9.1-902.jdbc4.jar;. test

answered Jul 24, 2012 at 9:36

Srinivas

3902 silver badges11 bronze badges

Comments

zie1ony · Accepted Answer · 2014-02-03 03:22:33Z

0

Execute following on Linux machine

javac -cp '.:postgresql-9.1-901.jdbc4.jar' postgresjavatest.java

java -cp '.:postgresql-9.1-901.jdbc4.jar' postgresjavatest

make sure jar file is on same location where command is fired.

edited Feb 3, 2014 at 3:22

zie1ony

1,2702 gold badges15 silver badges33 bronze badges

answered Jan 29, 2014 at 10:02

Rohit_chd

1111 gold badge1 silver badge7 bronze badges

1 Comment

benka Over a year ago

the OP has postgresql-9.1-902.jdbc4.jar. Why are you posting this answer everywhere?

Collectives™ on Stack Overflow

Trouble with installing JDBC for Postgres

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related