This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB2 SQLJ binding error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 SQLJ binding error" Watch "DB2 SQLJ binding error" New topic
Author

DB2 SQLJ binding error

Sadanand Ghadge
Greenhorn

Joined: Jul 11, 2006
Posts: 1
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB2 SQLJ binding error
 
Similar Threads
Stored Procedure CachedRowSet
problem in connecting to DB2 using hibernate
CachedRowSet - Stored Procedure
hibernate
Help db2 JDBC driver error--[jcc][t4][1065][12306][3.53.95] Caught java.io.CharConversionException