|
P: n/a
|
DB2 UDB V8.1 Fixpak 4 AIX 5.1
CLASSPATH:
/usr/opt/db2_08_01/java/db2jcc.jar:/usr/opt/db2_08_01/java/db2jcc_license_cu.jar:/usr/opt/db2_08_01/java/sqlj.zip:/usr/java131/jre/lib/rt.jar:
Program: tmp0.sqlj
import java.sql.*;
import sqlj.runtime.*;
import sqlj.runtime.ref.*;
import com.ibm.math.*;
#sql iterator table1_Cursor1 implements sqlj.runtime.Scrollable with
(sensitivity=SENSITIVE, dynamic=false) (String c1);
class tmp0
{
static
{
try
{
Class.forName("com.ibm.db2.jcc.DB2Driver").newInst ance();
}
catch (Exception e)
{
e.printStackTrace();
}
}
public static void main(String argv[])
{
try
{
table1_Cursor1 cursor1=null;
#sql cursor1 = { SELECT c1 from schema1.table1};
}
catch( Exception e )
{
System.out.println("\n Trapped " );
e.printStackTrace();
System.exit(1);
}
}
}
Precompile: sqlj -compile=false tmp0.sqlj
Error/warning:
tmp0.sqlj:6.1-6.119: Warning: Iterator attribute dynamic is not
defined in the SQLJ specification.
tmp0.sqlj:27.1-27.47: Error: Invalid sensitivity WITH value. Detail
message: null
Total 1 error and 1 warning.
The (universal) sqlj driver works for basic cursor and fetch next. But
this precompile fails. Is there an update for sqlj I missed?
Bernard Dhooghe
| |
Share this question for a faster answer!
