Backend Protocol Examples?

From: groups(at)ezotyrik(dot)org (Ezotyrik)
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Backend Protocol Examples?
Date: 2003-12-01 03:48:12
Message-ID: 3b4102b7.0311301948.59eae584@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I tried to do execute the following, but each time the program hangs
waiting on the ReceiveString. Also, the new postgres process started
to handle the query has a really high CPU % as reported by top.

I'd love to see simple examples of conversing with the backend. Also,
is there a nice summary of the protocol that offers more nitty-gritty
than the standard FE/BE discussion in the 7.4 docs?

Thanks!

synchronized( pg_stream ) {
try {
pg_stream.SendChar('Q');
pg_stream.Send( c.getEncoding().encode( "BEGIN" ));
pg_stream.SendChar(0);
pg_stream.flush();

System.out.println("step1");
str = pg_stream.ReceiveString( c.getEncoding() );
System.out.println("step2");

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2003-12-01 03:53:29 Re: autocommit trouble with jdbc on Postgres 7.4
Previous Message Dave Tenny 2003-12-01 03:16:27 Re: autocommit trouble with jdbc on Postgres 7.4