Re: Accessing mainframe DB2 in Java.

zalek wrote:
> Hello,
> 
> I am a mainframe Cobol programmer (yes - Cobol programmers are still
> around, mostly in caves) and I am writing a java code to access DB2.
> In a Cobol world after each SQL command we are checking for return
> conditions like success (sqlcode=0), not found (sqlcode = +100),
> duplicates (sqlcode=803) and more.

If you intend to write to the db directly, rather than via ORM, then I'd 
recommend using Spring's JDBC facilities. Their approach to this issue 
is to rethrow much more specific exceptions outlining what went wrong. I 
find this to be marginally better, but the real benefit of Spring here 
is getting rid of all that horrid boiler plate code that one must write 
with straight JDBC. If your intent is to learn, then try a few methods 
both ways and see for yourself.

-- 
Shane