Supported Databases2

    This page is maintained by the Hibernate user community! See JBoss Enterprise Application Platform supported configurations if you are looking for database management systems and drivers that have been certified by JBoss.

    Please click "Edit this page" and share your experiences!

     

    Hibernate is regularly tested with the following SQL databases, either by Hibernate developers, or in regular QA in the Hibernate product lifecycle:

    • Oracle 11g, 11g RAC
    • DB2 9.7 or above
    • Microsoft SQL Server 2008
    • Sybase ASE 15.5 (jConnect 6.0)
    • MySQL 5.1, 5.5
    • PostgreSQL 8.4, 9.1

     

    Please go to the CI job and find the latest DB set we're testing hibernate with

     

    Hibernate has also been tested with and is believed to be compatible with current versions of:

    • Apache Derby
    • HP NonStop SQL/MX 2.0 (requires Dialect from HP)
    • Firebird (1.5 with JayBird 1.01 tested)
    • FrontBase
    • Informix
    • Ingres
    • Interbase (6.0.1 tested)
    • Mckoi SQL
    • NuoDB 1.2, 2.0, or above
    • Pointbase Embedded (4.3 tested)
    • Progress 9
    • Microsoft Access version from 95, 97, 2000, XP, 2002, 2003, 2007, to 2010 (requires Dialect from HXTT)
    • Corel Paradox version from 3.0, 3.5, 4.x, 5.x, 7.x to 11.x (requires Dialect from HXTT)
    • flat text , CSV file, TSV file, fixed-length, and variable-length binary file (requires Dialect from HXTT)
    • Xbase database (dbase, Visual DBASE, SIx Driver, SoftC, Codebase, Clipper, Foxbase, Foxpro, VFP(3.0,5.0,7.0,8.0,9.0, 10), xHarbour, Halcyon, Apollo, Goldmine, and BDE) (requires Dialect from HXTT)
    • Microsoft Excel version from 95, 97, 98, 2000, 2001, 2002, 2003, 2004, 2007, to 2010 (requires Dialect from HXTT)
    • Cobol data files for Open Cobol MVS, Fujitsu NetCOBOL, MicroFocus Cobol, AcuCobol (requires Dialect from HXTT)
    • XML 1.0 and XML 1.1 document(requires Dialect from HXTT)
    • Sybase ASE 15.7 (jConnect 7.0)

     

     

    It is highly likely that most features of Hibernate (i.e. everything except DDL schema generation) will work perfectly with many other relational databases. You may easily add a new SQL dialect by extending the existing dialects. Keep in mind that some features of the query language are not supported for databases which do not have subqueries.


     

    DB2

    License:Commercial
    URL:http://www.ibm.com/db2
    Issues:On iSeries use V5R1 or later, which allows key mappings containing file.name. Remove schema reference from mappings for *LIBL on iSeries.
    When using type 4 driver with binary columns, set deferPrepares = false. see http://www-1.ibm.com/support/docview.wss?rs=457&context=SSBRLP&dc=DB520&uid=swg21216635&loc=en_US&cs=UTF-8&lang=en&rss=ct457websphere

     

    Firebird

    License:Open Source based on the commercial Interbase
    URL:http://www.firebirdsql.org/
    Issues:Offers many ANSI SQL-92 features, runs on Linux, Windows, and a variety of Unix platforms. Excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981. JDBC type 4 driver with excellent support. DDL statements cannot be executed when there is more than one open JDBC connection. PreparedStatement caching is impossible! Firebird InterClient 2.01 is strongly recommended in preference to other versions of Interbase Interclient. Its also worth trying the latest pure Java "JayBird" driver (http://www.ibphoenix.com).

     

    FrontBase

    License:n/a
    URL:http://www.frontbase.com/cgi-bin/WebObjects/FrontBase
    Issues:n/a

     

    HP NonStop SQL/MX

    License:Commercial
    URL:http://h20223.www2.hp.com/nonstopcomputing/cache/81318-0-0-225-121.aspx
    Issues:Release 2.0 of SQL/MX runs the ant eg script successfully An extended version of the Hibernate .jar must be created with an extended properties file, available from Sanjib.Guhathakurta@hp.com.

     

    HypersonicSQL

    License:Open Source
    URL:http://hsqldb.sourceforge.net/
    Issues:Pure Java, no subselects, has issues with case-sensitivity and missing quotes in generated SQL. Only integers can be used for the "native" generator in current versions (this is fixed in HSQL CVS).

     

    Informix

    License:Commercial
    URL:http://www-306.ibm.com/software/data/informix/
    Issues:

     

    Ingres

    License:Open Source
    URL:http://www.ingres.com
    Issues:see http://www.hibernate.org/382.html for list of current issues.

     

    Interbase

    License:n/a
    URL:http://www.borland.com/interbase/
    Issues:n/a

     

    Microsoft SQL Server

    License:Commercial
    URL:http://www.microsoft.com/sqlserver/
    Issues:jTDS, open source, LGPL: also used with Sybase.  May also work with SQL Server 6.5 and 7.

     

    MySQL

    License:Open Source
    URL:http://www.mysql.com/
    Issues:No subselects in "current" versions (subselect support is currently in beta). No transactions with MyISAM tables, only with InnoDB tables (consider changing the default for your databases). The Caucho JDBC driver does not work.

    NuoDB

    License:Commercial
    URL:http://www.nuodb.com/
    URL:http://doc.nuodb.com/display/doc/NuoDB+Hibernate+Driver
    Issues:Please pull the latest drivers from Maven Central. NuoDB only supports forward iterating cursors.

     

    Oracle

    License:Commercial
    URL:http://technet.oracle.com/
    URL:http://www.oracle.com/technology/software/products/timesten/index.html
    Issues:Do not use JDBC drivers before version 9.2.0.3 for Oracle 9. These drivers have a round-off bug which strips off any number with decimals (e.g. from 666.67 to 666.0). Oracle JDBC drivers have extremely bad support for large text or binary columns. At least some versions of the Oracle 9i driver handle JDBC timestamps extremely badly - do not use timestamps for optimistic locking, use version numbers.

     

    Pointbase

    License:n/a
    URL:http://www.pointbase.com/
    Issues:n/a

     

    PostgreSQL

    License:Open Source
    URL:http://www.postgresql.org
    Issues:Problems with the use of index for the 'bigint' type, details here. Support for user-defined data types (UDT), see here.

     

    SAP DB

    License:Open Source
    URL:http://www.sapdb.org
    Issues:n/a

     

    Sybase

    License:Open Source
    URL:http://www.sybase.com/
    Issues:jTDS, open source, LGPL: also used with Microsoft SQL Server.

     

    MS Access, Corel Paradox, CSV, plain text, Xbase database, MS Excel, Cobol data, XML document

    License:Commercial
    URL:http://www.hxtt.com/hibernate.html
    Issues:n/a

     

    InterSystems Cache'

    License:Commercial
    URL:http://www.intersystems.com
    Issues:version 2007.1 is certified; use version 2007.1 or later; please contact InterSystems for dialects for earlier versions of Cache'.