topic Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1 in Alfresco Archive

Exception deploying activiti-webapp-init in Activiti-5.0.rc1

gerry_fisher — Thu, 04 Nov 2010 15:52:41 GMT

Hello,OS: Windows XPTomcat version: 6.0.29Oracle version: 9iJDBC Driver version: 11.2.0.1.0 (ojdbc5.jar)Here's a snippet of the console dump:04-Nov-2010 15:17:44 org.apache.catalina.startup.HostConfig deployDirectoryINFO: Deploying web application directory activiti-webapp-init04-Nov-2010 15:17:45 o

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

jbarrez — Thu, 04 Nov 2010 18:58:21 GMT

We have tested on oracle XE. Could there be a difference in SQL with 9i ?

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

gerry_fisher — Fri, 05 Nov 2010 09:57:15 GMT

Joram,

I'll test it against Oracle XE to discover if it is a 9i issue alone.

Regards,

Gerry

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

jbarrez — Fri, 05 Nov 2010 13:47:14 GMT

Thanks, that would be awesome if you could investigate that!

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

thilka — Mon, 08 Nov 2010 13:30:33 GMT

Hello,

I think we had a similar issue. We are also running on Windows, and in the sql script files (under org.activiti.db.create) for h2 contained a blank line at the end of the file which caused the error.

Can you try to unpack the sql script files from there, remove the blank line and add it to your classpath infront of the activiti.jar file.

Tobias

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

jbarrez — Mon, 08 Nov 2010 15:28:18 GMT

Interesting finding.

Our QA however, runs on Windows. So it should catch those errors.
If it does is a bug, can you file a Jira describing how to reproduce it ?

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

thilka — Tue, 09 Nov 2010 09:41:09 GMT

Tried to reproduce the problem: Our mistake.

We used HSQL database for testing, not H2. So, when we tried to create the schema using dbSchemaStrategy drop-create on the HSQL database (but with databaseType h2), we ran into this error.

We are using H2 from now on and so far, we did not find any problems.
But for schema creation, we use Liquibase(liquibase.org, Apache Licenced) since we need to support many databases and do not want to write the SQL statements for every different database. And we also create the activiti schema using Liquibase. So we don't really execute your SQL scripts.

Tobias

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

jbarrez — Tue, 09 Nov 2010 17:19:25 GMT

Thanks for posting it Tobias. Glad that the issue was not in the engine 🙂

Re: Exception deploying activiti-webapp-init in Activiti-5.0.rc1

gerry_fisher — Thu, 11 Nov 2010 16:39:51 GMT

Okay Joram,

This seems to be a bug in ojdbc5.jar which I discovered at http://forums.oracle.com/forums/thread.jspa?threadID=549705&tstart=-2 . I replaced ojdbc5.jar by ojdbc6.jar and everything is fine. I have checked the Tomcat logs and also launched the application. However, I haven't tried running ojdbc6.jar for Oracle XE.

build.xml target 'db.oracle.install.driver' contains hard-coded values for artifact-id, jar-name and version. I feel these values should be removed and put in build.oracle.properties

Regards,

Gerry Fisher