Activiti on Websphere 7?

[johnnybravo]

Hello,

I haven't found any helpful answers yet about my problem so I'm asking for help.

I tried to install Activiti on Websphere 7 using H2 and Oracle databases (separately).

Neither of these worked, altough in Tomcat everything works.

I copied all needed libs to Websphere's lib folder.

The error is in case of H2: "session-ended" (H2 is up and running)

And in the case of Oracle: "TNS:no appropriate service handler found" (Oracle is up and running)

Do I maybe have to define a Datasource in Websphere and Activiti? Or something else?


Thanks for any help

[trademak]

Hi,

Did you install the Activiti Explorer or did you build a custom web application?
How did you configure the Activiti engine in the activiti.cfg.xml or equivalent file?
When running on WebSphere it would definitely make sense to use a JNDI datasource.

Best regards,

[johnnybravo]

I first installed Activiti Explorer on Tomcat. Then I went to tomcat's webapps folder and found activiti-explorer folder.

Then I entered inside it and in command promt entered "jar -cvf activiti-explorer.war *".

That made me a war file of activiti explorer that's deployable on websphere.

Then before deploying, I would change activiti-explorer.war/WEB-INF/classes/db.properties file to represent my db settings.

I have made Datasource on my Websphere 7 instance. But I am not sure when in the process and where exactly am I supposed to define Datasource in activiti.

Is there an easier or better way to achieve this?

When should I change the activiti.cfg.xml file?


Thanks for help

[johnnybravo]

I've made some progress and now I can run activiti explorer on Websphere except for opening Manage tab.

I build activiti for tomcat first. Then I pack activiti-explorer.war folder from setup/build/webapps into activiti-explorer.war file.

Then with 7Zip open war file and open WEB-INF/applicationContext.xml.

Comment this part out:
<!–
  <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="driverClassName" value="${jdbc.driver}" />
    <property name="url" value="${jdbc.url}" />
    <property name="username" value="${jdbc.username}" />
    <property name="password" value="${jdbc.password}" />
    <property name="defaultAutoCommit" value="false" />
  </bean>
  –>and add this part:

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName"><value>jdbc/activitiXA</value></property>
</bean>
where "jdbc/activitiXA" is the name of JNDI data source that I have defined on Websphere following their Guided Activities -> Connecting to database (link in web console of server).

Note that I have added every lib that websphere asked with ClassNotFound errors (one by one to be sure).

Now deploy activiti-explorer.war to websphere and start it.

Go to http://localhost:9080/activiti-explorer and first time you will see some error with description null.

When you refresh page login screen appears and you can login with kermit without problems.

As far as I've seen Tasks and Process tabs works altough I currently don't have any data in them (I'll test it out soon).

Before doing this, I have deleted all ACT_… tables from my Oracle database and upon starting Activiti created schema and data inside.

But when I click on Manage tab you can see that it is working something and after some time little red circle appears next to Manage tab label saying StackOverflowError.

Now, it seems to me when I look at the details like that something is looping again and again until websphere runs out of memory.

There is a picture of an error attached.

Do you know what is the cause of this problem? Can it be fixed?

Thank you