PaymentGatewayResponse

[G.Venkata Phanindra]

Hi,
       I am facing the following problem while inserting data into
PaymentGatewayResponse Entity
y is this happening......
Exception while inserting the following entity:
 [GenericEntity:PaymentGatewayResponse][createdStamp,2006-09-28 14:59:48.938
(java.sql.Timestamp)][createdTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][orderPaymentPreferenceId,10542(java.lang.String
)][paymentGatewayResponseId,10281(java.lang.String
)][paymentMethodId,null()][paymentMethodTypeId,EXT_GOOGLE(java.lang.String
)][paymentServiceTypeEnumId,PRDS_AUTH_PAY(java.lang.String
)][referenceNum,222203195990847(java.lang.String
)][transCodeEnumId,PGT_RELEASE(java.lang.String)][transactionDate,2006-09-28
14:59:48.938(java.sql.Timestamp)] (while inserting:
[GenericEntity:PaymentGatewayResponse][createdStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][createdTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][orderPaymentPreferenceId,10542(java.lang.String
)][paymentGatewayResponseId,10281(java.lang.String
)][paymentMethodId,null()][paymentMethodTypeId,EXT_GOOGLE(java.lang.String
)][paymentServiceTypeEnumId,PRDS_AUTH_PAY(java.lang.String
)][referenceNum,222203195990847(java.lang.String
)][transCodeEnumId,PGT_RELEASE(java.lang.String)][transactionDate,2006-09-28
14:59:48.938(java.sql.Timestamp)] (SQL Exception while executing the
following:INSERT INTO PAYMENT_GATEWAY_RESPONSE (PAYMENT_GATEWAY_RESPONSE_ID,
PAYMENT_SERVICE_TYPE_ENUM_ID, ORDER_PAYMENT_PREFERENCE_ID,
PAYMENT_METHOD_TYPE_ID, PAYMENT_METHOD_ID, TRANS_CODE_ENUM_ID, AMOUNT,
CURRENCY_UOM_ID, REFERENCE_NUM, ALT_REFERENCE, SUB_REFERENCE, GATEWAY_CODE,
GATEWAY_FLAG, GATEWAY_AVS_RESULT, GATEWAY_SCORE_RESULT, GATEWAY_MESSAGE,
TRANSACTION_DATE, RESULT_DECLINED, RESULT_NSF, RESULT_BAD_EXPIRE,
RESULT_BAD_CARD_NUMBER, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a
foreign key constraint fails))). Rolling back transaction.
**

--
G.Venkata Phanindra
Mob:: [phone]

[Raj-18]

Some of your value is null,I think your paymentMethodId is null

-----Original Message-----
From: G.Venkata Phanindra [mailto:[hidden email]]
Sent: Thursday, September 28, 2006 3:13 PM
To: [hidden email]
Subject: PaymentGatewayResponse

Hi,
       I am facing the following problem while inserting data into
PaymentGatewayResponse Entity
y is this happening......
Exception while inserting the following entity:
 [GenericEntity:PaymentGatewayResponse][createdStamp,2006-09-28 14:59:48.938
(java.sql.Timestamp)][createdTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][orderPaymentPreferenceId,10542(java.lang.String
)][paymentGatewayResponseId,10281(java.lang.String
)][paymentMethodId,null()][paymentMethodTypeId,EXT_GOOGLE(java.lang.String
)][paymentServiceTypeEnumId,PRDS_AUTH_PAY(java.lang.String
)][referenceNum,222203195990847(java.lang.String
)][transCodeEnumId,PGT_RELEASE(java.lang.String)][transactionDate,2006-09-28
14:59:48.938(java.sql.Timestamp)] (while inserting:
[GenericEntity:PaymentGatewayResponse][createdStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][createdTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-28 14:59:48.938(
java.sql.Timestamp)][orderPaymentPreferenceId,10542(java.lang.String
)][paymentGatewayResponseId,10281(java.lang.String
)][paymentMethodId,null()][paymentMethodTypeId,EXT_GOOGLE(java.lang.String
)][paymentServiceTypeEnumId,PRDS_AUTH_PAY(java.lang.String
)][referenceNum,222203195990847(java.lang.String
)][transCodeEnumId,PGT_RELEASE(java.lang.String)][transactionDate,2006-09-28
14:59:48.938(java.sql.Timestamp)] (SQL Exception while executing the
following:INSERT INTO PAYMENT_GATEWAY_RESPONSE (PAYMENT_GATEWAY_RESPONSE_ID,
PAYMENT_SERVICE_TYPE_ENUM_ID, ORDER_PAYMENT_PREFERENCE_ID,
PAYMENT_METHOD_TYPE_ID, PAYMENT_METHOD_ID, TRANS_CODE_ENUM_ID, AMOUNT,
CURRENCY_UOM_ID, REFERENCE_NUM, ALT_REFERENCE, SUB_REFERENCE, GATEWAY_CODE,
GATEWAY_FLAG, GATEWAY_AVS_RESULT, GATEWAY_SCORE_RESULT, GATEWAY_MESSAGE,
TRANSACTION_DATE, RESULT_DECLINED, RESULT_NSF, RESULT_BAD_EXPIRE,
RESULT_BAD_CARD_NUMBER, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a
foreign key constraint fails))). Rolling back transaction.
**

--
G.Venkata Phanindra
Mob:: [phone]