Eclipse Community Forums: Jubula » MySQL troubles

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Thu, 04 December 2014 08:17

fab jubulator

Messages: 30
Registered: November 2014

Member

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 11:52]

Report message to a moderator

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

Tue, 09 December 2014 13:51

fab jubulator

Messages: 30
Registered: November 2014

Member

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 14:11]

Report message to a moderator

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

Wed, 10 December 2014 08:03

Alexandra Schladebeck

Messages: 1613
Registered: July 2009

Senior Member

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

Report message to a moderator