Originally posted by Fabrizio Gianneschi: Which Hibernate dialect should I use to connect to a Microsoft Access database? It's for internal testing purpose.
I tried the SQLServer dialect (+ the jdbc-odbc bridge) but it didn't work, due to a unsupported jdbc operation.
Hibernate not support MS Access ...
Hibernate requires JDK 1.2 or later (some people have run successfully under 1.1.8) and has been tested with the following SQL databases:
DB2 7.1, 7.2, 8.1 MySQL 3.23, 4.0 PostgreSQL 7.1.2, 7.2, 7.3, 7.4 Oracle 8i, 9i Sybase 12.5 (JConnect 5.5) Daffodil DBv3.1 Interbase 6.0.1 (Open Source) with Firebird InterClient 2.01 HypersonicSQL 1.61, 1.7.0 Microsoft SQL Server 2000 Mckoi SQL 0.93 Data Replication Tool Progress 9 Pointbase Embedded 4.3 SAP DB 7.3 Hibernate is also thought to be compatible with the latest versions of:
Informix Ingres FrontBase Firebird (1.5 with JayBird 1.01)
Java Developer, Thailand