Friday, August 20, 2010

DB2 -- more trouble

Turns out that the version of the jdbc driver we are using has a different behavior than all other jdbc drivers. The javadoc indicates that you should be able to make repeated calls to ResultSet.next() and simply get a null when the end of the RS has been reached. But the db2 driver blows up after the first call to an exhausted (consumed) RS:


Caused by: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10120][10898] Invalid
 operation: result set is closed.
        at com.ibm.db2.jcc.b.zf.lb(zf.java:3276) [diffkit-app.jar:na]
        at com.ibm.db2.jcc.b.zf.c(zf.java:252) [diffkit-app.jar:na]
        at com.ibm.db2.jcc.b.zf.next(zf.java:237) [diffkit-app.jar:na]
        at org.diffkit.diff.sns.DKDBSource.getNextRow(DKDBSource.java:142) [diff
kit-app.jar:na]
    

According to this, there is a new db2 jdbc driver that cures this behavior, and as a bonus doesn't require a license file!

db2 9.5

This is part of the 9.5 release, so I'm not sure it will be compatible with lower versions, but seems worth a try.

16 comments:


  1. We also provide deep cleaning services for houses, villas, apartments and furnishings, and use of garden steam cleaners that clean and eliminate germs.
    You can see more of this link:
    شركة الاول للتنظيف و مكافحة الحشرات
    شركة مكافحة حشرات بالرياض مكافحة الحشرات بالرياض

    ReplyDelete
  2. I value the information you provided in this post on jdbc drivers. I genuinely hope that others will find your website to be admirable, so please keep up the good work. In any case, use the assignment help services in birmingham. You should utilise this website for your homework because I recently tried it and really liked it.

    ReplyDelete