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.
