Facing issue with driver postgresql-9.2-1003.jdbc4 on PostgreSQL 9.2.4

From: Nishant Singh <nishant(dot)singh(at)egsgroup(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Facing issue with driver postgresql-9.2-1003.jdbc4 on PostgreSQL 9.2.4
Date: 2013-07-26 15:54:29
Message-ID: 51F29BB5.3050904@egsgroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

My Java web application uses PostgreSQL. It has a document table with
one of the field called accountCode of type character varying(15)[]

In the logictable records are accessed through cursor. Thats is being
done through Apache Torque.(schema.xml: ...<table name="document"
idMethod="native">... <column name="accountCode" type="CLOB"
javaName="AccountCodeString"/>..)

PostgreSQL log for the cursor are as follows:
2013-07-26 15:14:00 BST 9592 efed-328 postgresLOG: execute <unnamed>:
DECLARE CursIt4 CURSOR FOR SELECT document.DOCUMENTID,
document.DOCUMENTNUMBER, document.ADHOCDOCUMENTNUM, document.ORGUNITID,
document.ACCOUNTID, document.TEMPLATEID, document.REFDOCUMENTID,
document.DOCUMENTTITLE, document.STATUSID, document.STATUSSTR,
document.DOCUMENTDATE, document.MODTYPEID, document.DELETEFLAG,
document.CURRENTSTEP, document.ITEMSREADONLY,
document.ISCLOSEDFOREINVOICING, document.ENABLEAUTOACDISTRIBUTION,
document.MODDATE, document.DEADLINE, document.ACCOUNTCODE,
document.EXTERNALID, document.MULTIPLESHIPPING,
document.MULTIPLEBILLING, document.MULTIPLEACCOUNTING,
document.DOCUMENTDESCRIPTION, document.REVISERNAME,
document.REVISEREMAIL, document.REVISERORGUNITNAME,
document.FORWARDREFID, document.REVISIONDATE, document.RESPONSEVENDORID,
document.RESPONSECATALOGUEID, document.COURIERNAME,
document.COURIERTRACKINGNO, document.WORKFLOWINSTANCEID,
document.WORKFLOWEVALUATED, document.PURCHASEORDERVENDORID,
document.PURCHASEORDERCATALOGUEIDS, document.NOTIFYSUPPLIER,
document.PURCHASEORDERVARIANT, document.MOD, document.ISQUICKORDER,
document.CONFIRMATIONORDER, document.WITHDRAWNFROMAPPROVAL,
document.SHIPPINGDATE, document.FMSNAME, document.EXTERNAL_REF_ID,
document.ISCISORDER, document.ISPROXY, document.ORIGINAL_PO_ID,
document.NUMBER_OF_VARIATIONS, document.ORIGINAL_ORDER_DATE,
document.SHARED_SECRET FROM document, organizationalUnit WHERE
document.ISPROXY<>1 AND organizationalUnit.ORGID=15136 AND
document.STATUSID IN
(1457,1456,1459,1458,1453,1466,1452,1455,1454,1450,1461,1470,1451) AND
document.ORGUNITID=organizationalUnit.ORGUNITID
...
2013-07-26 15:14:00 BST 9592 efed-328 postgresLOG: execute <unnamed>:
FETCH 25 FROM CursIt4
...

We have recently moved to PostgreSQL 9.2.4 and JDBC driver
postgresql-9.2-1003.jdbc4.jar. But we have noticed that now accountcode
field is not getting populated in the Java code. Same is happening with
postgresql-9.2-1002.jdbc4.jar

Earlier with PostgreSQL 9.1.4 and JDBC driver
postgresql-9.1-903.jdbc4.jar we were getting accountCode field populated
in the Java code.

But when we change to JDBC driver postgresql-9.1-903.jdbc4.jar on
PostgreSQL 9.2.4 it works fine.

Are new drivers (postgresql-9.2-1003.jdbc4and postgresql-9.2-1002.jdbc4)
having some bug which is causing this problem or therecan be some other
reason?

Thanks in advance.

Regards,
Nishant

*Nishant Singh*
Senior Developer
T: +44 (0) 207 539 2812
M: +44 (0) 7948 897 057
E: nishant(dot)singh(at)egsgroup(dot)com <mailto:nishant(dot)singh(at)egsgroup(dot)com>
W: www.egsgroup.com <http://www.egsgroup.com>
EGS Group <http://www.egsgroup.com/>

spacer EGS Group Ltd
Baird House, 15-17 St. Cross Street
London, EC1N 8UW

Red Herring Finalist 100 Europe <http://www.egsgroup.com> Government
Business Award Winner
<http://www.gbawards.governmentbusiness.co.uk/ar-top100-2011>

This message has been scanned for malware by SurfControl plc. www.surfcontrol.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message dmp 2013-07-28 00:55:13 Re: Website Redo Kick Off
Previous Message Kris Jurka 2013-07-25 03:20:14 Re: Website Redo Kick Off