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

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 logic table 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.jdbc4 and postgresql-9.2-1002.jdbc4) having some bug which is causing this problem or there can 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.singh@egsgroup.com W: www.egsgroup.com EGS Group Ltd Baird House, 15-17 St. Cross Street London, EC1N 8UW

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