New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when creating the table process_definition with Act Cloud Query + MariaDB #2275

Closed
grasolondraibe opened this Issue Dec 14, 2018 · 2 comments

Comments

2 participants
@grasolondraibe
Copy link

grasolondraibe commented Dec 14, 2018

2018-12-14 09:39:29.748 WARN [query,,,] 7696 --- [ restartedMain] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table process_definition (id varchar(255) not null, app_name varchar(255), app_version varchar(255), service_full_name varchar(255), service_name varchar(255), service_type varchar(255), service_version varchar(255), description varchar(255), form_key varchar(255), key varchar(255), name varchar(255), version integer not null, primary key (id)) engine=InnoDB" via JDBC Statement

https://github.com/Activiti/activiti-cloud-query-service/blob/develop/activiti-cloud-services-query/activiti-cloud-services-query-model/src/main/java/org/activiti/cloud/services/query/model/ProcessDefinitionEntity.java#L37

@salaboy salaboy added this to Open in Activiti 7.x via automation Dec 14, 2018

@salaboy salaboy added this to the Beta5 milestone Dec 14, 2018

@grasolondraibe

This comment has been minimized.

Copy link

grasolondraibe commented Dec 14, 2018

MariaDB console error

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(255), name varchar(255), version integer not null, primary key (id)) eng' at line 1

With it's ok with script below (the column 'key' is escaped) :

create table process_definition (id varchar(255) not null, app_name varchar(255), app_version varchar(255), service_full_name varchar(255), service_name varchar(255), service_type varchar(255), service_version varchar(255), description varchar(255), form_key varchar(255), `key` varchar(255), name varchar(255), version integer not null, primary key (id))
@salaboy

This comment has been minimized.

Copy link
Member

salaboy commented Dec 14, 2018

@salaboy salaboy closed this Dec 14, 2018

Activiti 7.x automation moved this from Open to Closed Dec 14, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment