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