As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
SCHWERWIEGEND: Error while closing command context org.apache.ibatis.exceptions.PersistenceException: ### Error opening session. Cause: org.h2.jdbc.JdbcSQLException: Verbindung ist unterbrochen: "session closed" Connection is broken: "session closed" [90067-132] ### The error may exist in org/activiti/db/ibatis/variable.mapping.xml ### The error occurred while processing mapper_resultMap[byteArrayResultMap_postgres] ### Cause: org.h2.jdbc.JdbcSQLException: Verbindung ist unterbrochen: "session closed" Connection is broken: "session closed" [90067-132] at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8) at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:32)
<br>ant demo.clean cfg.create demo.start<br>
Hi,Try running this, to get the new configuration-jar build and copied to the REST-webapp (containing the new MySQL config):<br>ant demo.clean cfg.create demo.start<br>
<br>internal.db.install.h2:<br><br>internal.db.install.h2.unnecessary:<br> [echo] H2 is already installed<br><br>internal.db.install.unsupported:<br> [echo] Automatic installation of mysql DB not supported. It is assumed to be installed and running<br><br>h2.install:<br><br>internal.classpath.libs:<br><br>internal.taskdef.launch:<br><br>h2.start:<br><br>db.create:<br> [echo] creating db<br><br>internal.classpath.libs:<br><br>internal.classpath.libs:<br><br>internal.db.create.engine:<br> [sql] Executing resource: org/activiti/db/create/activiti.mysql.create.sql<br> [sql] Failed to execute: create table ACT_GE_PROPERTY ( NAME_ varchar(64), VALUE_ varchar(300), REV_ integer, primary key (NAME_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin<br><br>BUILD FAILED<br>C:\projects\activiti-5.2\setup\build.xml:155: The following error occurred while executing this line:<br>C:\projects\activiti-5.2\setup\build.xml:195: The following error occurred while executing this line:<br>C:\projects\activiti-5.2\setup\build.xml:205: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'act_ge_property' already exists<br> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br>
<br>mysql> create database activiti;<br>Query OK, 1 row affected (0.02 sec)<br><br>mysql> grant all on activiti.* to 'activiti'@'localhost' identified by 'activiti' with grant option;<br>Query OK, 0 rows affected (0.00 sec)<br><br>mysql> grant all on activiti.* to 'activiti'@'localhost.localdomain' identified by 'activiti' with grant option;<br>Query OK, 0 rows affected (0.00 sec)<br><br>mysql><br>
