Q

Using JDBC to access a DB2 database

I'm trying to use JDBC to access a DB2 database from within Oracle using Java Stored Procedures. My question is can I use a type 2 (fat) JDBC driver from within the Oracle database? Do I have to use the type 3 (thin) JDBC driver? I have the DB2 client installed on the server with the Oracle database. Thanks!

Each driver version supports different database versions and different JDK versions. Since you didn't give any info about which database version etc, I'll have you take a look at the Oracle JDBC Developer's Guide and Reference on page 2-2 for all the details about what drivers are supported for each version of the database.

For More Information

This was first published in January 2003

Dig deeper on Oracle stored procedures

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close