467,877 Members | 1,110 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

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

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...)
Nov 12 '05 #1
  • viewed: 2770
Share:
1 Reply
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...)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by TimMcConechy | last post: by
1 post views Thread by keiko ishikawa | last post: by
8 posts views Thread by Mark A | last post: by
2 posts views Thread by Paul Duncan | last post: by
1 post views Thread by pike | last post: by
3 posts views Thread by db2admin | last post: by
3 posts views Thread by Brett R. Wesoloski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.