[syncope-dev] Issue 155 in syncope: Quartz table creation script for MySQL-InnoDB contains syntax error

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[syncope-dev] Issue 155 in syncope: Quartz table creation script for MySQL-InnoDB contains syntax error

syncope
Status: Accepted
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 155 by [hidden email]: Quartz table creation script for  
MySQL-InnoDB contains syntax error
http://code.google.com/p/syncope/issues/detail?id=155

What steps will reproduce the problem?
1. Use MySQL InnoDB as persistence backend
2. Start container
3. show tables in MySQL

What is the expected output? What do you see instead?
Expected is a number of qrtz_* tables.
However, these tables are not created, because 'TYPE' is used instead  
of 'ENGINE'.

Please find attached the patch that fixes this.

Attachments:
        quartz-innodb.patch  2.7 KB

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[syncope-dev] Re: Issue 155 in syncope: Quartz table creation script for MySQL-InnoDB contains syntax error

syncope

Comment #1 on issue 155 by [hidden email]: Quartz table creation  
script for MySQL-InnoDB contains syntax error
http://code.google.com/p/syncope/issues/detail?id=155

Which version of MySQL are you running? With 5.1 everything works fine.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[syncope-dev] Re: Issue 155 in syncope: Quartz table creation script for MySQL-InnoDB contains syntax error

syncope

Comment #2 on issue 155 by [hidden email]: Quartz table creation script  
for MySQL-InnoDB contains syntax error
http://code.google.com/p/syncope/issues/detail?id=155

I'm using version 5.5.14.

The MySQL-manual is subtle about this. [1]
Version 5.0 says: {ENGINE|TYPE} [=] engine_name
Version 5.1 says: ENGINE [=] engine_name
Version 5.5 says: ENGINE [=] engine_name

And judging from your comment, they kept 'TYPE' in 5.1 but removed it in  
5.5...

[1] http://dev.mysql.com/doc/refman/5.1/en/create-table.html

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[syncope-dev] Re: Issue 155 in syncope: Quartz table creation script for MySQL-InnoDB contains syntax error

syncope
Updates:
        Status: Started
        Owner: [hidden email]
        Labels: Milestone-Release-201112 Component-Persistence Source-trunk

Comment #3 on issue 155 by [hidden email]: Quartz table creation  
script for MySQL-InnoDB contains syntax error
http://code.google.com/p/syncope/issues/detail?id=155

(No comment was entered for this change.)

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[syncope-dev] Re: Issue 155 in syncope: Quartz table creation script for MySQL-InnoDB contains syntax error

syncope

Comment #4 on issue 155 by [hidden email]: Quartz table creation  
script for MySQL-InnoDB contains syntax error
http://code.google.com/p/syncope/issues/detail?id=155

Patch applied successfully.

If you want to test that everything works as expected with MySQL, just  
start a MySQL instance on localhost, create a db "syncope" with  
user "syncope" and password "syncope" and launch - from core subdir:

mvn -P mysql-it

This command will run all core tests against your MySQL database instead of  
HSQLDB.

Of course, you will have to wipe all db content before launching tests  
again.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[syncope-dev] Re: Issue 155 in syncope: Quartz table creation script for MySQL-InnoDB contains syntax error

syncope
Updates:
        Status: Fixed

Comment #5 on issue 155 by [hidden email]: Quartz table creation  
script for MySQL-InnoDB contains syntax error
http://code.google.com/p/syncope/issues/detail?id=155

This issue was closed by revision r1161.

Loading...