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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • chaos
    #1

    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 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...)
    Tags: None
    • chaos
      #2
      Re: problems using sqlj and db2-8.1 (SET CURRENT PACKAGESET )

      the applicationserv er is weblogic 8.1.

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

      karsten.wendt@f inanzit.com (chaos) wrote in message news:<dedf5158. 0404140816.660c 7319@posting.go ogle.com>...[color=blue]
      > 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...)[/color]

        Comment

        Previous template Next
        Working...