Home » Archived » Jubula » Jubula and MySQL(Problems creating a new project using MySQL db as backend)
Jubula and MySQL [message #868870] |
Wed, 02 May 2012 16:52 |
Diane Mising name Messages: 22 Registered: June 2011 |
Junior Member |
|
|
I am relatively new to Jubula and my company is trying to do a POC. I installed the standalone version of Jubula and worked extensively with the embedded H2 database. It worked great. I created projects, suites, etc. Now, as we look at using Jubula in a multi-user environment, we decided to go with using a MySQL database and we are running into a lot of issues. We worked through all the firewall/permissions issues. I am able to successfully connect to the database and the user I am using has full access to the MySQL database. My problem comes when I try to create a new project. Within Jubula, I get the message "Reason 2043: Creation of a new project failed." That's it. No details. We turned on all the logging we could and added a sniffer to try and debug our issue. We could see there was traffic between our Jubula PC and the MySQL database. We could also see that there were numerous inserts/selects that were successful when I tried to create a new project. However, there was one insert in particular that failed and we don't know why. Here is the statement that is failing:
"INSERT INTO NODE (ID, IS_ACTIVE, CONF_MAJ_VERS, IS_GENERATED, GUID, COMM_TXT, NAME, PARENT_PROJ, TIMESTAMP, VERSION, FK_PARAM_INTERFACE, AUT_CONT, EXECOBJ_CONT, SPECOBJ_CONT, TDC_CONT, PROJECT_PROPERTIES, CLASS_ID) VALUES (702, 1, 6, 0, '4e1c5435975a4560b20dc869d552021d', null, null, null, 0, 1, 703, 705, 713, 714, 715, 716, 'P')"
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.
|
|
| |
Re: Jubula and MySQL [message #870758 is a reply to message #870750] |
Wed, 09 May 2012 14:49 |
Diane Mising name Messages: 22 Registered: June 2011 |
Junior Member |
|
|
Hi Alex,
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
[Updated on: Wed, 09 May 2012 14:49] Report message to a moderator
|
|
| | | | | |
Goto Forum:
Current Time: Thu Sep 19 07:00:32 GMT 2024
Powered by FUDForum. Page generated in 0.04364 seconds
|