You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2008/04/13 00:58:08 UTC
[jira] Closed: (OFBIZ-1415) Thread freeze when executing
PreparedStatement with PosgreSQL
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux closed OFBIZ-1415.
----------------------------------
Resolution: Cannot Reproduce
Assignee: Jacques Le Roux
> Thread freeze when executing PreparedStatement with PosgreSQL
> -------------------------------------------------------------
>
> Key: OFBIZ-1415
> URL: https://issues.apache.org/jira/browse/OFBIZ-1415
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Leon Torres
> Assignee: Jacques Le Roux
>
> I'm getting a hard freeze in a thread when it attempts to executeQuery() using the postgresql Jdbc3 Prepared Statement. It affects the OrderServices.createPaymentPreference() method. After extensive probing of the issue, I can't figure out why. Here's a verbose log of what happens. The thread stops after the last line and never resumes, causing the browser to remain loading indefinitely.
> I suspect something is going on with BigDecimal or the nature of the insert. Any ideas?
> 2007-11-20 12:22:05,985 (http-0.0.0.0-8443-Processor3) [ ServiceDispatcher.java:347:INFO ] ### Invoking Sync Service [createOrderPaymentPreference]
> 2007-11-20 12:22:06,003 (http-0.0.0.0-8443-Processor3) [ SequenceUtil.java:258:INFO ] Got bank of sequenced IDs for [OrderPaymentPreference]; curSeqId=10220, maxSeqId=10230, bankSize=10
> 2007-11-20 12:22:06,006 (http-0.0.0.0-8443-Processor3) [ GenericEntity.java:389:WARN ] In entity field [OrderPaymentPreference.maxAmount] set the value passed in [java.math.BigDecimal] is not compatible with the Java type of the fi
> eld [Double]
> 2007-11-20 12:22:06,008 (http-0.0.0.0-8443-Processor3) [ GenericDAO.java:168:INFO ] ### saving fields [ModelEntity[OrderPaymentPreference]@orderPaymentPreferenceId, ModelEntity[OrderPaymentPreference]@orderId, ModelEntity[OrderP
> aymentPreference]@orderItemSeqId, ModelEntity[OrderPaymentPreference]@productPricePurposeId, ModelEntity[OrderPaymentPreference]@paymentMethodTypeId, ModelEntity[OrderPaymentPreference]@paymentMethodId, ModelEntity[OrderPaymentPreferenc
> e]@finAccountId, ModelEntity[OrderPaymentPreference]@securityCode, ModelEntity[OrderPaymentPreference]@presentFlag, ModelEntity[OrderPaymentPreference]@overflowFlag, ModelEntity[OrderPaymentPreference]@maxAmount, ModelEntity[OrderPaymen
> tPreference]@processAttempt, ModelEntity[OrderPaymentPreference]@billingPostalCode, ModelEntity[OrderPaymentPreference]@manualAuthCode, ModelEntity[OrderPaymentPreference]@manualRefNum, ModelEntity[OrderPaymentPreference]@statusId, Mode
> lEntity[OrderPaymentPreference]@needsNsfRetry, ModelEntity[OrderPaymentPreference]@createdDate, ModelEntity[OrderPaymentPreference]@createdByUserLogin, ModelEntity[OrderPaymentPreference]@lastUpdatedStamp, ModelEntity[OrderPaymentPrefer
> ence]@lastUpdatedTxStamp, ModelEntity[OrderPaymentPreference]@createdStamp, ModelEntity[OrderPaymentPreference]@createdTxStamp] from entity [GenericEntity:OrderPaymentPreference][createdByUserLogin,DemoSalesManager(java.lang.String)][cr
> eatedDate,2007-11-20 12:22:06.007(java.sql.Timestamp)][createdStamp,2007-11-20 12:22:06.007(java.sql.Timestamp)][createdTxStamp,2007-11-20 12:22:05.187(java.sql.Timestamp)][lastUpdatedStamp,2007-11-20 12:22:06.007(java.sql.Timestamp)][l
> astUpdatedTxStamp,2007-11-20 12:22:05.187(java.sql.Timestamp)][maxAmount,25.07(java.math.BigDecimal)][orderId,WS10000(java.lang.String)][orderPaymentPreferenceId,10220(java.lang.String)][paymentMethodId,10000(java.lang.String)][paymentM
> ethodTypeId,CREDIT_CARD(java.lang.String)]
> 2007-11-20 12:22:06,009 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [orderPaymentPreferenceId] of type [String] and fieldtype [1] to [10220]
> 2007-11-20 12:22:06,011 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [orderId] of type [String] and fieldtype [1] to [WS10000]
> 2007-11-20 12:22:06,012 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [orderItemSeqId] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,013 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [productPricePurposeId] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,014 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [paymentMethodTypeId] of type [String] and fieldtype [1] to [CREDIT_CARD]
> 2007-11-20 12:22:06,015 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [paymentMethodId] of type [String] and fieldtype [1] to [10000]
> 2007-11-20 12:22:06,016 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [finAccountId] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,017 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [securityCode] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,025 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [presentFlag] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,026 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [overflowFlag] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,027 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [maxAmount] of type [java.math.BigDecimal] and fieldtype [9] to [25.07]
> 2007-11-20 12:22:06,028 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [processAttempt] of type [Long] and fieldtype [6] to [null]
> 2007-11-20 12:22:06,029 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [billingPostalCode] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,030 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [manualAuthCode] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,030 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [manualRefNum] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,031 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [statusId] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,032 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [needsNsfRetry] of type [String] and fieldtype [1] to [null]
> 2007-11-20 12:22:06,033 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [createdDate] of type [java.sql.Timestamp] and fieldtype [2] to [2007-11-20 12:22:06.007]
> 2007-11-20 12:22:06,034 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [createdByUserLogin] of type [String] and fieldtype [1] to [DemoSalesManager]
> 2007-11-20 12:22:06,035 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [lastUpdatedStamp] of type [java.sql.Timestamp] and fieldtype [2] to [2007-11-20 12:22:06.007]
> 2007-11-20 12:22:06,036 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [lastUpdatedTxStamp] of type [java.sql.Timestamp] and fieldtype [2] to [2007-11-20 12:22:05.187]
> 2007-11-20 12:22:06,037 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [createdStamp] of type [java.sql.Timestamp] and fieldtype [2] to [2007-11-20 12:22:06.007]
> 2007-11-20 12:22:06,038 (http-0.0.0.0-8443-Processor3) [ SqlJdbcUtil.java:704:INFO ] ### setting field [createdTxStamp] of type [java.sql.Timestamp] and fieldtype [2] to [2007-11-20 12:22:05.187]
> 2007-11-20 12:22:06,038 (http-0.0.0.0-8443-Processor3) [PreparedStatementInPool.java:71 :INFO ] ### executeUpdate() using PreparedStatement org.postgresql.jdbc3.Jdbc3PreparedStatement
> 2007-11-20 12:22:06,039 (http-0.0.0.0-8443-Processor3) [PreparedStatementInPool.java:72 :INFO ] ### executeUpdate() on:
> INSERT INTO public.ORDER_PAYMENT_PREFERENCE (ORDER_PAYMENT_PREFERENCE_ID, ORDER_ID, ORDER_ITEM_SEQ_ID, PRODUCT_PRICE_PURPOSE_ID, PAYMENT_METHOD_TYPE_ID, PAYMENT_METHOD_ID, FIN_ACCOUNT_ID, SECURITY_CODE, PRESENT_FLAG, OVERFLOW_FL
> AG, MAX_AMOUNT, PROCESS_ATTEMPT, BILLING_POSTAL_CODE, MANUAL_AUTH_CODE, MANUAL_REF_NUM, STATUS_ID, NEEDS_NSF_RETRY, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES
> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.