From: Tom Machinski <tom.machinski@...>
Date: 2007-10-29T01:21:39+09:00
Subject: Re: how to find what the sql excepion was with mysql

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



On 10/28/07, Junkone <junkone1@gmail.com> wrote:
> 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
>
>
>