This week's book giveaway is in the Cloud/Virtualization forum.
We're giving away four copies of Cloud Application Architecture Patterns: Designing, Building, and Modernizing for the Cloud and have Kyle Brown, Bobby Woolf and Joseph Yodor on-line!
See this thread for details.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

DB2 SQLJ binding error

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I am trying to bind SQLJ using DB2 database. I am using WASAD and DB2. But while binding/customizing i am getting following error:

Buildfile: C:\starteam\Factory_ISO\ISOWEB\SQLJAntScripts\sqlj.customize.xml

com.deere.ua0.iso.persistence.brokers.sqlj.SQLJDatabaseAccessBroker:

com.deere.ua0.iso.persistence.brokers.sqlj.ProjectBrokerSQLJ:
[java] [ibm][db2][jcc][sqlj]
[java] [ibm][db2][jcc][sqlj] Begin Customization
[java] [ibm][db2][jcc][sqlj] Set qualifier for online checking to SQLID: ADVISOT
[java] [ibm][db2][jcc][sqlj] Loading profile: com\deere\ua0\iso\persistence\brokers\sqlj\ProjectBrokerSQLJ_SJProfile0
[java] [ibm][db2][jcc][sqlj] Customization complete for profile ..\Java Source\com\deere\ua0\iso\persistence\brokers\sqlj\ProjectBrokerSQLJ_SJProfile0.ser
[java] [ibm][db2][jcc][sqlj] Begin Bind
[java] [ibm][db2][jcc][sqlj] Loading profile: com\deere\ua0\iso\persistence\brokers\sqlj\ProjectBrokerSQLJ_SJProfile0
[java] [ibm][db2][jcc][sqlj] User bind options: OWNER ADVISOT QUALIFIER ADVISOT DBPROTOCOL DRDA EXPLAIN NO
[java] [ibm][db2][jcc][sqlj] Driver defaults(user may override): BLOCKING ALL VALIDATE BIND
[java] [ibm][db2][jcc][sqlj] Fixed driver options: DATETIME ISO DYNAMICRULES BIND
[java] [ibm][db2][jcc][sqlj] Binding package PROJEC01 at isolation level UR
[java] [ibm][db2][jcc][sqlj] ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE
[java] [ibm][db2][jcc][sqlj] SQL Error - SQLCODE : -4700, SQLSTATE : 56038
[java] [ibm][db2][jcc][sqlj] ***Bind process has failed!***
[java] [ibm][db2][jcc][sqlj][Throwable@2a32f2a0] com.ibm.db2.jcc.c.SqlException
[java] [ibm][db2][jcc][sqlj][Throwable@2a32f2a0] Message = ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE
[java] [ibm][db2][jcc][sqlj][Throwable@2a32f2a0] Stack trace follows
[java] com.ibm.db2.jcc.c.SqlException: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE
[java] at com.ibm.db2.jcc.c.yc.e(yc.java:1512)
[java] at com.ibm.db2.jcc.c.yc.b(yc.java:1080)
[java] at com.ibm.db2.jcc.a.db.i(db.java:233)
[java] at com.ibm.db2.jcc.a.db.b(db.java:49)
[java] at com.ibm.db2.jcc.a.r.b(r.java:42)
[java] at com.ibm.db2.jcc.a.sb.f(sb.java:138)
[java] at com.ibm.db2.jcc.c.yc.k(yc.java:1077)
[java] at com.ibm.db2.jcc.c.yc.a(yc.java:1796)
[java] at com.ibm.db2.jcc.c.yc.e(yc.java:707)
[java] at com.ibm.db2.jcc.c.yc.execute(yc.java:691)
[java] at com.ibm.db2.jcc.sqlj.Binder.a(Binder.java:557)
[java] at com.ibm.db2.jcc.sqlj.Binder.a(Binder.java:529)
[java] at com.ibm.db2.jcc.sqlj.Binder.bindMain(Binder.java:352)
[java] at com.ibm.db2.jcc.sqlj.Customizer.customizeMain(Customizer.java:819)
[java] at com.ibm.db2.jcc.sqlj.Customizer.main(Customizer.java:275)
[java] BUILD FAILED: file:C:/starteam/Factory_ISO/ISOWEB/SQLJAntScripts/sqlj.customize.xml:19: Java returned: -1

Bind option i am using are: -bindoptions "OWNER ADVISOT QUALIFIER ADVISOT DBPROTOCOL DRDA EXPLAIN NO" -COLLECTION CDV_ISO -PKGVERSION A0ISOAP_LOCAL12 -QUALIFIER ADVISOT

Any idea where exactly i am doing wrong.

Thanks in advance,

Sadanand.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic