how to find what the sql excepion was with mysql

[Junkone]

I got an exception
E:/TradingTools/CODE/ImportTrade.rb:20:in `execute'

The associated piece of code is
st= dbConn.prepare("insert into raw_data

(SYMBOL,ACTION,SIZE,PRICE,DATE_TIME_OF_TRADE ,EXECUTION,ACCOUNT_ID)
VALUES(?,?,?,?,?,?,?)")
st.execute(dataArray[0],dataArray[1],dataArray[2],dataArray[3],tradeDate,dataArray[5],dataArray[6])
st.close

How do i find out what the exception details were that was triggered
at st.execute in this case.
any assistance will be appreciated

 

[Tom Machinski]

Assuming the exception object is e, you can check out e.

Exceptions and rescuing them works like this (assuming you want to
st.execute throws a MysqlException):

begin
st.execute(dataArray[0],dataArray[1],dataArray[2],dataArray[3],tradeDate,dataArray[5],dataArray[6])
rescue MysqlException => e
puts e.message
end

-Tom

 

[Junkone]

Assuming the exception object is e, you can check out e.

Exceptions and rescuing them works like this (assuming you want to
st.execute throws a MysqlException):

begin
st.execute(dataArray[0],dataArray[1],dataArray[2],dataArray[3],tradeDate,da­taArray[5],dataArray[6])
rescue MysqlException => e
puts e.message
end

-Tom

I got an exception
E:/TradingTools/CODE/ImportTrade.rb:20:in `execute'

The associated piece of code is
st= dbConn.prepare("insert into raw_data

(SYMBOL,ACTION,SIZE,PRICE,DATE_TIME_OF_TRADE ,EXECUTION,ACCOUNT_ID)
VALUES(?,?,?,?,?,?,?)")
st.execute(dataArray[0],dataArray[1],dataArray[2],dataArray[3],tradeDate,da­taArray[5],dataArray[6])
st.close

How do i find out what the exception details were that was triggered
at st.execute in this case.
any assistance will be appreciated- Hide quoted text -

- Show quoted text

Great. It works. Can i get it to print the sql that was executed that
caused the error. becaues i am using a prepared statement