Skip site navigation (1) Skip section navigation (2)

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

From: Major Services <services(dot)major(at)gmail(dot)com>
To: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed
Date: 2010-03-10 18:34:39
Message-ID: 375c2da1003101034o4995f5c5u9beebe90e6e0f43a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(dot)major(at)gmail(dot)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(dot)kirkwood(at)catalyst(dot)net(dot)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
>>
>
>

In response to

Responses

pgsql-jdbc by date

Next:From: Kevin GrittnerDate: 2010-03-10 18:40:42
Subject: Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed
Previous:From: Andreas Joseph KroghDate: 2010-03-10 18:20:33
Subject: Re: Retrieving multidimentional array-column using JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group