[
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 [EMAIL PROTECTED], [EMAIL
> PROTECTED], ModelEntity[OrderP
> [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],
> ModelEntity[OrderPaymentPreferenc
> [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],
> [EMAIL PROTECTED], ModelEntity[OrderPaymen
> [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],
> [EMAIL PROTECTED], Mode
> [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],
> ModelEntity[OrderPaymentPrefer
> [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] 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.
