Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC61777 Status: Closed

WHEN YOU COMPILE AN SQLJ PROGRAM IT GETS AN ERROR IF THE PACKAGE
NAME AND CLASS NAME ARE THE SAME.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The sqlj command fails if the package name and class name of the 
SQLJ program are the same. 
 
 
For example, if you have a program demo.sqlj which includes the 
following code: 
 
 package demo; 
 [...] 
 public class demo 
 { 
 [...] 
 } 
 
 
then when you run: 
 
 sqlj demo.sqlj 
 
 
you get an error like: 
 
 demo.java:201: cannot resolve symbol 
 symbol  : class demo_SJProfileKeys 
 location: class demo.demo 
     synchronized(demo.demo_SJProfileKeys.class) { 
                      ^ 
 1 error
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of sqlj with DB2 for Linux, UNIX and Windows           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************
Local Fix:
Make the package name and class name of the SQLJ program 
different from each other.
available fix packs:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 9.7 Fix Pack 1
Workaround
As a workaround, you can make the package name and class name 
of the SQLJ program different from each other.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.06.2009
24.01.2011
28.01.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP1
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.1 FixList