Hi All,

We are developing a J2EE application (with Websphere, Spring, Hibernate, etc..) which connects to a Microsoft Access Database (Vendor required Access db :-)) to get some data.

We need help to figure out way of connecting Websphere with MS-Access data source and Hibernate with MS-Access.

following hibernate link http://www.hibernate.org/80.html mention that hibernate support HXTT commercial product for ACCESS. However it is a commercial product (JDBC driver). Is there any other open source support for MS-access in hibernate.

If we use HXTT "access dialact" and use some other third party JDBC driver, is it going to be a issue. In other words, just dialact implementation bound to a JDBC driver?

Thanks,
Nalaka

One more question in the same topic.

Can I use JDBC-ODBC driver to connect to MS-Access database and still use Hibernate?

Does dialacts bound to specifc drivers?

Thanks in advance,
Nalaka

Hello, Nalaka:

I have exactly the same requirements as you did: WebSphere, Spring, Hibernate, and get some data from Microsoft Access database. We cannot use HXTT driver because our J2EE application shall run on classified network (Federal government) and we cannot use a software (on classified network) that is developed or sold by a non-U.S. company.

Did you figure out your problem (without HXTT driver)? Thanks.

Asif