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
4352
June 30, 2005 02:43PM
Re: Lock timeout
2316
July 06, 2005 03:56PM
2632
July 06, 2005 04:54PM
2611
July 07, 2005 01:34AM
2348
July 07, 2005 06:09AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.