Skip to main content



      Home
Home » Archived » Jubula » Problems using Jubula with MySQL(Creation and Import of Projects is not possible)
Problems using Jubula with MySQL [message #1403906] Mon, 28 July 2014 10:15 Go to next message
Eclipse UserFriend
Hi,

we are at the beginning of a new project and decided to give Jubula a try for testing our e4 rcp application. As the first steps with the embedded H2 database and Jubula 8.0.0 were quite promising we now tried to switch to a MySQL database to be able to work on the tests in a team.

I exported my projects and tried to import them to the MySQL database, but it failed. Creating a new project was not possible as well.

This is the exception I get when trying to import a project:
Importing projects...
	Reading projects...
	Reading project file /C:/Daten/Jubula/unbound_modules_concrete_8.0.xml.
	Finished reading projects.
	Importing unbound_modules_concrete_8.0...
	Error occurred while importing unbound_modules_concrete_8.0:
org.eclipse.jubula.client.core.persistence.PMSaveException: Can't save project.Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'myproject_jubula_tests.node' doesn't exist
Error Code: 1146
Call: INSERT INTO NODE (ID, IS_ACTIVE, COMP_NAME, COMP_TYPE, IS_GENERATED, GUID, COMP_ACTION, COMM_TXT, NAME, PARENT_PROJ, TASK_ID, TIMESTAMP, VERSION, FK_PARAM_INTERFACE, CLASS_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [15 parameters bound]
Query: InsertObjectQuery(org.eclipse.jubula.client.core.model.CapPO@cecb40e2 (input text)) :Save of unbound_modules_concrete failed!.
Finished importing projects.


Creating a new project results in an error:
Quote:
Reason:
2043: Creation of a new project failed.
No details.


When I try to open the "Open Project" dialog, the following exception occurs:
3004: Unexpected error occurred.
  org.eclipse.e4.core.di.InjectionException: java.lang.NullPointerException
  	at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:63)
  	at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:231)
  	at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:212)
  	at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:131)
  	at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:171)
  	at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.executeItem(HandledContributionItem.java:831)
  	at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.handleWidgetSelection(HandledContributionItem.java:724)
  	at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.access$7(HandledContributionItem.java:708)
  	at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem$4.handleEvent(HandledContributionItem.java:647)
  	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
  	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
  	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
  	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
  	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1053)
  	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
  	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:942)
  	at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)
  	at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:588)
  	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
  	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:543)
  	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
  	at org.eclipse.jubula.app.Launcher.start(Launcher.java:227)
  	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
  	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
  	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
  	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
  	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  	at java.lang.reflect.Method.invoke(Unknown Source)
  	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
  	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
  	at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
  	at org.eclipse.equinox.launcher.Main.main(Main.java:1414)
  Caused by: java.lang.NullPointerException
  	at org.eclipse.jubula.client.ui.rcp.handlers.project.OpenProjectHandler.executeImpl(OpenProjectHandler.java:534)
  	at org.eclipse.jubula.client.ui.handlers.AbstractHandler.execute(AbstractHandler.java:46)
  	at org.eclipse.jubula.client.ui.handlers.project.AbstractProjectHandler.execute(AbstractProjectHandler.java:38)
  	at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)
  	at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:76)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  	at java.lang.reflect.Method.invoke(Unknown Source)
  	at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
  	... 34 more


I am well aware, that Jubula does not support MySQL. But I think in this case it is probably just a mistake on my side.

Can anyone please help me with that or has an idea what can be wrong?

Thanks!

Regards,
Carsten
Re: Problems using Jubula with MySQL [message #1404355 is a reply to message #1403906] Thu, 31 July 2014 09:15 Go to previous messageGo to next message
Eclipse UserFriend
Is there no one who can help me with this problem?

If you are using MySQL, are you experiencing any problems? Or is there something to consider when using Jubula and MySQL?

Thanks for any help!

Regard,
Carsten
Re: Problems using Jubula with MySQL [message #1404367 is a reply to message #1404355] Thu, 31 July 2014 11:01 Go to previous messageGo to next message
Eclipse UserFriend
There are a lot of users using MySQL mostly without problems. MySQL is not really supported (and tested) because there are so many versions on so many platforms. Every once in a while someone runs into a configuration problem where we can't help because we don't have experts for every kind of DMBS at our disposal.

Nevertheless, you may look into this bug which describes what looks like your problem and the solution.

- Achim

Re: Problems using Jubula with MySQL [message #1404427 is a reply to message #1404367] Fri, 01 August 2014 05:55 Go to previous messageGo to next message
Eclipse UserFriend
Hi,

@Achim: Thanks for the link, it really seems to be the same problem. After changing the collation from utf-8 to latin1_bin, I was able to import my projects.

Thanks a lot!

Regards,

Carsten
Re: Problems using Jubula with MySQL [message #1404607 is a reply to message #1404427] Mon, 04 August 2014 08:50 Go to previous message
Eclipse UserFriend
u can also look here

https://www.eclipse.org/forums/index.php/m/1352211/#msg_1352211
Previous Topic:Importing the xml file
Next Topic:Drag & drop between AUT and another app / two AUTs
Goto Forum:
  


Current Time: Mon Jul 21 00:29:26 EDT 2025

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

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

Back to the top