title: SQL syntax error when starting OW2 Orchestra
body: <p>I've recently downloaded OW2 orchestra. In the user manual, after complying with the overall configuration steps (I'm using <strong>mySQL</strong> as my DB. The other configuration are the default ones, including the hibernate use) , I've reached the instructions to finally start it:</p>
  
  <blockquote>
    <p>Orchestra is a webapp that can be deployed on Tomcat. So starting
    Orchestra in fact starts Tomcat with the correct environment. This can
    be performed from the installation directory with the following
    command line :</p>
    
    <blockquote>
      <p>cd orchestra-cxf-tomcat-4.9.0 >ant start</p>
    </blockquote>
  </blockquote>
  
  <p>When using this command, however, I get some errors related to SQL sintax(?). These are the log relevant exceperts:</p>
  
  <pre><code>     [echo] Starting orchestra
       [java] 19:57:34,152 WARN  [SoapUI] Missing folder [C:\Users\Victor\Documents\Orchestra\.\ext] for external libraries
       [java] 19:57:34,501 WARN  [DefaultSoapUICore] Failed to load settings from [C:\Users\Victor\Documents\Orchestra\tomcat\temp\gwt-soapui\soapui-settings.xml:1:1: error: Unexpected end of file after null], creating new
       [java] log4j:WARN No appenders could be found for logger (org.granite.config.GraniteConfigListener).
       [java] log4j:WARN Please initialize the log4j system properly.
       [java] [INFO] Started bridged http service
       [java] nov 13, 2016 7:57:48 PM org.ow2.orchestra.StartupListener contextInitialized
       [java] INFORMAÇÕES: OSGi framework started
       [java] nov 13, 2016 7:57:52 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
       [java] GRAVE: Unsuccessful: create table DEF_ACTIVITY (DBID_ bigint not null, CLASS_ varchar(255) not null, NAME_ varchar(255), UUID_ varchar(500), CHILD_NODE_ bigint, FAULT_QNAME_ varchar(255), catchVariableDefinition bigint, IS_DEFAULT_CH_ bit, DEL_JOIN_FAIL_ bit, EXEC_SRC_ASYNC bit, SCOPE_ bigint, TARG_JOIN_COND_ bigint, EXT_ACTIVITY_NAME varchar(255), EXT_ACTIVITY_ID bigint, PARTNER_LINK_ varchar(255), OPERATION_NAME_ varchar(255), IN_VAR_NAME_ varchar(255), OUT_VAR_NAME_ varchar(255), ONE_WAY_ bit, PT_QNAME_ varchar(255), ANON_OUT_MESS_ bigint, ANON_IN_MESS_ bigint, MSG_TYPE_QNAME_ varchar(255), MSG_EXCHANGE_ varchar(255), CREATE_INST_ bit, OP_KEY_ varchar(3999), INPUT_TYPE_ varchar(255), VALIDATE_ bit, ISOLATED_ bit, EXIT_ON_FAULT_ bit, NODE_ bigint, COND_ bigint, ACTIVITY_ bigint, ELSE_ACTIVITY_ bigint, COUNTER_NAME_ varchar(255), PARALLEL_ bit, SUC_BRANCHES_ bit, START_COUNT_ bigint, FINAL_COUNT_ bigint, COMPL_COND_ bigint, DURATION_ bigint, DEADLINE_ bigint, FAULT_VAR_ varchar(255), TARGET_ varchar(255), INBOUND_PROCESS_ bigint, EXT_PROCESS_ bigint, primary key (DBID_)) ENGINE=InnoDB
       [java] nov 13, 2016 7:57:52 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
       [java] GRAVE: Syntax error in SQL statement "CREATE TABLE DEF_ACTIVITY (DBID_ BIGINT NOT NULL, CLASS_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), UUID_ VARCHAR(500), CHILD_NODE_ BIGINT, FAULT_QNAME_ VARCHAR(255), CATCHVARIABLEDEFINITION BIGINT, IS_DEFAULT_CH_ BIT, DEL_JOIN_FAIL_ BIT, EXEC_SRC_ASYNC BIT, SCOPE_ BIGINT, TARG_JOIN_COND_ BIGINT, EXT_ACTIVITY_NAME VARCHAR(255), EXT_ACTIVITY_ID BIGINT, PARTNER_LINK_ VARCHAR(255), OPERATION_NAME_ VARCHAR(255), IN_VAR_NAME_ VARCHAR(255), OUT_VAR_NAME_ VARCHAR(255), ONE_WAY_ BIT, PT_QNAME_ VARCHAR(255), ANON_OUT_MESS_ BIGINT, ANON_IN_MESS_ BIGINT, MSG_TYPE_QNAME_ VARCHAR(255), MSG_EXCHANGE_ VARCHAR(255), CREATE_INST_ BIT, OP_KEY_ VARCHAR(3999), INPUT_TYPE_ VARCHAR(255), VALIDATE_ BIT, ISOLATED_ BIT, EXIT_ON_FAULT_ BIT, NODE_ BIGINT, COND_ BIGINT, ACTIVITY_ BIGINT, ELSE_ACTIVITY_ BIGINT, COUNTER_NAME_ VARCHAR(255), PARALLEL_ BIT, SUC_BRANCHES_ BIT, START_COUNT_ BIGINT, FINAL_COUNT_ BIGINT, COMPL_COND_ BIGINT, DURATION_ BIGINT, DEADLINE_ BIGINT, FAULT_VAR_ VARCHAR(255), TARGET_ VARCHAR(255), INBOUND_PROCESS_ BIGINT, EXT_PROCESS_ BIGINT, PRIMARY KEY (DBID_)) ENGINE=[*]INNODB "; expected "identifier"; SQL statement:
       [java] create table DEF_ACTIVITY (DBID_ bigint not null, CLASS_ varchar(255) not null, NAME_ varchar(255), UUID_ varchar(500), CHILD_NODE_ bigint, FAULT_QNAME_ varchar(255), catchVariableDefinition bigint, IS_DEFAULT_CH_ bit, DEL_JOIN_FAIL_ bit, EXEC_SRC_ASYNC bit, SCOPE_ bigint, TARG_JOIN_COND_ bigint, EXT_ACTIVITY_NAME varchar(255), EXT_ACTIVITY_ID bigint, PARTNER_LINK_ varchar(255), OPERATION_NAME_ varchar(255), IN_VAR_NAME_ varchar(255), OUT_VAR_NAME_ varchar(255), ONE_WAY_ bit, PT_QNAME_ varchar(255), ANON_OUT_MESS_ bigint, ANON_IN_MESS_ bigint, MSG_TYPE_QNAME_ varchar(255), MSG_EXCHANGE_ varchar(255), CREATE_INST_ bit, OP_KEY_ varchar(3999), INPUT_TYPE_ varchar(255), VALIDATE_ bit, ISOLATED_ bit, EXIT_ON_FAULT_ bit, NODE_ bigint, COND_ bigint, ACTIVITY_ bigint, ELSE_ACTIVITY_ bigint, COUNTER_NAME_ varchar(255), PARALLEL_ bit, SUC_BRANCHES_ bit, START_COUNT_ bigint, FINAL_COUNT_ bigint, COMPL_COND_ bigint, DURATION_ bigint, DEADLINE_ bigint, FAULT_VAR_ varchar(255), TARGET_ varchar(255), INBOUND_PROCESS_ bigint, EXT_PROCESS_ bigint, primary key (DBID_)) ENGINE=InnoDB [42001-144]
       [java] nov 13, 2016 7:57:52 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
       [java] GRAVE: Unsuccessful: create table DEF_COPY_ELT (DBID_ bigint not null, KEEP_SRC_ELT_ bit, IGNORE_MISS_DATA_ bit, FROM_ bigint, TO_ bigint, INVOKE_IN_ID_ bigint, INDEX_ integer, INVOKE_OUT_ID_ bigint, REPLY_ID_ bigint, RECEIVE_IN_ID_ bigint, ASSIGN_ID_ bigint, ASSIGN_INDEX_ integer, ON_MSG_IN_ID_ bigint, ON_EVT_IN_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB
       [java] nov 13, 2016 7:57:52 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
  </code></pre>
  
  <p>Pay attention to the lines starting with <strong>GRAVE</strong>.</p>
  
  <p>These are my MySQL config in <strong>hibernate.properties</strong>:</p>
  
  <pre><code>hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
  hibernate.connection.driver_class=com.mysql.jdbc.Driver
  hibernate.connection.url=jdbc\:h2\:file\:/tmp/orchestra-db/orchestra_core.db 
  hibernate.connection.username=root@localhost
  hibernate.connection.password=8ct8b&amp;r
  </code></pre>
  
  <p>Could someone please provide some help?</p>
  
  <p>(PS: It seems to me that Orchestra is discontinued. I'm only using it because it is a mandatory college job).</p>