Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 356133 - Errors when database is utf8
Summary: Errors when database is utf8
Status: CLOSED INVALID
Alias: None
Product: Jubula
Classification: Technology
Component: UI (show other bugs)
Version: 1.0.0   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: Indigo SR2   Edit
Assignee: Project Inbox CLA
QA Contact: Oliver Goetz CLA
URL:
Whiteboard:
Keywords:
: 400656 (view as bug list)
Depends on:
Blocks:
 
Reported: 2011-08-29 19:44 EDT by Michael Tänzer CLA
Modified: 2013-02-26 06:31 EST (History)
2 users (show)

See Also:


Attachments
Error thrown when trying to import my project (7.64 KB, text/plain)
2011-11-08 08:33 EST, Sandro Wyss CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Tänzer CLA 2011-08-29 19:44:30 EDT
Jubula doesn't work if the character set of the database used is utf8. This is tested on MySQL but I guess the same thing should show up on any other SQL database.

The problem seems to be that Jubula can't import the base projects unbound_modules_* and then it's impossible to create or import a new project. No meaningful error message is given, so that it took me some hours to track down the problem.
Comment 1 Sandro Wyss CLA 2011-11-08 08:33:47 EST
Created attachment 206589 [details]
Error thrown when trying to import my project

Same problem here. When I tried to select my MySQL database (db encoding = utf8), the initial import of the module projects failed:

---
Connection to Database successful.
Importing projects...
	Reading projects...
	Reading project file /resources/library/unbound_modules_html_5.2.xml.
	Reading project file /resources/library/unbound_modules_rcp_5.2.xml.
	Reading project file /resources/library/unbound_modules_concrete_5.2.xml.
	Reading project file /resources/library/unbound_modules_swt_5.2.xml.
Project "unbound_modules_swt" in version 5.2 requires the following project(s):
- project "unbound_modules_concrete" in version 5.2
---

When I tried to import my existing project afterwards, the attached error was thrown.

Everything works now fine after changing the encoding of the database to latin1. As I do not depend on the utf8 encoding this is no problem for me but it should at least be documented in the installation because it took me quite some time to figure this out.

Reproducable: always
Jubula Version: 1.1.0

Steps to reproduce:
1. Setup a MySQL-Database with option "character_set_database" set to "utf8"
2. Setup db connection in Jubula
3. Connect to db in Jubula
-->  Importing project fails!
4. Try to import an existing Jubula project
--> Attached exception is trhown
Comment 2 Achim Loerke CLA 2012-03-09 08:15:48 EST
UTF-8 is working on Oracle and H2 which are the only databases we test. H2 should not be used for production uses.

MySQL and Postgres are only there for convenience. There are configurations which will work with Jubula, but we are no experts on the DBs.
Comment 3 Niels Boeger CLA 2013-02-26 06:31:31 EST
*** Bug 400656 has been marked as a duplicate of this bug. ***