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

Nishant,

Your email does suggest there is a bug in there somewhere. However we would
require a bit more of a detailed test case in order to be able to help find
it.

Regards,

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Fri, Jul 26, 2013 at 11:54 AM, Nishant Singh
<nishant(dot)singh(at)egsgroup(dot)com>wrote:

> 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 th
> is 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(dot)singh(at)egsgroup(dot)com
> W: www.egsgroup.com <http://www.egsgroup.com> [image: EGS Group]<http://www.egsgroup.com/> [image:
> spacer] EGS Group Ltd
> Baird House, 15-17 St. Cross Street
> London, EC1N 8UW [image: Red Herring Finalist 100 Europe]<http://www.egsgroup.com> [image:
> 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
>