cannot load jdbc driver

sea

I have DB2 UDB Workgroup version 7.2 -- the JDBC-ODBC bridge loads
perfectly fine but when I try to use JDBC I get an error, copying and
pasting below. I added db2java.zip and db2jdbc.dll to both the
classpath and path variables, still no luck. Anyone have any ideas
please? Thank you very much!

java.lang.Class NotFoundExcepti on: COM.ibm.db2.jdb c.app.DB2Driver

at java.net.URLCla ssLoader$1.run( URLClassLoader. java:200)

at java.security.A ccessController .doPrivileged(N ative Method)

at java.net.URLCla ssLoader.findCl ass(URLClassLoa der.java:188)

at java.lang.Class Loader.loadClas s(ClassLoader.j ava:297)

at sun.misc.Launch er$AppClassLoad er.loadClass(La uncher.java:286 )

at java.lang.Class Loader.loadClas s(ClassLoader.j ava:253)

at java.lang.Class Loader.loadClas sInternal(Class Loader.java:313 )

at java.lang.Class .forName0(Nativ e Method)

at java.lang.Class .forName(Class. java:120)

at db2jdbc.DB2Appl .<clinit>(DB2Ap pl.java:41)

java.sql.SQLExc eption: No suitable driver

at java.sql.Driver Manager.getConn ection(DriverMa nager.java:537)

at java.sql.Driver Manager.getConn ection(DriverMa nager.java:177)

at db2jdbc.DB2Appl .main(DB2Appl.j ava:65)

Nov 12 '05 #1

Subscribe Reply

11695

Rhino

Which Java SDK are you using? (The Application Building Guide tells you how
to use the batch jobs usejdbc1 and usejdbc2 to control the SDK; DB2 V7.2 has
two built-in SDKs, Java 1.1.8 and Java 1.2.2. In addition, you can install
additional SDKs of your own; although unsupported, people do it.)

You might get better results if you put a copy of db2java.zip in your JRE
extensions directory, assuming you can find it ;-) I have multiple JREs on
my machine and figuring out which one is being used isn't always easy. If
you can do it though, your problem may go away. For what it's worth, I
haven't found it necessary to put copies of db2jdbc.dll anywhere to make
programs work.

Rhino

"sea" <se*****@hotmai l.com> wrote in message
news:f8******** *************** ***@posting.goo gle.com...

I have DB2 UDB Workgroup version 7.2 -- the JDBC-ODBC bridge loads
perfectly fine but when I try to use JDBC I get an error, copying and
pasting below. I added db2java.zip and db2jdbc.dll to both the
classpath and path variables, still no luck. Anyone have any ideas
please? Thank you very much!

java.lang.Class NotFoundExcepti on: COM.ibm.db2.jdb c.app.DB2Driver

at java.net.URLCla ssLoader$1.run( URLClassLoader. java:200)

at java.security.A ccessController .doPrivileged(N ative Method)

at java.net.URLCla ssLoader.findCl ass(URLClassLoa der.java:188)

at java.lang.Class Loader.loadClas s(ClassLoader.j ava:297)

at sun.misc.Launch er$AppClassLoad er.loadClass(La uncher.java:286 )

at java.lang.Class Loader.loadClas s(ClassLoader.j ava:253)

at java.lang.Class Loader.loadClas sInternal(Class Loader.java:313 )

at java.lang.Class .forName0(Nativ e Method)

at java.lang.Class .forName(Class. java:120)

at db2jdbc.DB2Appl .<clinit>(DB2Ap pl.java:41)

java.sql.SQLExc eption: No suitable driver

at java.sql.Driver Manager.getConn ection(DriverMa nager.java:537)

at java.sql.Driver Manager.getConn ection(DriverMa nager.java:177)

at db2jdbc.DB2Appl .main(DB2Appl.j ava:65)

Nov 12 '05 #2

Rhino

I have DB2 UDB Workgroup version 7.2 -- the JDBC-ODBC bridge loads
perfectly fine but when I try to use JDBC I get an error, copying and
pasting below. I added db2java.zip and db2jdbc.dll to both the
classpath and path variables, still no luck. Anyone have any ideas
please? Thank you very much!

java.lang.Class NotFoundExcepti on: COM.ibm.db2.jdb c.app.DB2Driver

at java.net.URLCla ssLoader$1.run( URLClassLoader. java:200)

