problems using sqlj and db2-8.1 (SET CURRENT PACKAGESET )

[chaos]

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 applicationcontainer (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.ibm.db2.jcc.a.da;)I(bx .java:33)
at com.ibm.db2.jcc.a.bx.c(Lcom.ibm.db2.jcc.a.da;)V(bx .java:44)
at com.ibm.db2.jcc.c.bc.j(Lcom.ibm.db2.jcc.a.ct;)V(bc .java:284)
at com.ibm.db2.jcc.c.bc.f(Lcom.ibm.db2.jcc.a.ct;)V(bc .java:98)
at com.ibm.db2.jcc.c.q.f(Lcom.ibm.db2.jcc.a.ct;)V(q.j ava:119)
at com.ibm.db2.jcc.c.b.a(Lcom.ibm.db2.jcc.a.by;)V(b.j ava:1655)
at com.ibm.db2.jcc.a.by.b(Lcom.ibm.db2.jcc.a.cq;)V(by .java:35)
at com.ibm.db2.jcc.a.cd.b(Lcom.ibm.db2.jcc.a.cq;)V(cd .java:41)
at com.ibm.db2.jcc.a.f.b(Lcom.ibm.db2.jcc.a.cq;)V(f.j ava:123)
at com.ibm.db2.jcc.a.f.j(Lcom.ibm.db2.jcc.a.cq;)V(f.j ava:314)
at com.ibm.db2.jcc.c.a.j(Lcom.ibm.db2.jcc.a.cq;)V(a.j ava:450)
at com.ibm.db2.jcc.a.f.c(Lcom.ibm.db2.jcc.a.cq;)V(f.j ava:201)
at com.ibm.db2.jcc.a.cr.a(Lcom.ibm.db2.jcc.a.j;)V(cr. java:1624)
at com.ibm.db2.jcc.a.l.prepareSQLJStatement(Ljava.lan g.String;ILcom.ibm.db2.jcc.SQLJSection;Lcom.ibm.db 2.jcc.SQLJColumnMetaData;Lcom.ibm.db2.jcc.SQLJColu mnMetaData;ZZIIII)Lcom.ibm.db2.jcc.SQLJPreparedSta tement;(l.java:2004)
at com.ibm.db2.jcc.sqlj.f.<init>(Lcom.ibm.db2.jcc.SQL JConnection;Lcom.ibm.db2.jcc.sqlj.EntryInfo;Lcom.i bm.db2.jcc.sqlj.StaticPackage;Lsqlj.runtime.profil e.BatchContext;Z)V(f.java:205)
at com.ibm.db2.jcc.sqlj.c.getStatement(ILsqlj.runtime .profile.BatchContext;Ljava.util.Map;)Lsqlj.runtim e.profile.RTStatement;(c.java:112)
at sqlj.runtime.ExecutionContext$StatementStack.setSt atement(Lsqlj.runtime.profile.ConnectedProfile;ILs qlj.runtime.profile.BatchContext;Ljava.util.Map;)L sqlj.runtime.profile.RTStatement;(ExecutionContext .java:1088)
at sqlj.runtime.ExecutionContext.registerStatement(Ls qlj.runtime.ConnectionContext;Ljava.lang.Object;I) Lsqlj.runtime.profile.RTStatement;(ExecutionContex t.java:622)

The packageset is correct and exist. All other conditions are also
correct. (precompile,bind...)

[chaos]

the applicationserver is weblogic 8.1.

The same sqlj-programm runs without the applicationcontainer and also
in an own thread(not threadpool weblogic) in the same
applicationcontainer. But this is not really good solution.

ka***********@finanzit.com (chaos) wrote in message news:<de**************************@posting.google. com>...

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 applicationcontainer (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.ibm.db2.jcc.a.da;)I(bx .java:33)
at com.ibm.db2.jcc.a.bx.c(Lcom.ibm.db2.jcc.a.da;)V(bx .java:44)
at com.ibm.db2.jcc.c.bc.j(Lcom.ibm.db2.jcc.a.ct;)V(bc .java:284)
at com.ibm.db2.jcc.c.bc.f(Lcom.ibm.db2.jcc.a.ct;)V(bc .java:98)
at com.ibm.db2.jcc.c.q.f(Lcom.ibm.db2.jcc.a.ct;)V(q.j ava:119)
at com.ibm.db2.jcc.c.b.a(Lcom.ibm.db2.jcc.a.by;)V(b.j ava:1655)
at com.ibm.db2.jcc.a.by.b(Lcom.ibm.db2.jcc.a.cq;)V(by .java:35)
at com.ibm.db2.jcc.a.cd.b(Lcom.ibm.db2.jcc.a.cq;)V(cd .java:41)
at com.ibm.db2.jcc.a.f.b(Lcom.ibm.db2.jcc.a.cq;)V(f.j ava:123)
at com.ibm.db2.jcc.a.f.j(Lcom.ibm.db2.jcc.a.cq;)V(f.j ava:314)
at com.ibm.db2.jcc.c.a.j(Lcom.ibm.db2.jcc.a.cq;)V(a.j ava:450)
at com.ibm.db2.jcc.a.f.c(Lcom.ibm.db2.jcc.a.cq;)V(f.j ava:201)
at com.ibm.db2.jcc.a.cr.a(Lcom.ibm.db2.jcc.a.j;)V(cr. java:1624)
at com.ibm.db2.jcc.a.l.prepareSQLJStatement(Ljava.lan g.String;ILcom.ibm.db2.jcc.SQLJSection;Lcom.ibm.db 2.jcc.SQLJColumnMetaData;Lcom.ibm.db2.jcc.SQLJColu mnMetaData;ZZIIII)Lcom.ibm.db2.jcc.SQLJPreparedSta tement;(l.java:2004)
at com.ibm.db2.jcc.sqlj.f.<init>(Lcom.ibm.db2.jcc.SQL JConnection;Lcom.ibm.db2.jcc.sqlj.EntryInfo;Lcom.i bm.db2.jcc.sqlj.StaticPackage;Lsqlj.runtime.profil e.BatchContext;Z)V(f.java:205)
at com.ibm.db2.jcc.sqlj.c.getStatement(ILsqlj.runtime .profile.BatchContext;Ljava.util.Map;)Lsqlj.runtim e.profile.RTStatement;(c.java:112)
at sqlj.runtime.ExecutionContext$StatementStack.setSt atement(Lsqlj.runtime.profile.ConnectedProfile;ILs qlj.runtime.profile.BatchContext;Ljava.util.Map;)L sqlj.runtime.profile.RTStatement;(ExecutionContext .java:1088)
at sqlj.runtime.ExecutionContext.registerStatement(Ls qlj.runtime.ConnectionContext;Ljava.lang.Object;I) Lsqlj.runtime.profile.RTStatement;(ExecutionContex t.java:622)

The packageset is correct and exist. All other conditions are also
correct. (precompile,bind...)