Ver. 12.1 successfully installed on Win 10 but having trouble with jdbc jar

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.

Responses

Browse pgsql-admin by date

  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