at java.security.A ccessController .doPrivileged(N ative Method)

at java.net.URLCla ssLoader.findCl ass(URLClassLoa der.java:188)

at java.lang.Class Loader.loadClas s(ClassLoader.j ava:297)

at sun.misc.Launch er$AppClassLoad er.loadClass(La uncher.java:286 )

at java.lang.Class Loader.loadClas s(ClassLoader.j ava:253)

at java.lang.Class Loader.loadClas sInternal(Class Loader.java:313 )

at java.lang.Class .forName0(Nativ e Method)

at java.lang.Class .forName(Class. java:120)

at db2jdbc.DB2Appl .<clinit>(DB2Ap pl.java:41)

java.sql.SQLExc eption: No suitable driver

at java.sql.Driver Manager.getConn ection(DriverMa nager.java:537)

at java.sql.Driver Manager.getConn ection(DriverMa nager.java:177)

at db2jdbc.DB2Appl .main(DB2Appl.j ava:65)

Nov 12 '05 #3

Similar topics

4890

Cant LOAD the Oracle Driver Error

by: sufia | last post by:

hi, Everytime i try to run the following code (which is a part of my servlet): try { Class.forName( "oracle.jdbc.driver.OracleDriver" ); DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); }

Java

17885

Cannot connect with OCI driver and Oracle 9i (9.2)

by: David | last post by:

Hello all, I have been trying to use the OCI driver to connect to Oracle 9i, but have been getting the following error: java.sql.SQLException: Closed Connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2364) at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:480)

Oracle Database

2858

JDBC & LOAD DATA LOCAL FILE

by: JohnLH | last post by:

Hi, I am having an issue with the LOAD DATA LOCAL FILE command on the latest 3.0.9 JDBC Driver. The command works on Windows, but doesn't seem to work on OSX and Linux. The error that I get on Linux and OSX is ... Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FILE

MySQL Database

441

cannot load jdbc driver

by: sea | last post by:

DB2 Database

3083

DB2 v 8.1 universal JDBC Driver Weird behavior in WSAD 5.1.x and WAS 5.0.2

by: Bing | last post by:

Hi, I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x environment and WebSphere application Server 5.0.2 on Windows 2000 machines. I configured a connection pool data source using type 4 for a local test environment in WSAD 5.1.x, and a connection pool data source on the WebSphere Server too. Both data sources are accessing the same database.

DB2 Database

3823

DB2 for z/OS Visual Explain: Fail to load JDBC driver

by: bruce_milner | last post by:

I am having a problem using DB2 for z/OS Visual Explain V8 for Windows. The error message is: Fail to load JDBC driver COM.ibm.db2.jdbc.app.DB2Driver I have un-installed/re-installed DB Connect Client and Visual Explain client several times. I have checked our paths, and searched IBM's site and Google for more information. The JDBC driver above is on all the PCs in the correct .ZIP file.

DB2 Database

13389

Cannot connect to db2 using jdbc

by: r_stringer66 | last post by:

Hi, I am trying to connect to a db2 database via a jdbc application and this is the following error I get: Exception : CLI0615E Error receiving from socket, server is not responding. SQLSTATE=08S01 Below is the following code I am using. I did not specify the port number but even when I try specify it I get the same error.

DB2 Database

10899

How to load a cursor from a stored procedure in DB2

by: technocrat | last post by:

Hi, I am trying to declare and cursor and thn load from that cursor into another table. Since I have almost 4 million records, I cant do it without the cursor which reduces the time by almost 1/10th. I tried to create a sql statement for "load from cursor cur insert into table name" using java stored procedure, but this isnt recognised by sql since load isnt a sql keyword. So whats the solution to this. I have to do it programatically...

DB2 Database

8803

Cannot create JDBC driver of class 'COM.ibm.db2.jdbc.app.DB2Driver'

by: rpm45tech | last post by:

Hi everyone. I'm deveolping in Java with DB2 running on Win XP and everything was working ok but then I installed Vista Ultimate and the application stopped working. This is the exception showed: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'COM.ibm.db2.jdbc.app.DB2Driver' for connect URL...

Java

9423

Changing the language in Windows 10

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10214

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10048

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9996

The easy way to turn off automatic updates for Windows 10/11

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 most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7410

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6674

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5304

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5447

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General