Hello,
i have problems using sqlj in the following environment.
I use type 4 driver com.ibm.db2.jcc .DB2Driver and connect succesful to
8.1. db2-Database(DRDA)( Informational tokens are "DB2 v8.1.0.32",
"s031027", "MI00060", and FixPak "4".Product is installed at
"/opt/IBM/db2/V8.1"). It runs in an applicationcont ainer (jdk1.4,
linux). I tried all other drivers without success.
I execute sqlj-Statement
#sql [ctx] { SET CURRENT PACKAGESET = :packageSet };
and get an exception.
com.ibm.db2.jcc .a.SqlException : DB2 SQL error: SQLCODE: -725,
SQLSTATE: 42721, SQLERRMC: CLIENT APPLNAME;A1DB0A ;
at com.ibm.db2.jcc .a.bx.e(Lcom.ib m.db2.jcc.a.da; )I(bx.java:33)
at com.ibm.db2.jcc .a.bx.c(Lcom.ib m.db2.jcc.a.da; )V(bx.java:44)
at com.ibm.db2.jcc .c.bc.j(Lcom.ib m.db2.jcc.a.ct; )V(bc.java:284)
at com.ibm.db2.jcc .c.bc.f(Lcom.ib m.db2.jcc.a.ct; )V(bc.java:98)
at com.ibm.db2.jcc .c.q.f(Lcom.ibm .db2.jcc.a.ct;) V(q.java:119)
at com.ibm.db2.jcc .c.b.a(Lcom.ibm .db2.jcc.a.by;) V(b.java:1655)
at com.ibm.db2.jcc .a.by.b(Lcom.ib m.db2.jcc.a.cq; )V(by.java:35)
at com.ibm.db2.jcc .a.cd.b(Lcom.ib m.db2.jcc.a.cq; )V(cd.java:41)
at com.ibm.db2.jcc .a.f.b(Lcom.ibm .db2.jcc.a.cq;) V(f.java:123)
at com.ibm.db2.jcc .a.f.j(Lcom.ibm .db2.jcc.a.cq;) V(f.java:314)
at com.ibm.db2.jcc .c.a.j(Lcom.ibm .db2.jcc.a.cq;) V(a.java:450)
at com.ibm.db2.jcc .a.f.c(Lcom.ibm .db2.jcc.a.cq;) V(f.java:201)
at com.ibm.db2.jcc .a.cr.a(Lcom.ib m.db2.jcc.a.j;) V(cr.java:1624)
at com.ibm.db2.jcc .a.l.prepareSQL JStatement(Ljav a.lang.String;I Lcom.ibm.db2.jc c.SQLJSection;L com.ibm.db2.jcc .SQLJColumnMeta Data;Lcom.ibm.d b2.jcc.SQLJColu mnMetaData;ZZII II)Lcom.ibm.db2 .jcc.SQLJPrepar edStatement;(l. java:2004)
at com.ibm.db2.jcc .sqlj.f.<init>( Lcom.ibm.db2.jc c.SQLJConnectio n;Lcom.ibm.db2. jcc.sqlj.EntryI nfo;Lcom.ibm.db 2.jcc.sqlj.Stat icPackage;Lsqlj .runtime.profil e.BatchContext; Z)V(f.java:205)
at com.ibm.db2.jcc .sqlj.c.getStat ement(ILsqlj.ru ntime.profile.B atchContext;Lja va.util.Map;)Ls qlj.runtime.pro file.RTStatemen t;(c.java:112)
at sqlj.runtime.Ex ecutionContext$ StatementStack. setStatement(Ls qlj.runtime.pro file.ConnectedP rofile;ILsqlj.r untime.profile. BatchContext;Lj ava.util.Map;)L sqlj.runtime.pr ofile.RTStateme nt;(ExecutionCo ntext.java:1088 )
at sqlj.runtime.Ex ecutionContext. registerStateme nt(Lsqlj.runtim e.ConnectionCon text;Ljava.lang .Object;I)Lsqlj .runtime.profil e.RTStatement;( ExecutionContex t.java:622)
The packageset is correct and exist. All other conditions are also
correct. (precompile,bin d...)