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