Some bugs are fixed in 0.25 PDF Print E-mail
The new version 0.25 fix some problems with SELECT - Statements on tables with many columns. With version 0.25 errors like this can occur within tables with many columns:

            Error: Invalid Message Count (452); expected: 38 got: 942946098.
            Connection closed

            (Client Driver Version: 5.0.5504.0) Size: 679Kb

            Error: Communication link failure: Socket closed
            (Client Driver Version: 5.0.5902.0) Size: 977Kb

            Error: Communication link failure: Socket closed
            (Client Driver Version: 5.1.0.826) Size:  1,466Kb

The exact message depends on the version of your jdbc driver.

In 0.24 a statement like this was used :

    _conn.createStatement(ResultSet.TYPE_SCROLL_INSITIVE,ResultSet.CONCUR_READ_ONLY);

I do not exactly know what the problem is, but within large tables the described errors arise.
So i switched back to the old create statement call and it seems to work for now.

I also tested Cache Monitor with different versions of jdbc drivers
and the best version seems to be 5.0.5902.0

Bye

Andreas