You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Sterling Okura <st...@bizlift.com> on 2006/11/21 01:50:29 UTC
Problems w/ postgresql-8.1-407.jdbc3.jar
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))))]
Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
Now ,i have no choice but to do type cast manually just as following
String priority=String.valueOf(FieldMap.get("priority"));
if (!priority.equals("")){
FeldMap.put("priority",Double.valueOf(priority));
}
...
GenericValue WorkEffort=delegator.makeValidValue("WorkEffort",FieldMap);
Thanks and Regards
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11477025
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by BJ Freeman <bj...@free-man.net>.
based a previous response
and since I am running 8.2.4 and new jars with no problem
it may be that a database created with old jars can not be used.
MrJohnBrown sent the following on 7/5/2007 1:57 PM:
> The problem is that the newer version of jar does not work. That means that
> if the postgres server is upgraded at some point which probably will require
> a newer jar as well, then an error can arise back.
>
>
> BJ Freeman wrote:
>> am I missing something
>> if you have a jar that works what is the problem
>>
>> guo sent the following on 7/5/2007 6:53 AM:
>>> i dont think so.
>>> when i use the former jar file(which include in ofbiz's former
>>> version),it
>>> works
>>> and the database has not been changed
>>
>
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by MrJohnBrown <mi...@softasap.net>.
The problem is that the newer version of jar does not work. That means that
if the postgres server is upgraded at some point which probably will require
a newer jar as well, then an error can arise back.
BJ Freeman wrote:
>
> am I missing something
> if you have a jar that works what is the problem
>
> guo sent the following on 7/5/2007 6:53 AM:
>> i dont think so.
>> when i use the former jar file(which include in ofbiz's former
>> version),it
>> works
>> and the database has not been changed
>
>
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11454476
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by BJ Freeman <bj...@free-man.net>.
am I missing something
if you have a jar that works what is the problem
guo sent the following on 7/5/2007 6:53 AM:
> i dont think so.
> when i use the former jar file(which include in ofbiz's former version),it
> works
> and the database has not been changed
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
thanks all!
i reinstalled postgreSQL(version 8.2.4), JDBC driver =8.2-505.jdbc3 ,and
recreated the database
and in cmd lne ,executed "ant run-install"
then startup the ofbiz
In the java source
public static String ModifyEvent(HttpServletRequest request,
HttpServletResponse response) throws Exception {
Map returnMap = new HashMap();
boolean BeginTrans=false;
String workEffortId="";
try {
GenericDelegator delegator =
GenericDelegator.getGenericDelegator("default");
Map FieldMap=UtilHttp.getParameterMap(request);
BeginTrans=TransactionUtil.begin();
GenericValue
WorkEffort=delegator.makeValidValue("WorkEffort",FieldMap);
workEffortId=delegator.getNextSeqId("WorkEffort");
WorkEffort.set("workEffortId",workEffortId);
WorkEffort.set("lastStatusUpdate",UtilDateTime.nowTimestamp());
delegator.create(WorkEffort);
}catch(Excepion e){
...
}
and error occured.
but when i use another jdbc driver which is in OFBIZ's former version(i dont
know what version ,the dirver's size is 222KB),it works!
So i guess about the reason is the Jar's version.
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11460011
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
thanks all!
i reinstalled postgreSQL(version 8.2.4), and recreated the database
and in cmd lne ,executed "ant run-install"
then startup the ofbiz
In the java source
public static String ModifyEvent(HttpServletRequest request,
HttpServletResponse response) throws Exception {
Map returnMap = new HashMap();
boolean BeginTrans=false;
String workEffortId="";
try {
GenericDelegator delegator =
GenericDelegator.getGenericDelegator("default");
Map FieldMap=UtilHttp.getParameterMap(request);
BeginTrans=TransactionUtil.begin();
GenericValue
WorkEffort=delegator.makeValidValue("WorkEffort",FieldMap);
workEffortId=delegator.getNextSeqId("WorkEffort");
WorkEffort.set("workEffortId",workEffortId);
WorkEffort.set("lastStatusUpdate",UtilDateTime.nowTimestamp());
delegator.create(WorkEffort);
}catch(Excepion e){
...
}
and error occured.
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11460011
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by Daniel Martínez <da...@paradisosistemas.es>.
Just thinking out loud
Maybe is it that database changed from the former version? This could be
the reason why ofbiz uses a different type (from its entity definition
files) that the one in the actual database.
AFAIK there is no tool available to take care of upgrading the database
between versions
You can try backing up your database and then executing
java -jar ofbiz.jr -install -readers=seed
which will recreate the tables with the info from the entities definition.
--
Daniel
guo escribió:
> i dont think so.
> when i use the former jar file(which include in ofbiz's former version),it
> works
> and the database has not been changed
>
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
i dont think so.
when i use the former jar file(which include in ofbiz's former version),it
works
and the database has not been changed
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11446916
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by BJ Freeman <bj...@free-man.net>.
the error you show is not effected by the jars
it is a difference between the database created by the enitity and the code
guo sent the following on 7/5/2007 5:44 AM:
> postgreSQL 8.2.3
> then ,neither 8.2-505 JDBC 3 nor 8.3dev-600 JDBC 3 does not work.
>
> ERROR: column "priority" is of type numeric but expression is of type
> character varying
>
> the java source as following:
> GenericValue WorkEffort=delegator.makeValidValue("WorkEffort",FieldMap);
> delegator.create(WorkEffort);
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
postgreSQL 8.2.3
then ,neither 8.2-505 JDBC 3 nor 8.3dev-600 JDBC 3 does not work.
ERROR: column "priority" is of type numeric but expression is of type
character varying
the java source as following:
GenericValue WorkEffort=delegator.makeValidValue("WorkEffort",FieldMap);
delegator.create(WorkEffort);
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11445735
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: [Norton AntiSpam] Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by BJ Freeman <bj...@free-man.net>.
driver =postgresql-8.2-505.jdbc3.jar
PostgreSQL version 8.2.4
works ok
guo sent the following on 7/4/2007 8:02 AM:
> yes, i have try on 8.1 and 8.2 ,but it does not work
Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by Daniel Martínez <da...@paradisosistemas.es>.
Have you tried using latest jdbc driver? (8.2 or 8.3)
>From http://jdbc.postgresql.org/download.html
--Newer driver releases will get additional features and bug fixes that
you may need. Much care is taken to make newer driver releases work
against older servers, so if you are --having a problem and suspect it
is the driver's fault, don't hesitate to try out the latest release on
an older server. The current development driver is known to work with
all server --versions back to, and including, 7.2.
I am using postgresql 8.2 and jdbc driver 8.3dev-600 . All works like a
charm
Regards,
--
Daniel
guo escribió:
> yes, i have try on 8.1 and 8.2 ,but it does not work
>
Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
yes, i have try on 8.1 and 8.2 ,but it does not work
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11432439
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by Jacques Le Roux <ja...@les7arts.com>.
Did you try to update to Postgres 8.2 ?
Jacques
De : "guo" <pe...@hotmail.com>
>
> i encountered the error too:(
>
> but the jar file which in the ofbiz's former version work well,and if i use
> the jar file download from postgreSQL website(
> postgresql-8.1-407.jdbc3.jar), error occured.
>
> and the error occured in the makeValidValue method
>
> now what should i do?
> to use the early jar file?or to modify the makeValidValue method to
> implement the type cast?or use some other jar file?
> --
> View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11431007
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
i encountered the error too:(
but the jar file which in the ofbiz's former version work well,and if i use
the jar file download from postgreSQL website(
postgresql-8.1-407.jdbc3.jar), error occured.
and the error occured in the makeValidValue method
now what should i do?
to use the early jar file?or to modify the makeValidValue method to
implement the type cast?or use some other jar file?
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11431007
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problems w/ postgresql-8.1-407.jdbc3.jar
Posted by guo <pe...@hotmail.com>.
Now ,i have no choice but to do type cast manually just as following
String priority=String.valueOf(FieldMap.get("priority"));
if (!priority.equals("")){
FeldMap.put("priority",Double.valueOf(priority));
}
...
GenericValue WorkEffort=delegator.makeValidValue("WorkEffort",FieldMap);
Thanks and Regards
--
View this message in context: http://www.nabble.com/Problems-w--postgresql-8.1-407.jdbc3.jar-tf2676311.html#a11477026
Sent from the OFBiz - User mailing list archive at Nabble.com.