Thread: BUG #2249: unsupported frontend protocol

The following bug has been logged online:

Bug reference:      2249
Logged by:          Satheesh
Email address:      satheeshravikumar@gmail.com
PostgreSQL version: 7.3.2
Operating system:   Red hat Linux 9
Description:        unsupported frontend protocol
Details:

hi,

iam having database server postgres version 7.3.2 and jboss 4.x as
webserver, while executing the application iam getting an error message of
"FATAL:Unsupported Front end Protocol". This makes my application to execute
slowly. plz help me. Tahnks in Advance


satheesh

"Satheesh" <satheeshravikumar@gmail.com> writes:
> iam having database server postgres version 7.3.2 and jboss 4.x as
> webserver, while executing the application iam getting an error message of
> "FATAL:Unsupported Front end Protocol". This makes my application to execute
> slowly. plz help me. Tahnks in Advance

You probably need 7.4 or later Postgres.

            regards, tom lane

On Thu, 9 Feb 2006, Satheesh wrote:

> The following bug has been logged online:
>
> Bug reference:      2249
> PostgreSQL version: 7.3.2
> Description:        unsupported frontend protocol
> Details:
>
> iam having database server postgres version 7.3.2 and jboss 4.x as
> webserver, while executing the application iam getting an error message
> of "FATAL:Unsupported Front end Protocol". This makes my application to
> execute slowly. plz help me. Tahnks in Advance
>

When using a new JDBC driver with an old server version it first tries to
connect with the v3 protocol and then falls back to the v2 protocol if
that fails.  To tell the driver you want a v2 protocol from the start add
?protocolVersion=2 to your URL.

Kris Jurka