Using Hibernate with MSAccess

[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.

Thanks

[somkiat puisungnoen]

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.

Thanks

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)

[Fabrizio Gianneschi]

Maybe it's only a jdbc driver problem?

[Alexandru Popescu]

Originally posted by Fabrizio Gianneschi:
Maybe it's only a jdbc driver problem?

I think the problem came from the fact that Access is not a real relational db (my 2c).

./pope