Unix Technical Forum

error try to use db2jcc do binding

This is a discussion on error try to use db2jcc do binding within the DB2 forums, part of the Database Server Software category; --> Hi, we are using db2 ESE v8.2.3 on windows, i try to use command window to do binding D:\Program ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 12:40 PM
db2group88
 
Posts: n/a
Default error try to use db2jcc do binding

Hi,

we are using db2 ESE v8.2.3 on windows, i try to use command window to
do binding

D:\Program Files\IBM\SQLLIB\bnd>java -cp "D:\program files\ibm\sqllib
\java\db2jcc.jar" com.ibm.db2.jcc.DB2Binder -url xxx -user xxx -
password xxx -s xxxx
DB2Binder stopped: Failure to create connection for binding
SQL code: -99999
SQL state: null
Message: The version of the IBM Universal JDBC driver in use is not
licensed for connectivity to QDB2/NT databases. To connect to this
DB2 server, please obtain a licensed copy of the IBM DB2 Unive
rsal Driver for JDBC and SQLJ. An appropriate license file
db2jcc_license_*.jar for this target platform must be installed to the
application classpath. Connectivity to QDB2/NT databases is enabled
by any of the following license files: { db2jcc_license_cu.jar,
db2jcc_license_cisuz.jar }

but by checking classpath, i do have those jars .;D:\PROGRA~1\IBM
\SQLLIB\java\db2java.zip;D:\PROGRA~1\IBM\SQLLIB\ja va\db2jcc.jar;D:
\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;D:\PROGRA~1\IBM \SQLLIB\java
\db2jcc_license_cisuz.jar;D:\PROGRA~1\IBM\SQLLIB\j ava
\db2jcc_license_cu.jar;D:\PROGRA~1\IBM\SQLLIB\bin; D:\PROGRA~1\IBM
\SQLLIB\java\common.jar

also we are using licensing copy of db2, the solution i am doing is
use original db2jcc from long time ago. Could somebody help me out
what is the best way? thanks

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 12:40 PM
Otto Carl Marte
 
Posts: n/a
Default Re: error try to use db2jcc do binding

You need to add the db2 license jar (db2jcc_license_cu.jar) to your
classpath.

This would do the trick:
java -cp "D:\program files\ibm\sqllib\java\db2jcc.jar;D:\program files
\ibm\sqllib\java\db2jcc_license_cu.jar" com.ibm.db2.jcc.DB2Binder -url
xxx -user xxx -
password xxx -s xxxx

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:29 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com