IIRC, all available DB2 JDBC drivers should be already in the /java or /jdbc folder of the DB2 installation folder. Ask your DB admin to have a copy of them if you don't have direct access to the machine where DB2. DB2 UDB provides for JDBC connectivity through a number of Java classes and interfaces that implement the JDBC specification. The implementation is known as a JDBC driver. DB2 currently offers JDBC drivers known as legacy/CLI drivers and the universal JDBC driver. DB2 Connect also installs the JDBC driver as well as the license jar file for connecting java applications to DB2 on “i” and “z” systems as well. That license jar file can also be downloaded from your Passport Advantage site too.
Am evaluating options other than either Sybase's DirectConnect or IBM's DB2Connect to connect to DB2 running on z/OS. From what our findings have shown us so far, we need to connect and also do format translation from ASCII to EBCDIC and vice versa. We are currently seeking an open source (not necessarily community edition) to help us achieve this. Any thoughts will always help.
1 Answer
The DB2 Data Server Client allows you to connect to a DB2 database on z/OS using JDBC without requiring DB2 Connect in between. However, you will still need a DB2 Connect license, contained in the db2jcc_license_cisuz.jar file that comes with any DB2 Connect product.
mustacciomustaccio
Not the answer you're looking for? Browse other questions tagged jdbcdb2asciitranslationebcdic or ask your own question.
Ibm Db2 Jdbc Driver
Home > Articles > Programming > Java
␡- Something to Hook Up to
Like this article? We recommend Db2 Udb Jdbc Driver For Mac
Like this article? We recommend
Like this article? We recommend
The relational database serves as a location to persist data for many applications. Java programmers commonly use JDBC to interact with backend databases. This article shows you how to set up your environment to write Java programs that interact with IBM DB2 Universal Database Version 8. You will notice that there are different approaches to connecting to DB2 that require different drivers, software, and syntax. In this article, we'll shed light on the subject so you can evaluate which approach is appropriate for you getting your Java program 'hooked up' to DB2.
DB2 Universal Database Version 8.1 fully supports the JDBC v2.1 specification. It also supports portions of the JDBC 3.0 specification. Usage on the new JDBC 3.0 features of the driver requires a JDK 1.4 environment.
DB2 Version 8 provides support for four different JDBC driver architectures, named Type 1, Type 2, Type 3, and Type 4. In this article, we'll focus on the Type 2 and Type 4 drivers because they are the drivers that you will most likely use to enable your Java applications to talk to DB2.
Something to Hook Up to
Because we plan to show how to use Java to interact with a database, we need a database to play with. Let's dedicate some time to create one here. Suppose that you have a user on your DB2 server with the name of db2admin and a password of db2admin. Let's create a small database on our database server, associating a name to a phone number. We'll call our database phonedb. Using the DB2 command line processor, enter the following command:
Db2 Drivers Download
Next, we connect to the database:
We create our table using this command:
Finally, let's insert a couple of records:
Related Resources
- Book $31.99
- eBook (Watermarked) $25.59
Jdbc Connection
- eBook (Watermarked) $57.59
Comments are closed.