JDBC Question... Not sure where to ask..

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

Scott,

Your JDBC wrapper is fantastic, and I just had a technical questions about it...


In this routine:

P JDBC_ExecQry    B                   export
D JDBC_ExecQry    PI                  like(ResultSet)
D   conn                              like(Connection) const
D   sql                      32767A   varying const options(*varsize)
D temp            s                   like(ResultSet)
D stmt            s                   like(Statement)
D rs              s                   like(ResultSet)
 /free
     monitor;
        jdbc_begin_object_group(5);
        stmt = createStatement( conn );
        temp = executeQuery( stmt : s(sql));
        jdbc_end_object_group(temp: rs);
     on-error;
        return *NULL;
     endmon;
     return rs;
 /end-free
P                 E



When I used a lower case select statement (MS SQL SERVER), the program errored out at the [temp = executeQuery( stmt : s(sql);]  and hit the on-error condition, and it skipped the jdbc_end_object_group function...  I was wondering, if that was ok, or should the on-error release the object group resources.

When I changed the case of my SQL to upper it worked fine...



Thanks, Tim


------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain 
confidential or privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the 
sender by reply e-mail and destroy the message.


==============================================================================

-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------