Re: SQL exception SQL7008

I am somewhat familiar with the SQL7008 message. It is a little notorious. 
Essentially it means that the table you are trying to update is not 
journaled. If I may guess, are you attempting to use the native DB2 
driver, locally on the iSeries? As the iSeries seems to be one of the few 
platforms where transaction support is not enabled by default, some JDBC 
drivers have a problem with a committable database action. If you are 
using the default setting of "autocommit" or you issue a commit in your 
own code, you will receive an SQL7008 unless you have a journal receiver 
defined for the tables you are attempting to update.

The quick way around this is to connect to the driver with the following 
properties:

            Connection nativeDriverConnection = null;
            try {
                final Properties properties = new Properties ();
                // The following DB2 directive is needed to prevent an
                // SQL7008 error on files that are not journaled.
                properties.put ("transaction isolation", "none");
                Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
                nativeDriverConnection =
                        DriverManager.getConnection("jdbc:db2://"
                                                    + 
as400.getSystemName(),
                                                    properties);
            } catch (ClassNotFoundException e) {
                LOGGER.error("Error in DataCollector.getConnection "
                             + "loading JDBC driver 
com.ibm.db2.jdbc.app.DB2Driver",
                             e);
            }

I hope this helps.


Jeff Furgal / MIMIX Product Architect
Lakeview Technology, Inc.
Suite 600
1901 S. Meyers Rd.
Oakbrook Terrace, IL 60181

furgalj@xxxxxxxxxxxxxxxx