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

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
>>
>
>