Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed - Mailing list pgsql-jdbc

From Maciek Sakrejda
Subject Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed
Date
Msg-id 895e58dd1003090922k54e67f44k94f1903a72b5879f@mail.gmail.com
Whole thread Raw
In response to Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed  (dmp <danap@ttc-cmc.net>)
List pgsql-jdbc
I don't imagine Class.forName() would throw a PSQLException.

If I'm reading the ConnectionFactoryImpl code correctly, the server
seems to be responding to the Startup message with something that is
neither an error nor an authentication request, which seems weird. Can
you use Wireshark or tcpdump to look at traffic on the wire?
---
Maciek Sakrejda | Software Engineer | Truviso

1065 E. Hillsdale Blvd., Suite 230
Foster City, CA 94404
(650) 242-3500 Main
(650) 242-3516 T
(510) 717-5398 M
(650) 242-3501 F
msakrejda@truviso.com
www.truviso.com



On Tue, Mar 9, 2010 at 8:56 AM, dmp <danap@ttc-cmc.net> wrote:
> Did not look up error, but looks like the Class.forName().
> Attached standard main() to create a connection to PostgreSQL.
>
> danap.
>
>
>   //============================================================
>   // Main public access point method for instantiating the
>   // PostgreSQL_JDBC application. Arguments: database, username,
>   // & password.
>   // ==============================================================
>
>   public static void main(String[] args) throws SQLException,
> InstantiationException,
>         IllegalAccessException, ClassNotFoundException, InterruptedException
>   {
>      String host, database, username, password;
>      Connection dbConnection;
>
>      // Collect connection properties. and setup connection.
>
>      //host = "cindy";
>      host = "localhost";
>
>      if (args.length != 0)
>      {
>         database = args[0];
>         username = (args.length > 1) ? args[1] : null;
>         password = (args.length > 2) ? args[2] : null;
>      }
>      else
>      {
>         database = "key_tables";
>         username = "";
>         password = "";
>      }
>
>      dbConnection = null;
>      Class.forName("org.postgresql.Driver").newInstance();
>      dbConnection = DriverManager.getConnection("jdbc:postgresql://" + host
> + "/" + database, username,
>         password);
>      System.out.println("Connection Created");
>
>      new PostgreSQL_JDBC(dbConnection);
>
>      // Close.
>      dbConnection.close();
>      System.out.println("Connection Closed");
>   }
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>

pgsql-jdbc by date:

Previous
From: dmp
Date:
Subject: Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed
Next
From: Major Services
Date:
Subject: Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed