Can someone help us out? Is there a table called node? When does the node table get created? Is there any documentation of the H2 embedded databases so we can see the table structure and see if it matches our MySQL databases? Jubula does so many things behind the scenes, it makes it difficult to diagnose problems. Is there anyone who has used a MySQL database as the backend that I could communicate with? Any help would be appreciated? Thanks.]]>Diane Mising name2012-05-02T16:52:53-00:00Re: Jubula and MySQL
https://www.eclipse.org/forums/index.php/mv/msg/350912/870750/#msg_870750
As we don't use or test MySQL as a part of our regression suites, I can't give much help here. We did do a proof of concept for MySQL at one point in time, found that it seemed to work and added the drivers with the unsupported marker to reflect the fact that we do not test them. I can tell you that there is a table called NODE, and that it contains items such as projects, test suites, test cases etc.
I know that other users do work with MySQL, so perhaps one of them can help you further. The H2 database should be viewable with a database tool if you want to look at the tables to compare.
Best regards,
Alex]]>Alexandra Schladebeck2012-05-09T14:26:09-00:00Re: Jubula and MySQL
https://www.eclipse.org/forums/index.php/mv/msg/350912/870758/#msg_870758
Thanks for the reply. I understand that you don't use MySQL, but can you tell me when the 'Node' table gets created? Does that table typically get created when you connect to the database or when you create a project?
I have also tried using SQuirrelSQL and RazorSQL to look at the H2 databases and I am unable to see the table structure. Can you tell me the database tool you use to view the H2 databases?
We can see numerous other tables being created in the MySQL database, but we having trouble with just this one table.
Thanks again for your help.
Diane]]>Diane Mising name2012-05-09T14:49:26-00:00Re: Jubula and MySQL
https://www.eclipse.org/forums/index.php/mv/msg/350912/870769/#msg_870769
We are running also a MySQL Database.
First I can tell you that we as a big company are also not very happy that databases like MySQL or MS SQL are not fully supported by Jubula.
We already hat discussions about this with Bredex, hopefully they will really support more in the feature.
Second
Following Version works fine for us:
Server: localhost via TCP/IP
Server Version: 5.5.8
Protokoll-Version: 10
MySQL-Zeichensatz: UTF-8 Unicode (utf8)
Webserver
Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9. PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1
MySQL-Client-Version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $
PHP Erweiterung: mysql
]]>Sascha Mising name2012-05-09T15:09:05-00:00Re: Jubula and MySQL
https://www.eclipse.org/forums/index.php/mv/msg/350912/871050/#msg_871050
Thanks for the reply. I am glad to hear that you are using MySQL. However, we are still struggling with this 'NODE' table. Would be willing to post the table structure for the 'NODE' table so that we can manually create this table in the MySQL database. I have tried to look at the embedded H2 databases, but I am unable to see any tables in the PUBLIC schema.
I don't know that we are going to be able to keep using Jubula if we can't get past this issue. I would really appreciate your help.
Thanks!
Diane]]>Diane Mising name2012-05-10T16:33:14-00:00Re: Jubula and MySQL
https://www.eclipse.org/forums/index.php/mv/msg/350912/871079/#msg_871079
]]>Sascha Mising name2012-05-10T17:59:13-00:00Re: Jubula and MySQL
https://www.eclipse.org/forums/index.php/mv/msg/350912/871080/#msg_871080
Diane Mising name2012-05-10T18:02:21-00:00Re: Jubula and MySQL
https://www.eclipse.org/forums/index.php/mv/msg/350912/1743305/#msg_1743305
There is a limitation of size per table in Mysql.
When the NODE table is created, if the myql database used UTF8, the NODE table is too large for mysql (Every table (regardless of storage engine) has a maximum row size of 65,535 bytes)
So a solution is to create a database with Latin1, the jubula tables are then correctly created.