Re: Lock timeout

[David Wynter]

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