wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Using Hibernate with MSAccess Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Using Hibernate with MSAccess" Watch "Using Hibernate with MSAccess" New topic
Author

Using Hibernate with MSAccess

Fabrizio Gianneschi
Ranch Hand

Joined: Nov 29, 2001
Posts: 70
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


Fabrizio Gianneschi<br />SCPJ2, SCWCD, SCBCD
somkiat puisungnoen
Ranch Hand

Joined: Jul 04, 2003
Posts: 1312
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)



SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
Fabrizio Gianneschi
Ranch Hand

Joined: Nov 29, 2001
Posts: 70
Maybe it's only a jdbc driver problem?
Alexandru Popescu
Ranch Hand

Joined: Jul 12, 2004
Posts: 995
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


blog - InfoQ.com
 
Don't get me started about those stupid light bulbs.
 
subject: Using Hibernate with MSAccess