From: | CR20 <mez283em23e2ze2(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Ver. 12.1 successfully installed on Win 10 but having trouble with jdbc jar |
Date: | 2020-01-20 00:24:40 |
Message-ID: | 7d2f92c9-a779-832b-849e-a38f929375d6@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I have postgresql-12.1-3-windows-x64 installed and apparently working,
but I'm then I'm trying a simple Java connection example as follows:
import java.sql.*;
public class CreateTable {
public static void main(String args[]) {
Connection c = null;
Statement stmt = null;
String CreateSql = null;
try {
Class.forName("org.postgresql.Driver");
c =
DriverManager.getConnection("jdbc:postgresql://localhost:5432/procedure_demo",
"postgres", "adminedb");
System.out.println("Database Connected ..");
stmt = c.createStatement();
CreateSql = "Create Table Test(id int primary key, name
varchar, address text) ";
stmt.executeUpdate(CreateSql);
stmt.close();
c.close();
}
catch (Exception e) {
System.err.println( e.getClass().getName()+": "+
e.getMessage() );
System.exit(0);
}
System.out.println("Table Created successfully");
}
}
...which compiled successfully but when I go to run it, with
postgresql-42.2.9.jar stored in path C:\PostgreSQL\libs, like as follows:
java -cp C:\PostgreSQL\libs . CreateTable
...the command line returns:
Error: Could not find or load main class .
Some of this is my limited knowledge of Java. My question then is,
Where should the jdbc jar be located in order to run, and then how do I
run all this at the command line? Thank you for any help.
From | Date | Subject | |
---|---|---|---|
Next Message | Shrikant Bhende | 2020-01-20 05:00:23 | pg_upgrade from 9.5.10 to 12 fails with encoding issue |
Previous Message | Jeff Janes | 2020-01-17 22:20:50 | Re: delete then insert |