Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Jubula » Mac can't open h2 database
Mac can't open h2 database [message #851308] Fri, 20 April 2012 21:33 Go to next message
Ryan Goetz is currently offline Ryan Goetz
Messages: 4
Registered: April 2012
Junior Member
I can't figure out why my mac snow leapord can't open up the default h2 database under .jubula. Here is the client.log

2012-04-20 14:24:00.075 [Worker-2] ERROR o.e.j.c.core.persistence.Persistor - no or wrong username or password
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:h2:~/.jubula/database/embedded;MVCC=TRUE;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
Error Code: 0
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.jubula.client.core.persistence.Persistor.buildSessionFactoryWithLoginData(Persistor.java:283) [org.eclipse.jubula.client.core_1.2.0.201203181048.jar:na]
	at org.eclipse.jubula.client.core.persistence.Persistor.<init>(Persistor.java:157) [org.eclipse.jubula.client.core_1.2.0.201203181048.jar:na]
	at org.eclipse.jubula.client.core.persistence.Persistor.instance(Persistor.java:598) [org.eclipse.jubula.client.core_1.2.0.201203181048.jar:na]
	at org.eclipse.jubula.client.core.persistence.Persistor.access$4(Persistor.java:593) [org.eclipse.jubula.client.core_1.2.0.201203181048.jar:na]
	at org.eclipse.jubula.client.core.persistence.Persistor$2.run(Persistor.java:191) [org.eclipse.jubula.client.core_1.2.0.201203181048.jar:na]
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) [org.eclipse.core.jobs_3.5.101.v20120113-1953.jar:na]
Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:h2:~/.jubula/database/embedded;MVCC=TRUE;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
Error Code: 0
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:319) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:584) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488) ~[org.eclipse.persistence.jpa_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	... 10 common frames omitted
Caused by: java.sql.SQLException: No suitable driver found for jdbc:h2:~/.jubula/database/embedded;MVCC=TRUE;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
	at java.sql.DriverManager.getConnection(DriverManager.java:602) ~[na:1.6.0_31]
	at java.sql.DriverManager.getConnection(DriverManager.java:154) ~[na:1.6.0_31]
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98) ~[org.eclipse.persistence.core_2.3.2.v20111125-r10461.jar:2.3.2.v20111125-r10461]
	... 14 common frames omitted

[Updated on: Fri, 20 April 2012 21:38]

Report message to a moderator

Re: Mac can't open h2 database [message #853597 is a reply to message #851308] Mon, 23 April 2012 06:45 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra Schladebeck
Messages: 1149
Registered: July 2009
Senior Member
Hi,

The most usual reason for problems with the H2 database are write access or quota. The database is written by default to your home directory under the folder ~/.jubula/database/embedded. Do you have write access / enough space there?

You can also try entering another path in the database preferences.

HTH,
Alex
Re: Mac can't open h2 database [message #854033 is a reply to message #851308] Mon, 23 April 2012 15:35 Go to previous messageGo to next message
Ryan Goetz is currently offline Ryan Goetz
Messages: 4
Registered: April 2012
Junior Member
I should have permissions I am the administrator and have enough space. I also opened jubula with sudo to see if that help. I moved the database location to my desktop but no luck same errors. I was finally able to capture the error dialog that popped up about the drivers. I thought jubula comes with he h2 drivers.

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:h2:/Users/rrgoetz/Desktop/jubula;MVCC=TRUE;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
Error Code: 0

[Updated on: Mon, 23 April 2012 15:35]

Report message to a moderator

Re: Mac can't open h2 database [message #854663 is a reply to message #854033] Tue, 24 April 2012 06:14 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra Schladebeck
Messages: 1149
Registered: July 2009
Senior Member
Hi,

Yes, Jubula does come with H2 drivers. Unfortunately, EclipseLink gives us this error message pretty much regardless of what the problem was with the database creation or connection, which makes analysis difficult.

Could it be a firewall problem? You could try disabling the firewall to see whether it works then.

If you continue to have problems with the H2 database, then I'd recommend setting up an Oracle or Oracle XE database instead. The H2 database is only for demo purposes anyway, not productive use. If you're working with Eclipse for Testers, you'll need to install the database drivers from the Marketplace to do that. If you're working with the standalone, they'll already be there.

Best regards,
Alex

Re: Mac can't open h2 database [message #875976 is a reply to message #854663] Wed, 23 May 2012 16:44 Go to previous message
Miles Parker is currently offline Miles Parker
Messages: 1340
Registered: July 2009
Senior Member
I can't speak to Jubula per se, but this issue sounds very familiar to me. We've run into it with Virgo applications. There is some real funny business with how H2 is loading the classes for its drivers and that doesn't seem to mesh well with the Eclipse/Equinox class loading mechanism. One thing you can look at is the order of bundle loading.

Previous Topic:Problems extending Jubula to support SWT Links
Next Topic:Can't import sample projects..
Goto Forum:
  


Current Time: Tue Sep 16 23:31:31 GMT 2014

Powered by FUDForum. Page generated in 0.02377 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software