Re: Backend Protocol Examples? - Mailing list pgsql-jdbc

From groups@ezotyrik.org (Ezotyrik)
Subject Re: Backend Protocol Examples?
Date
Msg-id 3b4102b7.0312041915.1f576099@posting.google.com
Whole thread Raw
In response to Backend Protocol Examples?  (groups@ezotyrik.org (Ezotyrik))
Responses Re: Backend Protocol Examples?
List pgsql-jdbc
Guess my next question is does anyone know of a more appropriate place
to ask this question?

I know some work was done on creating a COPY api -- hopefully that
code makes it into a future JDBC release, and I can study that.

groups@ezotyrik.org (Ezotyrik) wrote in message news:<3b4102b7.0311301948.59eae584@posting.google.com>...
> 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");

pgsql-jdbc by date:

Previous
From: "Andrea Cannarsa"
Date:
Subject: Out of memory error
Next
From: Jason Briggs
Date:
Subject: problem with PSQLException/PSQLState