[ebxmlms-general] Hermes and DB2

[<Chr...@ml...>]

Hello,

I am evaluating Hermes v.0.9.3.1 on my WinXP using a DB2 V8 database on 
our DB server. 
The normal operation works fine. 
Now I wanted to test backup/restore and I got the error, that "scroll 
sensitive result sets" are not supported by my version of the DB2 jdbc 
driver.

I found, that this problem is caused by this part of DbTableManager.java:

    private static void backupTable(Connection connection, String 
tableName,
        String ddl, OutputStream os) throws DbTableManagerException {

        logger.debug("=> DbTableManager.backupTable (table: " + tableName
            + ")");

        try {
            // Query the table and set fetch size to 50 records per fetch
            Statement statement = connection.createStatement
                (ResultSet.TYPE_SCROLL_SENSITIVE, 
ResultSet.CONCUR_READ_ONLY);    <======== unsupported in DB2 V7
            // statement.setFetchSize(50);
            ResultSet resultSet = statement.executeQuery
                ("SELECT * FROM " + tableName);
            ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
            int numColumns = resultSetMetaData.getColumnCount();

The ResultSet.TYPE_SCROLL_SENSITIVE is not supported.

Would it be possible to change this setting to ResultSet.TYPE_FORWARD_ONLY 
?
I believe, that no features are used, which would prevent this change.

Bye
Christoph 

Dr. Christoph Oberle
MLP Lebensversicherung AG
Mathematik / MLP Lebensversicherung AG
Forum 7
D-69126 Heidelberg
Tel.: 06221/308-2683
Fax: 06221/308-8111
Mobil: 0172/7603343
chr...@ml...