Jackcess / Discussion / Help: java.lang.ExceptionInInitializerError

Paul Malm - 2020-03-30

Hi,
I've tried to connect to a simple acess database but I'm getting this exception:

Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.flyginfo.se.main.accessDbMain$3.mouseReleased(accessDbMain.java:120)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:290)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.lang.RuntimeException: org.hsqldb.jdbc.JDBCDriver
at net.ucanaccess.jdbc.UcanaccessDriver.<clinit>(UcanaccessDriver.java:52)
... 35 more</clinit>

I'm using Eclipse.
I'm trying to connect to a ms acess database like this:
try {
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
Customer Database.accdb;memory=false");
Connection conn = DriverManager.getConnection("jdbc:ucanaccess://c:/Temp/PCResale.accdb;memory=false");
System.out.println("Connection established!");
} catch (SQLException | ClassNotFoundException e1) {
e1.printStackTrace();
}

This is my pom file:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://maven.apache.org/POM/4.0.0 <a href=" http:="" maven.apache.org="" xsd="" maven-4.0.0.xsd"="">http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelversion>4.0.0</modelversion></project>

<groupid>org.test.se</groupid>
<artifactid>org.test.se</artifactid>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>

<name>org.test.se</name>
<url>http://maven.apache.org</url>

<properties>
<project.build.sourceencoding>UTF-8</project.build.sourceencoding>
</properties>

<dependencies>
<dependency>
<groupid>org.hsqldb</groupid>
<artifactid>hsqldb</artifactid>
<version>2.5.0</version>
<scope>test</scope>
</dependency>
<dependency>
<groupid>com.healthmarketscience.jackcess</groupid>
<artifactid>jackcess</artifactid>
<version>3.0.1</version>
</dependency>
<dependency>
<groupid>com.healthmarketscience.jackcess</groupid>
<artifactid>jackcess-encrypt</artifactid>
<version>3.0.0</version>
</dependency>
<dependency>
<groupid>net.sf.ucanaccess</groupid>
<artifactid>ucanaccess</artifactid>
<version>5.0.0</version>
</dependency>
<dependency>
<groupid>org.hamcrest</groupid>
<artifactid>hamcrest-core</artifactid>
<version>1.3</version>
<scope>test</scope>
</dependency>
<dependency>
<groupid>commons-codec</groupid>
<artifactid>commons-codec</artifactid>
<version>1.10</version>
</dependency>
<dependency>
<groupid>org.apache.commons</groupid>
<artifactid>commons-collections4</artifactid>
<version>4.2</version>
</dependency>
<dependency>
<groupid>org.apache.commons</groupid>
<artifactid>commons-lang3</artifactid>
<version>3.9</version>
</dependency>
<dependency>
<groupid>org.apache.poi</groupid>
<artifactid>poi</artifactid>
<version>4.0.0</version>
</dependency>
<dependency>
<groupid>commons-logging</groupid>
<artifactid>commons-logging</artifactid>
<version>1.2</version>
</dependency>
<dependency>
<groupid>junit</groupid>
<artifactid>junit</artifactid>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupid>org.eclipse.swt</groupid>
<artifactid>org.eclipse.swt.win32.win32.x86_64</artifactid>
<version>4.3</version>
</dependency>
</dependencies>

