Jdbc Odbc Driver Jar Download

20-05-2021
 |  [RAND-100] - Comments

Driver-->

In our continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server, and Azure SQL Database. The driver is available at no additional charge and provides Java database connectivity from any Java application, application server, or Java-enabled applet. This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs).

Jdbc Odbc Driver Jar Download

The Microsoft JDBC Driver for SQL Server has been tested against major application servers such as IBM WebSphere, and SAP NetWeaver.

Apr 03, 2009  Download the SQL Server JDBC Driver 2.0, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5 and 6.

Getting started

Documentation

  • Download Microsoft JDBC Driver for SQL Server.; 2 minutes to read Contributors. All; In this article Using the JDBC Driver with Maven Central.
  • Download the SQL Server JDBC Driver 2.0, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5 and 6.

Community

Download

Download Microsoft JDBC Driver for SQL Server - has additional information about Maven projects, and more.

Samples

Question & Answer


Question

Which JDBC driver (JCC) version corresponds with each DB2 release and Fix Pack level?

Answer

Jdbc

The IBM Data Server Driver for JDBC and SQLJ package includes two JDBC drivers:

  • db2jcc.jar - This driver is based on the JDBC 3 specification
  • db2jcc4.jar - This driver is based on the JDBC 4 or later specifications

The db2jcc.jar driver is now deprecated. After version 3.72, which is delivered with DB2 Version 11.1 for Linux, UNIX, and Windows Mod 1 Fix Pack 1, db2jcc.jar will include no new features. However, fixes will continue to be delivered.

DB2 Version 11.5
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
v11.5 FP0 (GA)4.26.146,550,443
DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v11.1 FP0 (GA)3.71.223,657,9904.21.293,894,263
v11.1 M1 FP13.72.243,668,6264.22.293,905,812V11.1 M1 FP1
v11.1 M1 FP1 iFix13.72.243,668,6264.22.293,905,812NA
v11.1 M2 FP23.72.303,671,1024.23.423,924,511V11.1 M2 FP2
v11.1 M2 FP2 iFix13.72.303,671,1024.23.423,924,511NA
v11.1 M3 FP33.72.443,813,6414.24.924,234,170
v11.1 M4 FP43.72.523,813,9314.25.134,239,628V11.1 M4 FP4
v11.1 M4 FP4 iFix13.72.523,813,9314.25.13014,239,596V11.1 M4 FP4 iFix 1
DB2 Version 10.5
JDBC 3.0 driver (db2jcc.jar)
JDBC APAR List
Size (bytes)
Size (bytes)
v10.5 FP0 (GA)3.66.463,656,1054.16.533,866,524
v10.5 FP13.66.463,656,1054.16.533,866,524v10.5 FP1
v10.5 FP23.67.263,669,2344.17.283,880,767v10.5 FP2
v10.5 FP33.67.273,670,7074.17.293,882,031v10.5 FP3
v10.5 FP43.68.613,618,7584.18.603,838,131v10.5 FP4
v10.5 FP53.69.243,214,1714.19.263,411,524v10.5 FP5
v10.5 FP63.69.243,214,1714.19.263,411,524v10.5 FP6
v10.5 FP73.69.493,235,1294.19.493,433,725v10.5 FP7
v10.5 FP83.69.663,632,5014.19.663,853,921v10.5 FP8
v10.5 FP93.69.713,636,3864.19.724,022,185v10.5 FP9
v10.5 FP103.69.763,772,5834.19.774,022,817
DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v10.1 FP0 (GA)3.63.12335163754.13.1273714904Not Applicable
v10.1 FP13.64.10436000474.14.1113801427v10.1 FP1
v10.1 FP23.65.7736114234.15.823816252v10.1 FP2
v10.1 FP33.65.9735373654.15.1003743487v10.1 FP3
v10.1 FP43.65.11035393004.15.1133745518v10.1 FP4
v10.1 FP53.65.13135412344.15.1343747996v10.1 FP5
v10.1 FP63.65.13731603034.15.1463347772v10.1 FP6
DB2 Version 9.7
JDBC 3.0 driver (db2jcc.jar)
JDBC APAR List
Size (bytes)
Size (bytes)
v9.7 FP0 (GA)3.57.8231467164.7.853312885
v9.7 FP13.58.8232266204.8.873395609v9.7 FP1
v9.7 FP23.59.8132959504.9.783472296v9.7 FP2
v9.7 FP33.61.6533480304.11.693527921v9.7 FP3
v9.7 FP3a3.61.7533486814.11.773528544v9.7 FP3
v9.7 FP43.62.5634111914.12.553593832v9.7 FP4
v9.7 FP53.63.7535027594.13.803700005v9.7 FP5
v9.7 FP63.64.8235955734.14.883796846v9.7 FP6
v9.7 FP73.64.10636000604.14.1133801439v9.7 FP7
v9.7 FP83.64.11436004634.14.1223801792v9.7 FP8
v9.7 FP93.64.13336085974.14.1373810635v9.7 FP9
v9.7 FP103.64.13336085974.14.1373810635v9.7 FP10
v9.7 FP113.64.14136114424.14.1463813730v9.7 FP11

NOTE: There were no new JDBC APARS for 9.7 Fix Pack 10

DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v9.5 FP0 (GA)3.50.15228337244.0.1002939868
v9.5 FP13.51.9028752474.1.852983662v9.5 FP1
v9.5 FP23.52.9530186244.2.733130687v9.5 FP2
v9.5 FP2a3.52.9530186244.2.733130687v9.5 FP2
v9.5 FP33.53.7030599354.3.853218291v9.5 FP3
v9.5 FP3a3.53.7030599354.3.853218291v9.5 FP3
v9.5 FP3b3.53.7030599354.3.853218291v9.5 FP3
v9.5 FP43.53.9530848724.3.1113242907v9.5 FP4
v9.5 FP53.57.11031489844.7.1123314848v9.5 FP5
v9.5 FP6a3.59.8132959504.9.783472296v9.5 FP6
v9.5 FP73.61.8633500974.11.883530073v9.5 FP7
v9.5 FP83.62.5734115914.12.563594358v9.5 FP8
v9.5 FP93.62.5734115914.12.563594358v9.5 FP9
v9.5 FP103.64.9635979764.14.1033799278v9.5 FP10
DB2 Version 9.1
JDBC 3.0 driver
Driver versionSize (Bytes)
v9.1 FP0 (GA)3.1.571973658
v9.1 FP13.2.491997894v9.1 FP1
v9.1 FP23.3.542011601v9.1 FP2
v9.1 FP33.4.652063122v9.1 FP3
v9.1 FP3a3.4.652063122v9.1 FP3
v9.1 FP43.6.602096050v9.1 FP4
v9.1 FP53.7.732120684v9.1 FP5
v9.1 FP63.8.352125577v9.1 FP6
v9.1 FP73.8.472109253v9.1 FP7
v9.1 FP83.8.622113391v9.1 FP8
v9.1 FP93.8.702113627v9.1 FP9
v9.1 FP103.8.802115146v9.1 FP10
v9.1 FP113.8.852115528v9.1 FP11
v9.1 FP123.8.882115537v9.1 FP12
DB2 Version 8.1
Build Number
Driver versionSize
v8.1 FP0 (GA)s0210231.0.581663346
v8.1 FP1s0301301.2.34798931
v8.1 FP2s0305081.2.117845603
v8.1 FP3s0307281.3.70872718
v8.1 FP4as0401221.5.54900501
v8.1 FP5s0402121.9.231017444
v8.1 FP6s0406162.2.491058458
v8.1 FP6as0409142.2.491058458
v8.1 FP6cOD_140732.2.491058458
v8.1 FP7s0408122.3.631075286
v8.1 FP7bOD_140802.3.631075286
v8.1 FP8s0412212.5.331080551
v8.1 FP8aOD_140812.5.331080551
v8.1 FP9s0504222.6.801124512
v8.1 FP9aOD_140862.6.801124512
v8.1 FP10s0508112.7.581145514
v8.1 FP11s0601202.8.461191149
v8.1 FP12s0604292.9.311201760
v8.1 FP13s0608012.10.271209104
v8.1 FP14s0611082.10.521212904
v8.1 FP15s0707202.10.721216068
v8.1 FP16s0801112.11.241257312
v8.1 FP17s0808132.11.651266347
v8.1 FP17as0808132.11.651266347
v8.1 FP18s0907152.11.941269358


NOTES:
Download the driver you need by visiting the DB2 Fix Packs by Version page or the IBM Data Server Client Packages fix pack page, which contain links to all available Fix Packs
The following command will retrieve the JCC driver version if executed from the command line:

    • java com.ibm.db2.jcc.DB2Jcc -version

Jdbc Odbc Bridge Driver


Or for drivers that are not yet installed:

    • java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version


The 'Build Number' indicates the date the driver was compiled and can be used to determine the drivers age. The build number naming convention is sYYMMDD, where YY is the year, MM is the month, and DD is the day.
JDK/JRE 1.8 support first included with JDBC drivers bundled with v10.5 FP7.

Jdbc.odbc.jdbcodbcdriver Jar Download


For further discussion on this topic, visit this developerWorks forum thread:
https://www.ibm.com/developerworks/community/forums/html/topic?id=657d4182-257b-45dc-8a68-00cb2fa260dc

Internal Use Only

CRM 23311,756,000: JDK 1.8 support starting with v10.5 FP7

v9.5 FP9s1202283.62.5734115914.12.563594358

Related URL

[{'Product':{'code':'SSEPGG','label':'DB2 for Linux- UNIX and Windows'},'Business Unit':{'code':'BU001','label':'Analytics Private Cloud'},'Component':'Programming Interface - JDBC','Platform':[{'code':'PF002','label':'AIX'},{'code':'PF010','label':'HP-UX'},{'code':'PF016','label':'Linux'},{'code':'PF027','label':'Solaris'},{'code':'PF033','label':'Windows'}],'Version':'9.7;9.5;9.1;8.2;10.1;10.5','Edition':'},{'Product':{'code':'SSSNY3','label':'IBM Data Server Client Packages'},'Business Unit':{'code':'BU001','label':'Analytics Private Cloud'},'Component':null,'Platform':[{'code':'PF002','label':'AIX'},{'code':'PF010','label':'HP-UX'},{'code':'PF016','label':'Linux'},{'code':'PF027','label':'Solaris'},{'code':'PF033','label':'Windows'}],'Version':'10.1;9.7;9.5;9.1','Edition':'},{'Product':{'code':'SSEPDU','label':'DB2 Connect'},'Business Unit':{'code':'BU001','label':'Analytics Private Cloud'},'Component':null,'Platform':[{'code':'PF002','label':'AIX'},{'code':'PF010','label':'HP-UX'},{'code':'PF016','label':'Linux'},{'code':'PF027','label':'Solaris'},{'code':'PF033','label':'Windows'}],'Version':'9.7;9.5;9.1;10.1','Edition':'}]

Mysql Jdbc Driver Jar Download

Document Information

Ms Access Jdbc Odbc Driver Jar Download

Modified date:
10 July 2019