Search code examples
javaeclipsems-accessjpaucanaccess

"Generate entities from table" (MS Access) in Eclipse via UCanAccess

I created a JPA project to use the tool Generate entities from Table to create an Entitie from a big big! MS Access Database Table.

I'm trying to use UCanAccess as JDBC Driver: connection profile configuration 1 connection profile configuration 2

But when I test the connection I get this error: test connection error

Somebody knows what can I try to make it works?

Is there any other good tool to generate entities from table?

I have created a simple class to test UCanAccess and my database and everything works right.

Solution

  • It looks like there is something bad in your JDBC URL, e.g.:

    jdbc:ucanaccess://C:/Users/Public/Database1.accdb;showSchema=true

    Notice that the IDE can't know how the JDBC URL should be composed.