Java compiler 1.8
This is about all I've done, Could someone please tell me what I've missed?
Kind regards,
Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Paul Malm - 2020-03-30
  
  Sorry, it works now when removing <scope> from copy paste of dependencies.</scope>
  
  Från: Paul Malm [mailto:palle@users.sourceforge.net]
  Skickat: den 30 mars 2020 09:29
  Till: [jackcess:discussion]
  Ämne: [jackcess:discussion] java.lang.ExceptionInInitializerError
  
  Hi,
  I've tried to connect to a simple acess database but I'm getting this exception:
  
  Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError
  at java.lang.Class.forName0(Native Method)
  at java.lang.Class.forName(Class.java:264)
  at org.flyginfo.se.main.accessDbMain$3.mouseReleased(accessDbMain.java:120)
  at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:290)
  at java.awt.Component.processMouseEvent(Component.java:6539)
  at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  at java.awt.Component.processEvent(Component.java:6304)
  at java.awt.Container.processEvent(Container.java:2239)
  at java.awt.Component.dispatchEventImpl(Component.java:4889)
  at java.awt.Container.dispatchEventImpl(Container.java:2297)
  at java.awt.Component.dispatchEvent(Component.java:4711)
  at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
  at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
  at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
  at java.awt.Container.dispatchEventImpl(Container.java:2283)
  at java.awt.Window.dispatchEventImpl(Window.java:2746)
  at java.awt.Component.dispatchEvent(Component.java:4711)
  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
  at java.awt.EventQueue.access$500(EventQueue.java:97)
  at java.awt.EventQueue$3.run(EventQueue.java:709)
  at java.awt.EventQueue$3.run(EventQueue.java:703)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
  at java.awt.EventQueue$4.run(EventQueue.java:733)
  at java.awt.EventQueue$4.run(EventQueue.java:731)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
  at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
  at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
  Caused by: java.lang.RuntimeException: org.hsqldb.jdbc.JDBCDriver
  at net.ucanaccess.jdbc.UcanaccessDriver.<clinit>(UcanaccessDriver.java:52)
  ... 35 more</clinit>
  
  I'm using Eclipse.
  I'm trying to connect to a ms acess database like this:
  try {
  Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  Customer Database.accdb;memory=false");
  Connection conn = DriverManager.getConnection("jdbc:ucanaccess://c:/Temp/PCResale.accdb;memory=false");
  System.out.println("Connection established!");
  } catch (SQLException | ClassNotFoundException e1) {
  e1.printStackTrace();
  }
  
  This is my pom file:
  
  <project xmlns="http://maven.apache.org/POM/4.0.0" maven-4.0.0.xsd"="" xsd="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" http:="" xsi:schemalocation="http://maven.apache.org/POM/4.0.0 <a href=" maven.apache.org="">http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelversion>4.0.0</modelversion></project>
  
  <groupid>org.test.se</groupid>
  <artifactid>org.test.se</artifactid>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>
  
  <name>org.test.se</name>
  <url>http://maven.apache.org</url>
  
  <properties>
  <project.build.sourceencoding>UTF-8</project.build.sourceencoding>
  </properties>
  
  <dependencies>
  <dependency>
  <groupid>org.hsqldb</groupid>
  <artifactid>hsqldb</artifactid>
  <version>2.5.0</version>
  <scope>test</scope>
  </dependency>
  <dependency>
  <groupid>com.healthmarketscience.jackcess</groupid>
  <artifactid>jackcess</artifactid>
  <version>3.0.1</version>
  </dependency>
  <dependency>
  <groupid>com.healthmarketscience.jackcess</groupid>
  <artifactid>jackcess-encrypt</artifactid>
  <version>3.0.0</version>
  </dependency>
  <dependency>
  <groupid>net.sf.ucanaccess</groupid>
  <artifactid>ucanaccess</artifactid>
  <version>5.0.0</version>
  </dependency>
  <dependency>
  <groupid>org.hamcrest</groupid>
  <artifactid>hamcrest-core</artifactid>
  <version>1.3</version>
  <scope>test</scope>
  </dependency>
  <dependency>
  <groupid>commons-codec</groupid>
  <artifactid>commons-codec</artifactid>
  <version>1.10</version>
  </dependency>
  <dependency>
  <groupid>org.apache.commons</groupid>
  <artifactid>commons-collections4</artifactid>
  <version>4.2</version>
  </dependency>
  <dependency>
  <groupid>org.apache.commons</groupid>
  <artifactid>commons-lang3</artifactid>
  <version>3.9</version>
  </dependency>
  <dependency>
  <groupid>org.apache.poi</groupid>
  <artifactid>poi</artifactid>
  <version>4.0.0</version>
  </dependency>
  <dependency>
  <groupid>commons-logging</groupid>
  <artifactid>commons-logging</artifactid>
  <version>1.2</version>
  </dependency>
  <dependency>
  <groupid>junit</groupid>
  <artifactid>junit</artifactid>
  <version>4.12</version>
  <scope>test</scope>
  </dependency>
  <dependency>
  <groupid>org.eclipse.swt</groupid>
  <artifactid>org.eclipse.swt.win32.win32.x86_64</artifactid>
  <version>4.3</version>
  </dependency>
  </dependencies>
  
  Java compiler 1.8
  This is about all I've done, Could someone please tell me what I've missed?
  Kind regards,
  Paul
  
  java.lang.ExceptionInInitializerErrorhttps://sourceforge.net/p/jackcess/discussion/456474/thread/ecbbecb8cd/?limit=25#7ed5
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/jackcess/discussion/456474/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  alternate
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- charlie brown - 2020-03-30
  
  Hi,   It's been YEARS, I used a text editor instead of Eclipse, and I don't remember half of this. BUT I think you might have a simple case of Parenthesis disease and maybe a missing period:
  
  This line has left and right paren.  Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  This line has only right. Also Customer <space> Database ? Customer Database.accdb;memory=false");Maybe that's ok, I would have to unpack boxes to find my code. Once you get it going, keep building progressively tests. My program only had to add records to an Access DB but I found that when Access users added records at the same time to the same DB, I would sometimes lose the lock on the memory page. BUT that was 6 years ago and I was a noob and there was other politics to deal with.</space>
  
  Hope this helps
  On Monday, March 30, 2020, 03:28:57 AM EDT, Paul Malm palle@users.sourceforge.net wrote:
  
  Hi,
  I've tried to connect to a simple acess database but I'm getting this exception:
  
  Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError
  at java.lang.Class.forName0(Native Method)
  at java.lang.Class.forName(Class.java:264)
  at org.flyginfo.se.main.accessDbMain$3.mouseReleased(accessDbMain.java:120)
  at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:290)
  at java.awt.Component.processMouseEvent(Component.java:6539)
  at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  at java.awt.Component.processEvent(Component.java:6304)
  at java.awt.Container.processEvent(Container.java:2239)
  at java.awt.Component.dispatchEventImpl(Component.java:4889)
  at java.awt.Container.dispatchEventImpl(Container.java:2297)
  at java.awt.Component.dispatchEvent(Component.java:4711)
  at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
  at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
  at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
  at java.awt.Container.dispatchEventImpl(Container.java:2283)
  at java.awt.Window.dispatchEventImpl(Window.java:2746)
  at java.awt.Component.dispatchEvent(Component.java:4711)
  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
  at java.awt.EventQueue.access$500(EventQueue.java:97)
  at java.awt.EventQueue$3.run(EventQueue.java:709)
  at java.awt.EventQueue$3.run(EventQueue.java:703)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
  at java.awt.EventQueue$4.run(EventQueue.java:733)
  at java.awt.EventQueue$4.run(EventQueue.java:731)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
  at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
  at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
  Caused by: java.lang.RuntimeException: org.hsqldb.jdbc.JDBCDriver
  at net.ucanaccess.jdbc.UcanaccessDriver.<clinit>(UcanaccessDriver.java:52)
  ... 35 more</clinit>
  
  I'm using Eclipse.
  I'm trying to connect to a ms acess database like this:
  try {
  Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  Customer Database.accdb;memory=false");
  Connection conn = DriverManager.getConnection("jdbc:ucanaccess://c:/Temp/PCResale.accdb;memory=false");
  System.out.println("Connection established!");
  } catch (SQLException | ClassNotFoundException e1) {
  e1.printStackTrace();
  }
  This is my pom file:
  
  <project xmlns="http://maven.apache.org/POM/4.0.0" maven-4.0.0.xsd"="" xsd="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" http:="" xsi:schemalocation="http://maven.apache.org/POM/4.0.0 <a href=" maven.apache.org="">http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelversion>4.0.0</modelversion></project>
  
  <groupid>org.test.se</groupid>
  <artifactid>org.test.se</artifactid>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>
  
  <name>org.test.se</name>
  <url>http://maven.apache.org</url>
  
  <properties>
  <project.build.sourceencoding>UTF-8</project.build.sourceencoding>
  </properties>
  
  <dependencies>
  <dependency>
  <groupid>org.hsqldb</groupid>
  <artifactid>hsqldb</artifactid>
  <version>2.5.0</version>
  <scope>test</scope>
  </dependency>
  <dependency>
  <groupid>com.healthmarketscience.jackcess</groupid>
  <artifactid>jackcess</artifactid>
  <version>3.0.1</version>
  </dependency>
  <dependency>
  <groupid>com.healthmarketscience.jackcess</groupid>
  <artifactid>jackcess-encrypt</artifactid>
  <version>3.0.0</version>
  </dependency>
  <dependency>
  <groupid>net.sf.ucanaccess</groupid>
  <artifactid>ucanaccess</artifactid>
  <version>5.0.0</version>
  </dependency>
  <dependency>
  <groupid>org.hamcrest</groupid>
  <artifactid>hamcrest-core</artifactid>
  <version>1.3</version>
  <scope>test</scope>
  </dependency>
  <dependency>
  <groupid>commons-codec</groupid>
  <artifactid>commons-codec</artifactid>
  <version>1.10</version>
  </dependency>
  <dependency>
  <groupid>org.apache.commons</groupid>
  <artifactid>commons-collections4</artifactid>
  <version>4.2</version>
  </dependency>
  <dependency>
  <groupid>org.apache.commons</groupid>
  <artifactid>commons-lang3</artifactid>
  <version>3.9</version>
  </dependency>
  <dependency>
  <groupid>org.apache.poi</groupid>
  <artifactid>poi</artifactid>
  <version>4.0.0</version>
  </dependency>
  <dependency>
  <groupid>commons-logging</groupid>
  <artifactid>commons-logging</artifactid>
  <version>1.2</version>
  </dependency>
  <dependency>
  <groupid>junit</groupid>
  <artifactid>junit</artifactid>
  <version>4.12</version>
  <scope>test</scope>
  </dependency>
  <dependency>
  <groupid>org.eclipse.swt</groupid>
  <artifactid>org.eclipse.swt.win32.win32.x86_64</artifactid>
  <version>4.3</version>
  </dependency>
  </dependencies>
  
  Java compiler 1.8
  This is about all I've done, Could someone please tell me what I've missed?
  Kind regards,
  Paul
  
  java.lang.ExceptionInInitializerError
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/jackcess/discussion/456474/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  alternate
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- James Ahlborn - 2020-03-30
  
  your hsqldb dependency is marked as "test", which may be causing this problem.
  
  update: oops, i didn't see your follow up messge. glad you got it sorted out.
  
  Last edit: James Ahlborn 2020-03-30
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

java.lang.ExceptionInInitializerError

Forums

Help

java.lang.ExceptionInInitializerError document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

java.lang.ExceptionInInitializerError