w1nk / node-odbc

unixODBC bindings for node
MIT License
90 stars 102 forks source link

support for SQL_SUCCESS_WITH_INFO return #105

Closed amcintyre99 closed 7 years ago

amcintyre99 commented 8 years ago

hey there!! long time!!

using executeNonQuery and trying to figure out why error var in cb is null and rows has -1 and found SQL_SUCCESS_WITH_INFO being returned

and according to CLI trace there's an unretrieved error message

any chance of handling this by setting the error var with the msg?

fyi, one of your forks mentions this return but has the same null error var issue and also doesn't retrieve the msg https://github.com/ibmdb/node-ibm_db/search?utf8=%E2%9C%93&q=SQL_SUCCESS_WITH_INFO

SQLExecute( hStmt=1:1 )
    ---> Time elapsed - +8.483299E+000 seconds
( Row=1, iPar=1, fCType=SQL_C_BIGINT, rgbValue=21, pcbValue=0, piIndicatorPtr=0 )
( Row=1, iPar=2, fCType=SQL_C_WCHAR, rgbValue="" - x'', pcbValue=-3, piIndicatorPtr=-3 )
( Row=1, iPar=3, fCType=SQL_C_BIGINT, rgbValue=28, pcbValue=0, piIndicatorPtr=0 )
( Row=1, iPar=4, fCType=SQL_C_BIGINT, rgbValue=27, pcbValue=0, piIndicatorPtr=0 )
( Row=1, iPar=5, fCType=SQL_C_BIGINT, rgbValue=30, pcbValue=0, piIndicatorPtr=0 )
( Row=1, iPar=6, fCType=SQL_C_CHAR, rgbValue=<NULL pointer>, pcbValue=-1, piIndicatorPtr=-1 )
( COMMIT REPLY RECEIVED=1 )

SQLExecute( )
    <--- SQL_SUCCESS_WITH_INFO   Time elapsed - +1.376000E-003 seconds

SQLRowCount( hStmt=1:1, pcRow=&00007ffc38dc1d0c )
    ---> Time elapsed - +7.706593E+000 seconds
( Unretrieved error message="[IBM][CLI Driver][DB2/LINUXX8664] SQL0407N  Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=4, COLNO=6" is not allowed.  SQLSTATE=23502
" )

SQLRowCount( pcRow=-1 )
    <--- SQL_SUCCESS   Time elapsed - +2.300000E-004 seconds
amcintyre99 commented 8 years ago

interesting that the original module you forked from also mentions the return https://github.com/w1nk/node-odbc/search?utf8=%E2%9C%93&q=SQL_SUCCESS_WITH_INFO