JDBC API to send SimpleQuery ('Q')?

From: Karthik Segpi <karthik(dot)segpi(at)gmail(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC API to send SimpleQuery ('Q')?
Date: 2014-04-25 15:10:43
Message-ID: CACD7L9FeKERVub6kDqKTn7C1aYFPSM=nPJycnf+QpwKUGwq4VQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-jdbc

I have the following Java code running in tomcat 7 using
'postgresql-9.3-1101-jdbc41.jar' driver.

String str = "insert into tab1(a,b) values ('name', 'address');"
Statement stmt = conn.createStatement();
stmt.execute(str);

Considering that this is *not* a PreparedStatement, I would have expected
the driver to issue a Simple Query ('Q') instead of an ExtendedQuery ('P').
However, when I print the incoming connection at my middleware (pgpool), I
see the query being received is an ExtendedQuery ('P'). When I execute the
same query in psql, it triggers a Simple Query ('Q') as expected.

What am I missing here? Are there any other settings that I need to tweak?

Thanks

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2014-04-25 15:30:18 Re: JDBC API to send SimpleQuery ('Q')?
Previous Message Sebastien FLAESCH 2014-04-14 14:24:19 Re: Type identification with libpq / PQFmod() when using aggregates (SUM)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2014-04-25 15:30:18 Re: JDBC API to send SimpleQuery ('Q')?
Previous Message Tomonari Katsumata 2014-04-24 08:23:11 Re: About binaryTransfer.