[jira] Created: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
Locked
[jira] Created: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
 
|
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 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. |
[jira] Commented: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544053 ] Leon Torres commented on OFBIZ-1415: ------------------------------------ I just noticed it's missing statusId = PAYMENT_NOT_AUTH, which I just added and it's still crashing. I'm going to look into what's happening at the database level next. > 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 > > 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. |
[jira] Commented: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544068 ] Leon Torres commented on OFBIZ-1415: ------------------------------------ When I run the service from the bsh terminal, it doesn't freeze. When I replace the service call in my code with a direct entity.create() operation, it freezes. This leads me to think there is some kind of database deadlock going on. This code is being implemented inside a ccRefund payment processor service. There's so much stuff going on in the payment gateway code, it's difficult to know what the context of database and thread usage is. Any ideas? > 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 > > 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. |
[jira] Commented: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544070 ] BJ Freeman commented on OFBIZ-1415: ----------------------------------- need to validate if this is getting to the db and if the db is returning from the call. then you can validate the driver is in fact doing what it is suppose to. After that it would be considered a problem in ofbiz > 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 > > 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. |
[jira] Commented: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544092 ] Leon Torres commented on OFBIZ-1415: ------------------------------------ Sure, but before I go poking at the postgres JDBC, is there any knowledge of deadlocking happening? > 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 > > 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. |
[jira] Commented: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544109 ] David E. Jones commented on OFBIZ-1415: --------------------------------------- What do you mean by a "deadlock"? Do you mean a database deadlock? If so I wouldn't expect it to behave like this, you would get an exception from the database telling you there was a deadlock. If you're running with the service engine it will even try to re-run the service when it detects a deadlock. > 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 > > 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. |
[jira] Commented: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544393 ] Scott Gray commented on OFBIZ-1415: ----------------------------------- What version of postgreSQL are you running? I stumbled across this: http://grokbase.com/topic/2007/08/10/jdbc-executequery-hangs-on-busy-server-proposal-sockettimeout-parameter/vL1VwcXdMECOLnlqs-2HDeCE0js/baasc1 > 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 > > 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. |
[jira] Commented: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12545346 ] Leon Torres commented on OFBIZ-1415: ------------------------------------ Scott, thanks! That seems to be it. My debugger points to a similar socket reading hangup and I did not suspect it could be the terminal cause. I won't be able to continue investigating as the feature I was working on that led me to this was canceled, but I could supply the code to reproduce it. From the thread Scott linked, we might have to consider refining the entity engine a little if we get more reports of this happening. > 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 > > 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. |
[jira] Closed: (OFBIZ-1415) Thread freeze when executing PreparedStatement with PosgreSQL
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |