[ 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 [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.