nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

comparability error with MySQL version 5.6.31

skverma02

hello sir i m using activiti 5.19.0 and mysql version 5.6.31

database connectiviti code in db.properties is

db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti
jdbc.username=root
jdbc.password=kare@123

but when i m deploy the process its give error.

### Error querying database. Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
### The error may exist in org/activiti/db/mapping/entity/Deployment.xml
### The error may involve org.activiti.engine.impl.persistence.entity.DeploymentEntity.selectDeploymentById-Inline
### The error occurred while setting parameters
### SQL: select * from ACT_RE_DEPLOYMENT where ID_ = ?
### Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)
   at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:451)
   at org.activiti.engine.impl.persistence.entity.DeploymentEntityManager.findDeploymentById(DeploymentEntityManager.java:194)
   at org.activiti.engine.impl.persistence.deploy.DeploymentManager.resolveProcessDefinition(DeploymentManager.java:160)
   at org.activiti.engine.impl.persistence.deploy.DeploymentManager.findDeployedProcessDefinitionById(DeploymentManager.java:77)
   at org.activiti.engine.impl.cmd.GetDeploymentProcessDefinitionCmd.execute(GetDeploymentProcessDefinitionCmd.java:36)
   at org.activiti.engine.impl.cmd.GetDeploymentProcessDefinitionCmd.execute(GetDeploymentProcessDefinitionCmd.java:26)
   at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
   at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
   at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
   at org.activiti.engine.impl.RepositoryServiceImpl.getProcessDefinition(RepositoryServiceImpl.java:130)
   at org.activiti.explorer.ui.process.AbstractProcessDefinitionDetailPanel.<init>(AbstractProcessDefinitionDetailPanel.java:77)
   at org.activiti.explorer.ui.process.ProcessDefinitionDetailPanel.<init>(ProcessDefinitionDetailPanel.java:46)
   at org.activiti.explorer.ui.process.ProcessDefinitionPage.showProcessDefinitionDetail(ProcessDefinitionPage.java:129)
   at org.activiti.explorer.ui.process.ProcessDefinitionPage$1.valueChange(ProcessDefinitionPage.java:114)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
   … 37 more
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
   at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:6659)
   at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:5314)
   at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2324)
   at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2356)
   at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300)
   at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300)
   at org.apache.ibatis.type.DateTypeHandler.getNullableResult(DateTypeHandler.java:36)
   at org.apache.ibatis.type.DateTypeHandler.getNullableResult(DateTypeHandler.java:25)
   at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:51)
   at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:397)
   at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:371)
   at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:341)
   at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:294)
   at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:269)
   at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:239)
   at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:153)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:57)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
   at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
   … 63 more

please help….??

Find more posts tagged with

Comments

skverma02

database configuration with mysql 5.6.31 and activiti 5.19.0
db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti?autoReconnect=true
jdbc.username=root
jdbc.password=healthcloud#1

this is full error ..

