MySQL Forums
Forum List  »  InnoDB

Re: Lock timeout
Posted by: David Wynter
Date: July 06, 2005 03:56PM

Is my question too difficult?

Here is the query as a PreparedStatement in JDBC

INSERT INTO CONVERTIBLE_BOND_INFO (STK_BUYBACK_CD, SETTLE_PERIOD_VAL, TYPE_CD, CONV_CURR_CD, SETTLE_PERIOD_CD, EXERCISE_CD, UNDERLYING_ASSET_DESC, BASKET_WEIGHT_CD, UNDERLYING_ASSET_ID, PREMIUM_AT_ISSUE, DILUTION_PROTECT_FL, PROCESSED, CONV_INT_CD, ASSET_ID, CONVERSION_RATE, NOTICE_PERIOD_VAL, ISSUER_CHOOSES_DELIVERY_FL, CONV_FORMULA, UNDERLYING_ASSET_RIC, UNDERLYING_UNIT_CD, BASKET_WEIGHT_VAL, NOTICE_PERIOD_CD, CONV_EFF_DT ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE STK_BUYBACK_CD=?, SETTLE_PERIOD_VAL=?, TYPE_CD=?, CONV_CURR_CD=?, SETTLE_PERIOD_CD=?, EXERCISE_CD=?, UNDERLYING_ASSET_DESC=?, BASKET_WEIGHT_CD=?, UNDERLYING_ASSET_ID=?, PREMIUM_AT_ISSUE=?, DILUTION_PROTECT_FL=?, PROCESSED=?, CONV_INT_CD=?, ASSET_ID=?, CONVERSION_RATE=?, NOTICE_PERIOD_VAL=?, ISSUER_CHOOSES_DELIVERY_FL=?, CONV_FORMULA=?, UNDERLYING_ASSET_RIC=?, UNDERLYING_UNIT_CD=?, BASKET_WEIGHT_VAL=?, NOTICE_PERIOD_CD=?, CONV_EFF_DT=?

No other queries are running at the time and it times out everytime it runs.

Ideas?

David

Options: ReplyQuote


Subject
Views
Written By
Posted
4155
June 30, 2005 02:43PM
Re: Lock timeout
2196
July 06, 2005 03:56PM
2540
July 06, 2005 04:54PM
2496
July 07, 2005 01:34AM
2229
July 07, 2005 06:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.