RESOLVED: SQL Errors after 7.1 upgrade?

["daveML@xxxxxxxxxxxx" <daveML@xxxxxxxxxxxx>]

Hi All,

The root cause of the problem is that in 7.1 the default JDK has changed 
from 1.5 to 1.6.  In 1.6 there is a feature that automatically loads ALL 
JDBC drivers in the class path whenever the JVM is started.

When the native JDBC driver is loaded, the system automatically changes the 
job to SQL Server Mode - which caused library list issues, broken cursors, 
etc, etc.

The solution for me, since we have no explicit need for JDK 1.6 versus 1.5, 
was to set JAVA_HOME to 1.5 like this:
ADDENVVAR 
  ENVVAR(JAVA_HOME)                                  
  VALUE('/QOpenSys/QIBM/ProdData/JavaVM/jdk50/32bit' )                      
                      
  LEVEL(*SYS)                                        

Thanks to all who helped, especially the DB2 and Java Data Access teams at 
IBM.

Dave

----------------------------------------

From: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
Sent: Monday, July 26, 2010 9:51 PM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: AW: SQL Errors after 7.1 upgrade? 

Hi,

I assume the naming was changed from *SYS to *SQL (even though I cannot
explain how it would have been happened).