Postgres Pro
Downloads
Home   >   mailing lists

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

From Major Services
Subject Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed
Date
Msg-id 375c2da1003101034o4995f5c5u9beebe90e6e0f43a@mail.gmail.com
Whole thread Raw
In response to Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed  (Major Services <services.major@gmail.com>)
Responses Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed  (Maciek Sakrejda <msakrejda@truviso.com>)
List pgsql-jdbc
Tree view
Please ignore the previous output.

Here is the one to consider:

org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/pgtest.jsp at line 14

11:  String url = "jdbc:postgresql://localhost:5432/postgres?user=postgres&password=major";

12:  Properties props = new Properties();
13:  props.setProperty("loglevel","2");
14:  Connection conn = DriverManager.getConnection(url , props);
15: }
16: %>
17: </body>



Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

javax.servlet.ServletException: org.postgresql.util.PSQLException: Protocol error.  Session setup failed.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	org.apache.jsp.jsp.pgtest_jsp._jspService(pgtest_jsp.java:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

org.postgresql.util.PSQLException: Protocol error.  Session setup failed.
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:402)
	org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
	org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
org.postgresql.Driver.makeConnection(Driver.java:393)
	org.postgresql.Driver.connect(Driver.java:267)
	java.sql.DriverManager.getConnection(DriverManager.java:525)
	java.sql.DriverManager.getConnection(DriverManager.java:140)
org.apache.jsp.jsp.pgtest_jsp._jspService(pgtest_jsp.java:68)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 

On Wed, Mar 10, 2010 at 8:01 PM, Major Services <services.major@gmail.com> wrote:
Hi,
Following is the error report:

org.apache.jasper.JasperException: Unable to compile class for JSP: 

An error occurred at line: 13 in the jsp file: /jsp/pgtest.jsp
Properties cannot be resolved to a type


10: {
11: Class.forName("org.postgresql.Driver");
12:  String url = "jdbc:postgresql://localhost:5432/postgres?user=postgres&password=major";
13:  Properties props = new Properties();

14:  props.setProperty("loglevel","2");

15:  Connection conn = DriverManager.getConnection(url, props);
16: }
Thanks


On Wed, Mar 10, 2010 at 4:02 AM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:
Major Services wrote:
I am trying to connect to PostgreSQL database on my local system.

The code is:

Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/postgres?user=postgres&password=major";
Connection conn = DriverManager.getConnection(url);

Running the code I get:

org.postgresql.util.PSQLException: Protocol error. Session setup failed.

Using postgresql-8.4-701.jdbc3 on PostgreSql 8.4






Try adding some debug info (will help us see what is going on) - e.g:



 Class.forName("org.postgresql.Driver");
 String url = "jdbc:postgresql://localhost:5432/postgres?user=postgres&password=major";

 Properties props = new Properties();
 props.setProperty("loglevel","2");

 Connection conn = DriverManager.getConnection(url, props);



regards

Mark


pgsql-jdbc by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Retrieving multidimentional array-column using JDBC
Next
From: "Kevin Grittner"
Date:
Subject: Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed