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.
