3.5.7 import solution issue with MySQL 5.1 Repository

Classic Servoy
1

I am trying to import a solution into Servoy 3.5.7 with the repository in MySQL 5.1.

I have imported like 25 solutions without any issue except for one solutions that gives the below error.

I am working on Mac OS X with Java 5.```
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘load integer default null)’ at line 1

2

Hi Marcel,

Are you using the latest MySQL driver?

3

:) always… And, it works for the other 25 imports…

4

Do you get the error while Servoy is creating some table or adding some columns? Is it possible that you are using a mysql reserved word as a column name? It would be nice to see the full query sent to the db, but for that you should turn on the tracing in servoy.

5

Should have thought of that myself :)

Below the full logging from selecting the export including the error message.

2009-01-03 22:25:41,167 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Parsing export/version_info.xml.
2009-01-03 22:25:41,170 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Import contains XML version 12 and repository version 31.
2009-01-03 22:25:41,170 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - ImportHandlerManager got XML version 12, repository version 31, Servoy version 3.5.7, build number 520
2009-01-03 22:25:41,171 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,171 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Parsing database information in export/database_info.xml.
2009-01-03 22:25:41,179 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Parsing user information in export/user_info.xml.
2009-01-03 22:25:41,179 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - No user information in export/user_info.xml in import.
2009-01-03 22:25:41,179 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Parsing revision information in export/solutions/IT2BE_gantt/revision_info.xml.
2009-01-03 22:25:41,191 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Parsing object in export/solutions/IT2BE_gantt/solution.xml.
2009-01-03 22:25:41,210 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Parsing security information in export/solutions/IT2BE_gantt/security_info.xml.
2009-01-03 22:25:41,213 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Importing blobs.
2009-01-03 22:25:41,213 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,215 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,216 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,217 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,217 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,218 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,219 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,220 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,221 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,222 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,222 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,223 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,224 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,226 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,226 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,227 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,228 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,229 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,230 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,232 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,233 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,234 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/3b401de9-4951-4cc7-9e57-67aaa9cb08be.bin/zsiOzi9sWyt2qaGvyhvTmPZV8c8=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/4bc71da3-fdf5-4c8c-a26b-8fd113f55776.bin/40y7SMg6WtTQJShps+uN+V2GTFE=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/61bb9865-26ca-459b-af2a-f35a4f1c7386.bin/T1JAuQPD4ZR11z0/u1+QWhmkOiI=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/687adb96-f085-4695-a15b-3d779218e842.bin/BpwRGspPa6Qvwx20X2cmofCXeEM=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/6ec6ee92-38a7-4de0-ad06-2199e3b17444.bin/L4O3S6bPpxzlfp0XSY+90xwShW0=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/80bd16d6-26c8-430a-ab70-07cea5f56b77.bin/cpZ2ehS4gu+UAcvS/Hm/IqQIHGY=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/8c024ce5-bbe2-4795-a857-2198758b58d9.bin/Q+5GLgeb9TUO8aiseNxjPBS/3yU=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/adb03d93-7960-443d-8f4d-7ffc9b0cf3b0.bin/HKxou5DuFrPp86HJeFty/ISFE2E=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/d85ad57d-b89f-4807-850f-7f0a4700a275.bin/YEaMdD/DIWoG0iP76gyL3om/K+I=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/dab0c899-d475-49b9-b8af-e86c47368dab.bin/UiiqYChRQCoVaN71qsqOiHY0Nf4=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/blobs/e47d08aa-2dc8-455f-b566-8619f5567ce1.bin/T/cSbhJxRI+3oxQWAnmQIlIRADs=
2009-01-03 22:25:41,235 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/database_info.xml/fBhedqDzgwR8bH0KutjQHPc3i90=
2009-01-03 22:25:41,236 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/main/Duy/tUuA5Vc13w9SiqpJrkgmFTQ=
2009-01-03 22:25:41,236 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/solutions/IT2BE_gantt/revision_info.xml/IohcH84gs9PKJw8iykaMUnpZkPU=
2009-01-03 22:25:41,236 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/solutions/IT2BE_gantt/security_info.xml/7lJWl0IWypvh7VEk+Xh0yWEXcXc=
2009-01-03 22:25:41,236 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/solutions/IT2BE_gantt/solution.xml/GNjqrrFB0LsXbjti+UhlCCZBrXc=
2009-01-03 22:25:41,236 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Digest: export/version_info.xml/p3CeQTVMKLWot7PgOif9YYzAQc4=
2009-01-03 22:25:41,236 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - CRC: bDwvKrep5MBEUlzGSUyy1A==
2009-01-03 22:25:41,236 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Got solution id 2735 and solution UUID ed04cb66-afb9-4032-944a-018b69d754d7 for import.
2009-01-03 22:25:41,237 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Got solution name ‘IT2BE_gantt’ for import.
2009-01-03 22:25:41,237 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Importing database information.
2009-01-03 22:25:41,237 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.XMLImportHandlerVersion11 - Got server sample_data for connection ‘sample_data’
2009-01-03 22:25:41,237 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: got managed connection
2009-01-03 22:25:41,310 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name link_type type 12 lenght 10 nullable true
2009-01-03 22:25:41,310 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name link_id type 4 lenght 10 nullable false
2009-01-03 22:25:41,310 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name predecessor_id type 4 lenght 10 nullable true
2009-01-03 22:25:41,310 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name successor_id type 4 lenght 10 nullable true
2009-01-03 22:25:41,312 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,312 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Loading column metainfo for table it2be_link
2009-01-03 22:25:41,312 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,314 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,314 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: got managed connection
2009-01-03 22:25:41,315 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,315 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: getting unmanaged connection
2009-01-03 22:25:41,361 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: got managed connection
2009-01-03 22:25:41,368 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name link_type type 12 lenght 10 nullable true
2009-01-03 22:25:41,368 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name link_id type 4 lenght 10 nullable false
2009-01-03 22:25:41,368 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name predecessor_id type 4 lenght 10 nullable true
2009-01-03 22:25:41,368 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name successor_id type 4 lenght 10 nullable true
2009-01-03 22:25:41,369 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,369 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,371 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,372 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,373 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,374 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: got managed connection
2009-01-03 22:25:41,378 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name parentid type 12 lenght 50 nullable true
2009-01-03 22:25:41,378 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name realcategoriesid type 12 lenght 50 nullable true
2009-01-03 22:25:41,378 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name description type 12 lenght 255 nullable true
2009-01-03 22:25:41,378 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name color type 12 lenght 10 nullable true
2009-01-03 22:25:41,378 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name it2be_event_categoriesid type 4 lenght 10 nullable false
2009-01-03 22:25:41,378 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name label type 12 lenght 50 nullable true
2009-01-03 22:25:41,380 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,380 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Loading column metainfo for table it2be_event_categories
2009-01-03 22:25:41,380 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,381 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,381 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: got managed connection
2009-01-03 22:25:41,382 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,382 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: getting unmanaged connection
2009-01-03 22:25:41,382 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: got managed connection
2009-01-03 22:25:41,385 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name parentid type 12 lenght 50 nullable true
2009-01-03 22:25:41,385 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name realcategoriesid type 12 lenght 50 nullable true
2009-01-03 22:25:41,386 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name description type 12 lenght 255 nullable true
2009-01-03 22:25:41,386 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name color type 12 lenght 10 nullable true
2009-01-03 22:25:41,386 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name it2be_event_categoriesid type 4 lenght 10 nullable false
2009-01-03 22:25:41,386 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Column name label type 12 lenght 50 nullable true
2009-01-03 22:25:41,387 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,387 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,389 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,391 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,392 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,393 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,394 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Created table ‘it2be_task’ in server ‘sample_data’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘end_date’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘information’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘hierarchy_code’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘load’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘task_id’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘task_name’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘resources’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 INFO [TaskExecuter[3]] com.servoy.j2db.util.Debug - Added column with name ‘start_date’ to table ‘it2be_task’.
2009-01-03 22:25:41,395 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: getting unmanaged connection
2009-01-03 22:25:41,396 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,396 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,396 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,398 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,399 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,399 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,399 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,400 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,401 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,401 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,401 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,402 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,402 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,402 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:41,405 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,405 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,405 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:41,406 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,408 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - create table it2be_task (end_date datetime default null, information mediumtext default null, hierarchy_code varchar(50) default null, load integer default null, task_id integer not null, task_name varchar(100) default null, resources varchar(255) default null, start_date datetime default null)
2009-01-03 22:25:41,408 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: getting unmanaged connection
2009-01-03 22:25:41,409 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: got managed connection
2009-01-03 22:25:41,409 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Database name MySQL
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_browser tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_companies tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_contacts tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_currencies tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_decorations tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_event_categories tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_events tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_group tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_htmleditor tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_importscripts tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_join tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_link tableType TABLE
2009-01-03 22:25:41,411 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_media_content tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_office tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_ole_content tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_placeholder tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_progress tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name it2be_word_template tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name mimetypes tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name mimetypes_desc tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name mimetypes_suffix tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table Name sticky tableType TABLE
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - sample_data: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,412 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:41,412 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘load integer default null, task_id integer not null, task_name varchar(100) defa’ at line 1
at com.servoy.j2db.persistence.p.a(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importFromJarFile(Unknown Source)
at com.servoy.j2db.develop.i$6.run(Unknown Source)
at com.servoy.j2db.util.as.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘load integer default null, task_id integer not null, task_name varchar(100) defa’ at line 1
at com.servoy.j2db.persistence.Server.a(Unknown Source)
at com.servoy.j2db.persistence.Server.syncTableObjWithDB(Unknown Source)
at com.servoy.j2db.persistence.p.do(Unknown Source)
… 5 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘load integer default null, task_id integer not null, task_name varchar(100) defa’ at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy1.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183)
… 8 more
2009-01-03 22:25:41,413 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘load integer default null, task_id integer not null, task_name varchar(100) defa’ at line 1

2009-01-03 22:25:43,250 INFO [AWT-EventQueue-0] com.servoy.j2db.util.Debug - size of dialog5 java.awt.Point[x=445,y=430]
2009-01-03 22:25:43,292 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: getting unmanaged connection
2009-01-03 22:25:43,301 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,302 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,302 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,303 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,304 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,305 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,305 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,306 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,306 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,309 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,310 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,311 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,311 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,312 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,312 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,313 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,313 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,315 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,315 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,316 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,316 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,318 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,318 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,319 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,319 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,320 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,321 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,322 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,322 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,329 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,329 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,330 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,331 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,331 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,332 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,333 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,333 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,336 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,342 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,345 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,345 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,346 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,346 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,347 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,347 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,348 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,348 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,348 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,349 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,349 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,349 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,350 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]
2009-01-03 22:25:43,350 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: got managed connection
2009-01-03 22:25:43,351 DEBUG [TaskExecuter[3]] com.servoy.j2db.persistence.Server - repository_server: Closed connection, thread=TaskExecuter[3]

6

Hmm, so the conclusion could be that the column with name ‘load’ is not allowed.

That probably explains as well why I could import the, what I thought was, the same solution in another instance of Servoy. The column is not in that solution…

7

Thank you for the hint Nicola.

After renaming the column ‘load’ to ‘workload’ the issue was gone :)

8

I’m happy to serve you, my Master :)