Re: Backend Protocol Examples?

From: groups(at)ezotyrik(dot)org (Ezotyrik)
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Backend Protocol Examples?
Date: 2003-12-05 03:15:12
Message-ID: 3b4102b7.0312041915.1f576099@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ezotyrik(dot)org (Ezotyrik) wrote in message news:<3b4102b7(dot)0311301948(dot)59eae584(at)posting(dot)google(dot)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");

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message pginfo 2003-12-05 05:49:05 compiling pg 7.4 and jdbc
Previous Message Oliver Jowett 2003-12-04 03:39:34 Re: inet datatype