I was wondering if anyone noticed problems with the latest postgresql drivers? We upgraded our database server to 8.1.4. Now we get an error trying to Quick Ship orders with an offline payment. It looks like a weird casting problem (ERROR: column "amount_applied" is of type numeric but expression is of type character varying).
If I replace the 8.1.4 drivers with the old pg74.216.jdbc3.jar file, the error goes away and we can complete offline orders, but we have some occassional instability issues. We do not have the instability issues with the new 8.1.4 drivers. The OFBiz code is a checkout from mid April 06. Any ideas? Error posted below. thank you! sterling ERROR: Could not complete the Sub-method used by quickShip methods to create a shipment [file:/opt/ofb/latest/ofbiz/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createShipmentForFacilityAndShipGroup] process [problem invoking the [updateShipment] service with the map named [packedContext] containing [[shipmentId=27440, statusId=SHIPMENT_SHIPPED, userLogin=[GenericEntity:UserLogin][createdStamp,null()][createdTxStamp,null()][currentPassword,2ea61b258a8dc0eacfcf6ce9cec756ede3ce3eca( java.lang.String)][disabledDateTime,2006-08-11 13:57:44.861( java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N( java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2006-11-17 15:53:35.784(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-17 15:53:35.783 (java.sql.Timestamp)][partyId,admin(java.lang.String )][passwordHint,null()][successiveFailedLogins,0(java.lang.Long )][userLoginId,admin(java.lang.String)], locale=en_US]]: Problems with the transaction. (Exception while inserting the following entity: [GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-11-20 17:37:37.991(java.sql.Timestamp)][createdTxStamp,2006-11-20 17:37:37.991( java.sql.Timestamp)][invoiceId,27470(java.lang.String)][lastUpdatedStamp,2006-11-20 17:37:37.991(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-20 17:37:37.991 (java.sql.Timestamp)][paymentApplicationId,20070(java.lang.String )][paymentId,21180(java.lang.String)] (while inserting: [GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-11-20 17:37:37.991(java.sql.Timestamp)][createdTxStamp,2006-11-20 17:37:37.991( java.sql.Timestamp)][invoiceId,27470(java.lang.String)][lastUpdatedStamp,2006-11-20 17:37:37.991(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-20 17:37:37.991 (java.sql.Timestamp)][paymentApplicationId,20070(java.lang.String )][paymentId,21180(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PAYMENT_APPLICATION (PAYMENT_APPLICATION_ID, PAYMENT_ID, INVOICE_ID, INVOICE_ITEM_SEQ_ID, BILLING_ACCOUNT_ID, TO_PAYMENT_ID, TAX_AUTH_GEO_ID, AMOUNT_APPLIED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: column "amount_applied" is of type numeric but expression is of type character varying))))]
