Please help me, give me an example how to error handling (or print error message) if I have an wrong query. I have tried this code with wrong table name (TB_DAT => TB_DATA) but the SQLException doesn't return anything.
Connection_T conn = ConnectionPool_getConnection(pool);
TRY { ResultSet_T r = Connection_executeQuery( conn, "select id from TB_DAT" );
while ( ResultSet_next( r ) ) __PRINT( ResultSet_getString( r, 1 ) ); } CATCH( SQLException ) { printf( "SQLException - %s\n", Exception_frame.message ); } FINALLY { Connection_close( conn ); } END_TRY;
Thanks Hans