"Protocol error. Session setup failed" (PostgreSQL 8.3devel/postgresql-8.3dev-600.jdbc3)

Started by Marcelo de Moraes Serpaalmost 19 years ago2 messagesgeneral
Jump to latest
#1Marcelo de Moraes Serpa
celoserpa@gmail.com

Hello,

I've built PostgreSQL 8.3 devel with VC++ 2005, done all the db
initialization process (creating the data dir using initdb, registering it
as a service using pg_ctl, etc) and tested by connecting to it through
pgAdmin III, I even built a C extension and ran it as a SP in the pgAdmin
SQL console.

I then restored a backup with the database of my under-development java
application in the hope that it would connect to this db transparently (I
have of course changed the jdbc driver to match the 8.3devel version).

When I tried to run my web java application, I received the following
PSQLException: ""Protocol error. Session setup failed"

What could be happening?

Note: I've attached the tomcat stack trace to the error.

Thanks,

Marcelo.

Attachments:

stacktrace.txttext/plain; name=stacktrace.txtDownload
#2Kris Jurka
books@ejurka.com
In reply to: Marcelo de Moraes Serpa (#1)
Re: "Protocol error. Session setup failed" (PostgreSQL 8.3devel/postgresql-8.3dev-600.jdbc3)

On Sat, 28 Apr 2007, Marcelo de Moraes Serpa wrote:

I've built PostgreSQL 8.3 devel with VC++ 2005, done all the db

When I tried to run my web java application, I received the following
PSQLException: ""Protocol error. Session setup failed"

This is a known bug in the server in CVS. A recent patch broke the
ability for clients to set the encoding they wish to converse in.

Kris Jurka