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
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) |
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. |