How to find what the sql excepion was with mysql

Ruby
1

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

2

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

3

On Oct 28, 12:21 pm, “Tom M.hinski” [email protected] wrote:

st= dbConn.prepare("insert into raw_data

  • 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