473,583 Members | 3,114 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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\SQLLI B\bnd>java -cp "D:\program files\ibm\sqlli b
\java\db2jcc.ja r" 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\I BM
\SQLLIB\java\db 2java.zip;D:\PR OGRA~1\IBM\SQLL IB\java\db2jcc. jar;D:
\PROGRA~1\IBM\S QLLIB\java\sqlj .zip;D:\PROGRA~ 1\IBM\SQLLIB\ja va
\db2jcc_license _cisuz.jar;D:\P ROGRA~1\IBM\SQL LIB\java
\db2jcc_license _cu.jar;D:\PROG RA~1\IBM\SQLLIB \bin;D:\PROGRA~ 1\IBM
\SQLLIB\java\co mmon.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

Feb 6 '07 #1
1 4550
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\sqlli b\java\db2jcc.j ar;D:\program files
\ibm\sqllib\jav a\db2jcc_licens e_cu.jar" com.ibm.db2.jcc .DB2Binder -url
xxx -user xxx -
password xxx -s xxxx

Feb 7 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
18295
by: xixi | last post by:
hi, we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. i have this problem happened sometimes when try to execute a query and failed. com.ibm.db2.jcc.a.DisconnectException: Execution failed due to a distribution protocol error that caused deallocation of the
0
2149
by: xixi | last post by:
we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. such error generated , please help me understand this , thanks 2004-01-12-14.09.02.400000 Instance:DB2 Node:000 PID:1788(db2syscs.exe) TID:980 Appid:none DRDA Application Server sqljsCleanup Probe:60 DIA0001E An internal error occurred. Report the...
0
1578
by: xixi | last post by:
we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. i use db2dart analyze one database. one of the tablespace (database managed) has this error, please help me understand this. thanks Traversing extent map for: OTR ID: 17 Parent object ID = 17 pool ID = 4
4
28334
by: xixi | last post by:
hello, our application is running on db2 udb v8.1 win64 bit machine, using db2jcc.jar for jdbc driver. i have this error happen, DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031, before it has same error code but looking for SYSHH203 instead of SYSLH203 , so i don't have idea how this happend, cause...
1
4288
by: rafikki3 | last post by:
I have a java web application that is using the db2jcc driver to get a connection to a DB2 database that is located on an RS 6000 server. The here is a portion of the code that is giving me a problem. rs is an ResultSet object instantiated by the following... detailStmt = vmCon.prepareStatement(detailSelect); detailResults =...
0
4788
by: JSantora | last post by:
Essentially, InsertAT is broken! For the past couple of hours, I've been getting this "Parameter name: '-2147483550' is not a valid value for 'index'." error. Apparently, its caused by having manually inserted a row in the table bound to the Combo box. The InsertAt Method of adding a row just does not work. Hope this helps anyone with...
1
6192
by: Giovanni Tirloni | last post by:
Hello, I'm trying to connect to DB2 Express-C for Linux using the JDBC Universal Driver and I get the error below. I thought it was my code then I installed Websphere Community Edition 1.0.0.1 and I'm now using the IBM JDK 1.4.2. I wasn't planning to work directly with Websphere but just wanted to try a different thing and it gives me...
1
2203
by: chihfei.lai | last post by:
Hi all, As title!! My development environment is db2 v8.1. But my production environment is db2 v7.2. Can I use db2jcc.jar to connect to db2 v7.2? Thanks a lot. Chih-Fei.
2
3530
by: Zunil | last post by:
Hi All, We are testing one of our component with JDBC + DB2 using db2jcc driver. We afced a strange issue. Scenario is like this. 1. We insert 1 record to a table having IDENTITY column as the primary key and retrieve the newly inserted identity value using getGeneratedKeys() API of JDBC 3.0. It works fine 2. Immediate after that we insert...
0
7896
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7827
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8184
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7936
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6581
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3845
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2334
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1434
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1158
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.