How to enter MS access JDBC driver in POM?

Question

I have to connect to MS Access database for the back end transactions. So i need to add the jdbc connector for this. I am using Maven as the build tool, So so get the MS Access dependency from Maven repository what should I be entering the POM.xml? I tried on google search but could find relevent help.

Thanks.

Have you looked at: http://stackoverflow.com/questions/9863482/jdbc-with-ms-access ? — condit, May 30 '13 at 21:05
How exactly do you connect to MS Access? And which driver are you using? — , May 31 '13 at 15:26

score 4 · Answer 1 · edited May 23 '17 at 11:50

Java provides a built in type 1 JDBC driver for ODBC data sources so you shouldn't need to add a Maven dependency for this. See: How to connect java to Ms Access 2010?

Alternatively you could use the Jackcess library by adding this dependency:

<dependency>
  <groupId>com.healthmarketscience.jackcess</groupId>
  <artifactId>jackcess</artifactId>
  <version>1.2.12</version>
  <type>jar</type>
</dependency>

How to enter MS access JDBC driver in POM?

1 Answers1