473,545 Members | 2,009 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

IBM DB2 Universal driver (JCC) not found

2 New Member
Hi ,

I am trying to connect to my database through the development centre.
In the database connection wizard i m using the followin information

Driver : IBM DB2 universal type 2

Database name

location : jdbc:db2:databa sename

Driver Class: com.ibm.db2.jcc .DB2Driver


When i try to connect to the database it shows an error message stating that

connection to database failed
IBM DB2 universal driver (JCC) not found.


Please suggest some solution over this.
Have i missed something in the db2 installation ?



Thanks&Regards
Abhijeet
Feb 8 '06 #1
4 11019
kim_jin
3 New Member
I assume you did not set the environment variable correctly.Pls check the "CLASSPATH" variable on Windows and run you java application with -cp variable on Unix.
For example:
java -cp {DB2HOME}/sqllib/java/db2jcc.jar JavaClassName
Try it.
Feb 9 '06 #2
dvineel
1 New Member
I assume you did not set the environment variable correctly.Pls check the "CLASSPATH" variable on Windows and run you java application with -cp variable on Unix.
For example:
java -cp {DB2HOME}/sqllib/java/db2jcc.jar JavaClassName
Try it.
what should be there in the java class path and class name.
is it the same you have given above or it is system dependent.
Oct 3 '08 #3
sakthikumaran
16 New Member
hi

i can't understand what is 'Development centre',.... but i'm using eclipse in that i simple include(import) the mentioned file(mentioned in post #2) to my project... after that it won't tell an error message
(before that me too had the same problem in eclipse.)
Oct 4 '08 #4
hbwilly54
1 New Member
Ok if you are using eclipse for to excute Jython there are a few things to need to do.

Right click on your project and select properties in the list
Then click on PyDev - PythonPath
in the box for External Source Folders
Add db2jcc.jar and
Add db2cc_license_c r.jar filles
and click ok.
Jun 19 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

6
2658
by: Janick | last post by:
Is there any possibility to override the application name shown using "db2 list applications" in the new Universal Driver. The default "db2jcchttp8443..." is not very meaningful. Regards - Janick Bernet, SwissASP AG
0
2927
by: aj | last post by:
DB2 v8 FP5 Red Hat AS/EL 2.1 I am specifying properties for a DB2 Universal JDBC Driver connection in my Java/JDBC app by creating a java.util.Properties object and passing it along in my connect() call.. For example, I use the "currentSchema" property to set the default schema, which is apparently equivalent to a "SET SCHEMA" command...
0
1062
by: Joe | last post by:
Hi, If I want to connect to a datasource on z/OS using the Universal Driver and use 2PC, do I have to craft the DB2 address url the Type 2 way? Can I use type 4 connectivity? Thx Joe
2
1628
by: klh | last post by:
I am working with my developer group to switch from the type 2 to the type 4 (Universal Driver). Our set up is: Host Data Base - DB2 z/os v7.1 (mainframe). Client - DB2 Admin Client V8 FP8 (Windows 2003 advanced server) The applications are Java based. They are reporting that when a timestamp column ends with a zero, it gets truncated...
1
13196
by: sbanil | last post by:
We have a JAVA application which uses following Database product name : DB2 Database product version : DSN07012 JDBC driver name : IBM DB2 JDBC Universal Driver Architecture JDBC driver version : 2.3.63 APplication Server:Websphere When the prepared statement cache for the JDBC driver is set to > 0 following query fails on DB2 OS/390...
5
3301
by: eholz1 | last post by:
Hello Newsgroup, I have "installed" pdo using "pecl install pdo" (it intalled version 1.0.3), I have added the line "extension=pdo.so" to my php.ini file, but when I try to use the PDO db connect string "$db = new PDO('msql:server=dbserver;dbname=menagerie',$dbuser,$dbpass); " i get a "driver not found" error.
0
1427
by: sara1231 | last post by:
Hi, Unable to connect to DB2 UDB v7.2 using JDBC Universal driver 4. com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSSH200 Please help as this is urgent. Thanks
4
3625
by: Kirk Wolf | last post by:
I apologize if this is available in a FAQ somewhere. My question is this: The DB2 Universal Driver jars are shipped with DB2 for z/OS (db2jcc.jar and db2jcc_license_cisuz.jar). If a developer wants to use these on his workstation (for type-4 connections), does the license allow you to download them and use them? I assume not.
0
1154
by: milivoj.fradelic | last post by:
Hi! I have following actions: for each file do begin transaction parse file to temp table insert into table from temp table --insert into main select * from temp commit
0
7409
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
7664
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. ...
0
7921
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7437
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
7771
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5982
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...
1
5343
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3446
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1023
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.