To: pgsql-admin@lists.postgresql.org
From: CR20 <mez283em23e2ze2@yahoo.com>
Subject: Ver. 12.1 successfully installed on Win 10 but having trouble with
 jdbc jar
Message-ID: <7d2f92c9-a779-832b-849e-a38f929375d6@yahoo.com>
Date: Sun, 19 Jan 2020 19:24:40 -0500
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101
 Thunderbird/68.4.1
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------33C3D2B39908E4E604CBBAFC"
Content-Language: en-US
References: <7d2f92c9-a779-832b-849e-a38f929375d6.ref@yahoo.com>
Content-Length: 4732
Precedence: bulk

This is a multi-part message in MIME format.
--------------33C3D2B39908E4E604CBBAFC
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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.


--------------33C3D2B39908E4E604CBBAFC
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><tt><font size="-1">Hi, <br>
        </font></tt></p>
    <p><tt><font size="-1">I have postgresql-12.1-3-windows-x64
          installed </font></tt><tt><font size="-1">and apparently
          working, but I'm then I'm trying a simple Java connection
          example as follows:</font></tt></p>
    <p><tt><font size="-1">import java.sql.*;<br>
          <br>
          public class CreateTable {<br>
              public static void main(String args[]) {<br>
                  Connection c = null;<br>
                  Statement stmt = null;<br>
                  String CreateSql = null;<br>
          <br>
                  try {<br>
                      Class.forName("org.postgresql.Driver");<br>
                      c =
DriverManager.getConnection("jdbc:postgresql://localhost:5432/procedure_demo",
          "postgres", "adminedb");<br>
                      System.out.println("Database Connected ..");<br>
                      stmt = c.createStatement();    <br>
                      CreateSql = "Create Table Test(id int primary key,
          name varchar, address text) ";<br>
                      stmt.executeUpdate(CreateSql);<br>
                      stmt.close();<br>
                      c.close();<br>
                  }<br>
          <br>
                  catch (Exception e) {<br>
                      System.err.println( e.getClass().getName()+": "+
          e.getMessage() );<br>
                      System.exit(0);<br>
                  }<br>
          <br>
                  System.out.println("Table Created successfully");<br>
              }<br>
          }<br>
        </font></tt></p>
    <p><tt><font size="-1">...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:<br>
        </font></tt></p>
    <p><tt><font size="-1">java -cp C:\PostgreSQL\libs . CreateTable</font></tt></p>
    <p><tt><font size="-1">...the command line returns:</font></tt></p>
    <p><tt><font size="-1">Error: Could not find or load main class .<br>
        </font></tt></p>
    <p><font size="-1"><tt>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.</tt></font><font
        size="-1"><br>
      </font></p>
  </body>
</html>

--------------33C3D2B39908E4E604CBBAFC--