Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Jubula » MySQL driver not found(The JDBC driver for MySQL is not found)
MySQL driver not found [message #759911] Wed, 30 November 2011 09:49 Go to next message
Amir Hadi is currently offline Amir Hadi
Messages: 10
Registered: November 2011
Location: Stuttgart, Germany
Junior Member

Hi,

I am new to Jubula and love it! It's really great software. Until yet I just used the embedded H2 database which worked out of the box.

Now I added a MySQL database profile in the preferences menu. When I try to connect, the following messages are written in the client log.

Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/Jubula
Error Code: 0
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) ~[org.eclipse.persistence.core_2.2.0.v20110202-r8913.jar:2.2.0.v20110202-r8913]
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:319) ~[org.eclipse.persistence.core_2.2.0.v20110202-r8913.jar:2.2.0.v20110202-r8913]
	at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138) ~[org.eclipse.persistence.core_2.2.0.v20110202-r8913.jar:2.2.0.v20110202-r8913]
	at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162) ~[org.eclipse.persistence.core_2.2.0.v20110202-r8913.jar:2.2.0.v20110202-r8913]
	at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:592) ~[org.eclipse.persistence.core_2.2.0.v20110202-r8913.jar:2.2.0.v20110202-r8913]
	at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:233) ~[org.eclipse.persistence.jpa_2.2.0.v20110202-r8913.jar:2.2.0.v20110202-r8913]
	at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394) ~[org.eclipse.persistence.jpa_2.2.0.v20110202-r8913.jar:2.2.0.v20110202-r8913]
	... 9 common frames omitted
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/Jubula
	at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.6.0_18]
	at java.sql.DriverManager.getConnection(Unknown Source) ~[na:1.6.0_18]


How can I add the driver to the classpath? Or any other solution to this problem?

I am using Jubula (standalone) version 1.1.0

Any help is much appreciated,
Amir
Re: MySQL driver not found [message #759923 is a reply to message #759911] Wed, 30 November 2011 10:16 Go to previous messageGo to next message
Amir Hadi is currently offline Amir Hadi
Messages: 10
Registered: November 2011
Location: Stuttgart, Germany
Junior Member

I am really sorry, I really searched for 1.5h now. Answer is the bug in Bugzilla with ID 342706 (I am not allowed to post a link).

The username had no permission to access the database specified, but the exception message was not really helpful. Sorry!
Re: MySQL driver not found [message #759924 is a reply to message #759923] Wed, 30 November 2011 10:17 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra Schladebeck
Messages: 1092
Registered: July 2009
Senior Member
Thanks for posting the solution! Smile
Re: MySQL driver not found [message #759940 is a reply to message #759924] Wed, 30 November 2011 10:58 Go to previous messageGo to next message
Amir Hadi is currently offline Amir Hadi
Messages: 10
Registered: November 2011
Location: Stuttgart, Germany
Junior Member

OK sorry for having to post again, but now I don't believe this was the exact solution. There have to be different bugs.

Problem is: First connection to an empty database works fine (it creates tables), but when I want to create a project or even open it, then I get the error that the table "Node" doesn't exist. By the way the exception text again contains the "no suitable driver" message.

Any other ideas?
Re: MySQL driver not found [message #759949 is a reply to message #759940] Wed, 30 November 2011 11:36 Go to previous messageGo to next message
Alexandra Schladebeck is currently offline Alexandra Schladebeck
Messages: 1092
Registered: July 2009
Senior Member
We don't actually use MySQL - we tested it to ensure that is generally runs, and it is marked as unsupported (i.e. untested) in the preferences. I think that other users have successfully used MySQL, perhaps one of them can help you further.
Re: MySQL driver not found [message #760132 is a reply to message #759949] Thu, 01 December 2011 07:44 Go to previous messageGo to next message
Amir Hadi is currently offline Amir Hadi
Messages: 10
Registered: November 2011
Location: Stuttgart, Germany
Junior Member

I switched to PostGreSQL and definitly works fine now. Thank you!
Re: MySQL driver not found [message #775065 is a reply to message #759940] Thu, 05 January 2012 03:49 Go to previous messageGo to next message
Martin   is currently offline Martin
Messages: 1
Registered: December 2011
Junior Member
Amir Hadi wrote on Wed, 30 November 2011 10:58
Problem is: First connection to an empty database works fine (it creates tables), but when I want to create a project or even open it, then I get the error that the table "Node" doesn't exist.


I had the same issue, connecting Jubula to MySQL on Windows would create 67 tables but not import or open projects due to a missing ´node´ table.
I've tried the same on a Linux-based MySQL instead - this creates 70 tables and appears to work.
Comparing the created tables Windows-based MySQL failed to create ´node´, ´testresult´, ´testresult_summary´.
Re: MySQL driver not found [message #868965 is a reply to message #775065] Wed, 02 May 2012 15:43 Go to previous message
Diane Mising name is currently offline Diane Mising name
Messages: 22
Registered: June 2011
Junior Member
Martin.... did you ever get you MySQL error worked out? I am running into the same issue (Missing 'node' table) and I would appreciate any feedback and/or solution. Thanks.
Previous Topic:How To add "new line" in Central Data Set?
Next Topic:Double backslashes cause problem for external app
Goto Forum:
  


Current Time: Mon Jul 28 18:43:29 EDT 2014

Powered by FUDForum. Page generated in 0.02391 seconds