• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using Hibernate with MSAccess

 
Fabrizio Gianneschi
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maybe it's only a jdbc driver problem?
 
Alexandru Popescu
Ranch Hand
Posts: 995
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic