topic Re: Exception starting Tomcat with Oracle DB in Activiti-5.0.rc1 in Alfresco Archive

Exception starting Tomcat with Oracle DB in Activiti-5.0.rc1

gerry_fisher — Thu, 04 Nov 2010 13:03:29 GMT

OS: Windows XPActiviti version: 5.0.rc1Tomcat version: 6.0.29Oracle version: 9.1JDBC Driver version: 11.1.0.6.0 (ojdbc5.jar)I have, after some tweaking of setup/build.xml, created a database, which I have named 'ACTIVITI', and populated the ACT_ID_GROUP, ACT_ID_MEMBERSHIP and ACT_ID_USER tables succ

Re: Exception starting Tomcat with Oracle DB in Activiti-5.0.rc1

frederikherema1 — Thu, 04 Nov 2010 13:18:32 GMT

When you call "ant demo.setup", a configuration-file is created, based on the build.properties in the $distro/setup folder. If you set the db property to oracle, and run demo.setup, everything should work out of the box (after having installed oracle jdbc driver in maven, see userguide)

If you are not using the demo setup, you can configure the database in the file activiti.cfg.xml, which is located in the activiti-cfg.jar, which should be somewhere on your classpath, depending on the environnement:

<?xml version="1.0" encoding="UTF-8"?>
<activiti-cfg>
  
  <database type="oracle" schema-strategy="check-version">
    <jdbc url="jdbc:smileysurprised:racle:thin:@localhost:1521:xe"
          driver="racle.jdbc.driver.OracleDriver"
          username="activiti"
          password="activiti" />
  </database>
  
  <job-executor activate="on" />
  
  <mail server="localhost" port="5025" />
  
</activiti-cfg>

Re: Exception starting Tomcat with Oracle DB in Activiti-5.0.rc1

gerry_fisher — Thu, 04 Nov 2010 13:37:55 GMT

Frederik,

Thank you. I ran cfg.create after the demo.setup but forgot to manually deploy activiti-cfg.jar. Problem sorted.

Re: Exception starting Tomcat with Oracle DB in Activiti-5.0.rc1

frederikherema1 — Thu, 04 Nov 2010 13:45:32 GMT

NP, glad to be of service