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

[gerry_fisher]

Hello,

OS: Windows XP
Tomcat version: 6.0.29
Oracle version: 9i
JDBC 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 deployDirectory
INFO: Deploying web application directory activiti-webapp-init
04-Nov-2010 15:17:45 oracle.jdbc.driver.OracleDriver registerMBeans
SEVERE: Error while registering Oracle JDBC Diagnosability MBean.
javax.management.MalformedObjectNameException: Invalid character '
' in value part of property
        at javax.management.ObjectName.construct(ObjectName.java:602)
        at javax.management.ObjectName.<init>(ObjectName.java:1403)
        at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:303)
        at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:213)
        at java.security.AccessController.doPrivileged(Native Method)
        at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:209)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:247)
        at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.initializeDriver(UnpooledDataSource.java:173)
        at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:57)
        at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:349)
        at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:55)
        at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:72)
        at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:40)
        at org.activiti.engine.impl.db.DbSqlSessionFactory.dbSchemaCheckVersion(DbSqlSessionFactory.java:229)
        at org.activiti.engine.impl.ProcessEngineImpl.performSchemaOperationsCreate(ProcessEngineImpl.java:102)
        at org.activiti.engine.impl.ProcessEngineImpl$1.execute(ProcessEngineImpl.java:70)
        at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:22)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:36)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
        at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:68)
        at org.activiti.engine.impl.cfg.ProcessEngineConfiguration.buildProcessEngine(ProcessEngineConfiguration.java:302)
        at org.activiti.engine.ProcessEngineBuilder.buildProcessEngine(ProcessEngineBuilder.java:272)
        at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.java:150)
        at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(ProcessEngines.java:124)
        at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:83)
        at org.activiti.impl.servlet.listener.ProcessEnginesServletContextListener.contextInitialized(ProcessEnginesServletContextListener.java:30)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I'm not sure which property contains the rogue ' character. It is nothing in the build.oracle.properties file. Could this be some Oracle SQL dialect issue?

Regards,

Gerry

[jbarrez]

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

[gerry_fisher]

Joram,

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

Regards,

Gerry

[jbarrez]

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

[thilka]

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

[jbarrez]

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 ?

[thilka]

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

[jbarrez]

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

[gerry_fisher]

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