is it possible to import a MS access database (.mdb) in a seam project using JBoss tools within Eclipse (Ganymede)? Starting a new seam project, I cannot see any field which uses ms access as database type. Any answer is appreciated.
A:
Java programs generally talk to databases through JDBC drivers. To my knowledge there is no JDBC driver for Access MDB files. You can use the JDBC-ODBC bridge to create a connection to the Access database with a little help from the Access ODBC driver. How to set up this construction is explained here
You have to create a database connection in the JBoss application server that uses that connection, how this is done can be found here.
fvu
2009-10-01 00:22:26
As far i've seen no free jdbc driver for Access indeed. I tried using the bridge JDBC-ODBC but it didn't helped, because of hibernate issues. So the solution was to export the db to another dbms like MySQL and let JBoss tools generate entities from it. It didn't required any effort, above all if, as in this case, the MDB database was quite ..relational-less.Thanks anyway
2009-10-01 23:15:22