com.vaadin.event.ListenerMethod$MethodException: Invocation of method uploadFinished in org.activiti.explorer.ui.custom.ImportComponent failed.
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:530)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1219)
at com.vaadin.ui.Upload.fireUploadInterrupted(Upload.java:731)
at com.vaadin.ui.Upload$1.streamingFailed(Upload.java:1037)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.streamToReceiver(AbstractCommunicationManager.java:619)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleSimpleMultipartFileUpload(AbstractCommunicationManager.java:476)
at com.vaadin.terminal.gwt.server.CommunicationManager.handleFileUpload(CommunicationManager.java:259)
at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:495)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.activiti.explorer.filter.ExplorerFilter.doFilter(ExplorerFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.vaadin.event.ListenerMethod$MethodException: Invocation of method valueChange in org.activiti.editor.ui.EditorProcessDefinitionPage$1 failed.
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:530)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1219)
at com.vaadin.ui.AbstractField.fireValueChange(AbstractField.java:897)
at com.vaadin.ui.AbstractField.setValue(AbstractField.java:529)
at com.vaadin.ui.AbstractSelect.setValue(AbstractSelect.java:676)
at com.vaadin.ui.AbstractSelect.setValue(AbstractSelect.java:645)
at com.vaadin.ui.Table.setValue(Table.java:3572)
at com.vaadin.ui.AbstractSelect.select(AbstractSelect.java:1422)
at org.activiti.editor.ui.EditorProcessDefinitionPage.initUi(EditorProcessDefinitionPage.java:74)
at org.activiti.explorer.ui.AbstractPage.attach(AbstractPage.java:43)
at com.vaadin.ui.AbstractComponent.setParent(AbstractComponent.java:560)
at com.vaadin.ui.AbstractComponentContainer.addComponent(AbstractComponentContainer.java:211)
at com.vaadin.ui.CssLayout.addComponent(CssLayout.java:95)
at org.activiti.explorer.ui.mainlayout.MainLayout.setMainContent(MainLayout.java:58)
at org.activiti.explorer.ui.MainWindow.switchView(MainWindow.java:79)
at org.activiti.explorer.DefaultViewManager.switchView(DefaultViewManager.java:347)
at org.activiti.explorer.DefaultViewManager.showEditorProcessDefinitionPage(DefaultViewManager.java:219)
at org.activiti.editor.ui.ImportUploadReceiver.showUploadedDeployment(ImportUploadReceiver.java:149)
at org.activiti.editor.ui.ImportUploadReceiver.uploadFinished(ImportUploadReceiver.java:82)
at org.activiti.explorer.ui.custom.ImportComponent.uploadFinished(ImportComponent.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
… 32 more
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
### The error may exist in org/activiti/db/mapping/entity/Model.xml
### The error may involve org.activiti.engine.impl.persistence.entity.ModelEntity.selectModel-Inline
### The error occurred while setting parameters
### SQL: select * from ACT_RE_MODEL where ID_ = ?
### Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)
at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:451)
at org.activiti.engine.impl.persistence.entity.ModelEntityManager.findModelById(ModelEntityManager.java:132)
at org.activiti.engine.impl.cmd.GetModelCmd.execute(GetModelCmd.java:36)
at org.activiti.engine.impl.cmd.GetModelCmd.execute(GetModelCmd.java:26)
at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
at org.activiti.engine.impl.RepositoryServiceImpl.getModel(RepositoryServiceImpl.java:236)
at org.activiti.editor.ui.EditorProcessDefinitionDetailPanel.<init>(EditorProcessDefinitionDetailPanel.java:103)
at org.activiti.editor.ui.EditorProcessDefinitionPage.showProcessDefinitionDetail(EditorProcessDefinitionPage.java:130)
at org.activiti.editor.ui.EditorProcessDefinitionPage$1.valueChange(EditorProcessDefinitionPage.java:108)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
… 57 more
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:6659)
at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:5314)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2324)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2356)
at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300)
at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300)
at org.apache.ibatis.type.DateTypeHandler.getNullableResult(DateTypeHandler.java:36)
at org.apache.ibatis.type.DateTypeHandler.getNullableResult(DateTypeHandler.java:25)
at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:51)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:397)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:371)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:341)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:294)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:269)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:239)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:153)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:57)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
… 80 more

skverma02

any one please reply ,…?

opentexter

I think this problem lies in your process. The error mentions a timestamp, I have been able to produce something similar by setting a 0 time in a start timer event (also using a MySQL backend). Or does this appear for all processes? Can you send a screen capture or .bpmn20.xml?

skverma02

thanx for reply ,

this workflow deply and work properly with mysql 5. 5.47 and activiti 5.19.0 only problem with mysql5.6.31 and activiti 5.19.0.

also i m not create a new workflow in activti5.19.0 with mysql5.6.31.

this my .bpmn20.xml is bellow consutation.txt

consultation.txt.zip

skverma02

with myql 5.6.31 when i m deploy though activiti explorer
procresses -> model workspce -> import

following error come

### Error quering database. Cause:java.sql.SQLException:value '000-00-00' can not be represented as javasql.Timestamp ### the error may exist in org/activiti/db/activiti/db/mapping/entity/Model.xml ### the error may involve org.activiti.engine.impl.persistence.entity.ModelEntity.selectModel-inline ### The error occured while setting parameters # SQL:select * from ACT_RE_MODEL where ID_=? ### Cause:java.sql.SQLException:value '000-00-00' can not be represented as javasql.Timestamp

and with myql 5.6.31 when i m create though activiti explorer
procresses -> model workspce -> new model
following error come
No message found under code 'error' for local 'en_US'

jbarrez

We always recommend mysql 5.6 at least, because 5.5 has some timestamp issues (i think it didn't store millisecond precision)

We do have scripts in there for 5.5, but I think these are not tested as much as the 5.6+.
So you are simply booting Explorer on mysql 5.5 when you get this exception?

skverma02

hello every one problem is solved.
actually i was using tomcat version 7.0.59 with activiti 5.19.0 and mysql5.6.31 then it give above error.
when i m using tomcat version8.0.23 with activiti 5.19.0 and mysql5.6.31 its work prperly.
thank you for suggestion.

jbarrez

hmm, that sounds odd … that combination should work.
Anyway, glad it's working for you now.

skverma02

yes sir ,
thank you for help.