topic Re: Alfresco 3.4a on Meerkat in Alfresco Archive

Alfresco 3.4a on Meerkat

nickswift — Fri, 15 Oct 2010 01:36:46 GMT

First off, the good news. I took a vanilla build of Maverick Meerkat Server (64 bit) and followed various instructions to get Alfresco 3.4a working using the Alfresco installer i.e. stock Tomcat, mysql, JRE.After a bit of fiddling, I had everything working. I could login, upload documents, send emai

Re: Alfresco 3.4a on Meerkat

janv — Fri, 15 Oct 2010 12:27:48 GMT


….
Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [org.jbpm.graph.def.ProcessDefinition]; SQL [insert into JBPM_PROCESSDEFINITION (NAME_, DESCRIPTION_, VERSION_, ISTERMINATIONIMPLICIT_, STARTSTATE_, CLASS_) values (?, ?, ?, ?, ?, 'P')]; nested exception is org.hibernate.exception.DataException: could not insert: [org.jbpm.graph.def.ProcessDefinition]
….
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'ISTERMINATIONIMPLICIT_' at row 1
….
‍‍‍‍‍‍‍

Does the following link help to narrow down your issue … ?

http://java.itags.org/java-open-source/196749/

It might be worth double-checking your JDBC driver version etc.

Thanks,
Jan

Re: Alfresco 3.4a on Meerkat

nickswift — Sun, 17 Oct 2010 07:14:50 GMT

Yes. That did it.

I discovered two things:

1) I had installed mysql from Meerkat (hence the first error)
2) The JDBC driver needs updating to match.

Nick