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?