Eclipse Community Forums: Jubula » MySQL troubles

Home » Archived » Jubula » MySQL troubles - table node does not exist (Cannot Import unbound_modules_concrete8.0.xml)

MySQL troubles - table node does not exist [message #1498172]

Thu, 04 December 2014 03:17

Eclipse User

If I connect to the MySQL Database it seems that the table "node" is not created.
Can that be fixed?
Can I create the tables manually?

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 'jubula_8.0.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@4c04bb57 (store text at mouse position)) :Save of unbound_modules_concrete failed!.
Finished importing projects.

I have since taken a look at the H2 database and the SQL statements, which are incompatible with MySql.

Does Jubula offer some kind of conversion?

Which oracle dmbs do you recommend instead?

We use postgrs and MySql: The ones which don't seem to work properly with Jubula.

[Updated on: Thu, 04 December 2014 06:52] by Moderator

Re: MySQL troubles - table node does not exist [message #1504720 is a reply to message #1498172]

Tue, 09 December 2014 08:51

Eclipse User

If I want to connect my MySQL DB. th econnection fails. The client log says this:
[Worker-0] ERROR o.e.j.c.core.persistence.Persistor - DBVersion: db entry for DBVersion is missing or ambiguous

Does anybody know this?

I've taken a look into the h2 database. It says:
JUBULA PUBLIC DB_VERSION TABLE (null) (null) (null) (null) (null) CREATE CACHED TABLE PUBLIC.DB_VERSION(
ID BIGINT NOT NULL,
MAJORVERSION INTEGER,
MINORVERSION INTEGER,
VERSION INTEGER

Is there possibly a connection?

[Updated on: Tue, 09 December 2014 09:11] by Moderator

Re: MySQL troubles - table node does not exist [message #1505664 is a reply to message #1504720]

Wed, 10 December 2014 03:03

Eclipse User

Hi,

There was a problem with the 8.0 version and the MySQL DB - I know we've fixed it now and if I remember correctly there was a workaround. I'll ask here again. You could also search in the forum, I'm sure it was mentioned here.

Best regards,
Alex

Re: MySQL troubles - table node does not exist [message #1505772 is a reply to message #1505664]

Wed, 10 December 2014 04:49

Eclipse User

Hi,

I suppose Alex ment my entry i wrote when i updated to Jubula 8.

U can find the Topic here

Re: MySQL troubles - table node does not exist [message #1505789 is a reply to message #1498172]

Wed, 10 December 2014 05:03

Eclipse User

You may check this thread for one of the many reasons we don't work with MySQL.

- Achim

Re: MySQL troubles - table node does not exist [message #1507284 is a reply to message #1505789]

Thu, 11 December 2014 08:37

Eclipse User

Thanks for the reply. I switched to Oracle Express, which seems to work fine!