OFBiz › OFBiz - User

Ofbiz WorkFlow Engine

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

47 messages Options

123

BJ Freeman

Re: Ofbiz WorkFlow Engine

was able to connect and got to
http://langhua.org/opensource/ofbiz/ofbiz-jbpm/trunk/

=========================
BJ Freeman <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr33man

Shi Jinghai sent the following on 9/9/2010 6:09 AM:

> oh, my fault.
> svn:
> http://langhua.org/opensource/ofbiz/ofbiz-jbpm/
>
> viewvc:
> http://langhua.org/viewvc/opensource/ofbiz/ofbiz-jbpm/
>
>
> 在 2010-09-09四的 16:54 +0530，Deepa Priolkar写道：
>> Hi Shi,
>>
>> Can you please help me to download the code from the location mentioned below? I tried FTP it did not work. Please advice.
>>
>>
>> On 9/7/10 5:51 AM, Shi Jinghai wrote:
>>> Here is a OFBiz-jBPM component:
>>> <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
>>> 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
>>>
>>> As Tom has left jboss and go to Alfresco, I'm not sure what's the future
>>> of jBPM.
>>>
>>> OSWorkflow can also work with OFBiz.
>>>
>>> Personally I like jBPM.
>>>
>>> Regards,
>>>
>>> Shi Jinghai/Beijing Langhua Ltd.
>>>
>>>
>>> åœ¨ 2010-09-07äºŒçš„ 14:47 +0530ï¼ŒDeepa Priolkarå†™é“ï¼š
>>>> Hi Varun,
>>>>
>>>> Yes I am looking for something similar to JBPM, not fullfledge but
>>>> atleast it should have the configuration through XML (similar to Shark).
>>>> Do we have something like this in Ofbiz integrated? If not, then has
>>>> anyone integrated any webflows in Ofbiz? Please let me know..
>>>>
>>>> Regards,
>>>> Deepa
>>>>
>>>> -----Original Message-----
>>>> From: varun bhansaly [mailto:[hidden email]]
>>>> Sent: Tuesday, September 07, 2010 1:38 PM
>>>> To: [hidden email]
>>>> Subject: Re: Ofbiz WorkFlow Engine
>>>>
>>>> Hi Deepa,
>>>> Are you looking at something like designing the process flow, for eg as
>>>> in
>>>> jBPM workflow engine& the process designer ?
>>>> Though processes could be implemented using SECAs, EECAs etc.
>>>>
>>>>
>>>> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
>>>> <[hidden email]>wrote:
>>>>
>>>>> Thanks Varun for replying.. I have checked this link but its talking
>>>>> about XPDL which actually comes with Shark implementation and in the
>>>>> same link they have mentioned that Shark is not yet implemented in
>>>>> Ofbiz. The alternative is event based. SO does this mean we don't have
>>>>> workflow definition type of design in Ofbiz as of now other then the
>>>>> events?
>>>>>
>>>>> Thanks,
>>>>> Deepa
>>>>>
>>>>> -----Original Message-----
>>>>> From: varun bhansaly [mailto:[hidden email]]
>>>>> Sent: Monday, September 06, 2010 9:57 PM
>>>>> To: [hidden email]
>>>>> Subject: Re: Ofbiz WorkFlow Engine
>>>>>
>>>>> Hi,
>>>>> This document might help http://ofbiz.apache.org/docs/workflow.html
>>>>>
>>>>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
>>>>> <[hidden email]>wrote:
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>>
>>>>>>
>>>>>> Need some help to know if we have any workflow integrated in ofbiz
>>>>> 9.04
>>>>>> version?
>>>>>>
>>>>>> if we already have the workflow is it using xpdl? Is it Shark
>>>>> workflow?
>>>>>> Please let me know.. need this urgently before i start designing for
>>>>> one
>>>>>> of my requirement.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Appreciate your help.
>>>>>>
>>>>>>
>>>>>> Thanks& Regards,
>>>>>>
>>>>>> Deepa
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>> ========================================================================
>>>>> ====================================================Disclaimer:
>>>>>> This message and the information contained herein is proprietary
>>>> and
>>>>>> confidential and subject to the Tech Mahindra policy statement, you
>>>>> may
>>>>>> review the policy at<a
>>>>> href="http://www.techmahindra.com/Disclaimer.html
>>>>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>>>>> href="
>>>>>> http://tim.techmahindra.com/Disclaimer.html">
>>>>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
>>>> Tech
>>>> Mahindra.===============================================================
>>>>> =============================================================
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Varun Bhansaly
>>>>>
>>>>>
>>>> ========================================================================
>>>> ====================================================Disclaimer:
>>>>> This message and the information contained herein is proprietary and
>>>>> confidential and subject to the Tech Mahindra policy statement, you
>>>> may
>>>>> review the policy at<a
>>>> href="http://www.techmahindra.com/Disclaimer.html
>>>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>>>> href="
>>>>> http://tim.techmahindra.com/Disclaimer.html">
>>>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
>>>>>
>>>> Mahindra.===============================================================
>>>> =============================================================
>>>>
>>>>
>>>
>>
>> ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at<a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and<a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
>
>

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

Hi Shi,

I have checked out the code for the JBPM from the svn, had some queries regarding integrating the same with ofbiz.

in one of the steps that is mentioned is
to Run ofbiz.copy in ??project OFBiz-jBPM and ?OFBiz-HtmlReport, the two components will be deployed to ${ofbiz.home}/specialpurpose/jbpm/and ?${ofbiz.home}/specialpurpose/htmlreport/.

Now here i did not find any script with the name ofbiz.copy, so should i copy paste the two projects in specialpurpose manually?

Regards,
Deepa

-----Original Message-----
From: BJ Freeman [mailto:[hidden email]]
Sent: Thu 9/9/2010 6:59 PM
To: [hidden email]
Subject: Re: Ofbiz WorkFlow Engine

was able to connect and got to
http://langhua.org/opensource/ofbiz/ofbiz-jbpm/trunk/

=========================
BJ Freeman <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr33man

Shi Jinghai sent the following on 9/9/2010 6:09 AM:

> oh, my fault.
> svn:
> http://langhua.org/opensource/ofbiz/ofbiz-jbpm/
>
> viewvc:
> http://langhua.org/viewvc/opensource/ofbiz/ofbiz-jbpm/
>
>
> ? 2010-09-09?? 16:54 +0530,Deepa Priolkar??:
>> Hi Shi,
>>
>> Can you please help me to download the code from the location mentioned below? I tried FTP it did not work. Please advice.
>>
>>
>> On 9/7/10 5:51 AM, Shi Jinghai wrote:
>>> Here is a OFBiz-jBPM component:
>>> <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
>>> 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
>>>
>>> As Tom has left jboss and go to Alfresco, I'm not sure what's the future
>>> of jBPM.
>>>
>>> OSWorkflow can also work with OFBiz.
>>>
>>> Personally I like jBPM.
>>>
>>> Regards,
>>>
>>> Shi Jinghai/Beijing Langhua Ltd.
>>>
>>>
>>> åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té"ï¼s
>>>> Hi Varun,
>>>>
>>>> Yes I am looking for something similar to JBPM, not fullfledge but
>>>> atleast it should have the configuration through XML (similar to Shark).
>>>> Do we have something like this in Ofbiz integrated? If not, then has
>>>> anyone integrated any webflows in Ofbiz? Please let me know..
>>>>
>>>> Regards,
>>>> Deepa
>>>>
>>>> -----Original Message-----
>>>> From: varun bhansaly [mailto:[hidden email]]
>>>> Sent: Tuesday, September 07, 2010 1:38 PM
>>>> To: [hidden email]
>>>> Subject: Re: Ofbiz WorkFlow Engine
>>>>
>>>> Hi Deepa,
>>>> Are you looking at something like designing the process flow, for eg as
>>>> in
>>>> jBPM workflow engine& the process designer ?
>>>> Though processes could be implemented using SECAs, EECAs etc.
>>>>
>>>>
>>>> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
>>>> <[hidden email]>wrote:
>>>>
>>>>> Thanks Varun for replying.. I have checked this link but its talking
>>>>> about XPDL which actually comes with Shark implementation and in the
>>>>> same link they have mentioned that Shark is not yet implemented in
>>>>> Ofbiz. The alternative is event based. SO does this mean we don't have
>>>>> workflow definition type of design in Ofbiz as of now other then the
>>>>> events?
>>>>>
>>>>> Thanks,
>>>>> Deepa
>>>>>
>>>>> -----Original Message-----
>>>>> From: varun bhansaly [mailto:[hidden email]]
>>>>> Sent: Monday, September 06, 2010 9:57 PM
>>>>> To: [hidden email]
>>>>> Subject: Re: Ofbiz WorkFlow Engine
>>>>>
>>>>> Hi,
>>>>> This document might help http://ofbiz.apache.org/docs/workflow.html
>>>>>
>>>>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
>>>>> <[hidden email]>wrote:
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>>
>>>>>>
>>>>>> Need some help to know if we have any workflow integrated in ofbiz
>>>>> 9.04
>>>>>> version?
>>>>>>
>>>>>> if we already have the workflow is it using xpdl? Is it Shark
>>>>> workflow?
>>>>>> Please let me know.. need this urgently before i start designing for
>>>>> one
>>>>>> of my requirement.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Appreciate your help.
>>>>>>
>>>>>>
>>>>>> Thanks& Regards,
>>>>>>
>>>>>> Deepa
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>> ========================================================================
>>>>> ====================================================Disclaimer:
>>>>>> This message and the information contained herein is proprietary
>>>> and
>>>>>> confidential and subject to the Tech Mahindra policy statement, you
>>>>> may
>>>>>> review the policy at<a
>>>>> href="http://www.techmahindra.com/Disclaimer.html
>>>>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>>>>> href="
>>>>>> http://tim.techmahindra.com/Disclaimer.html">
>>>>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
>>>> Tech
>>>> Mahindra.===============================================================
>>>>> =============================================================
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Varun Bhansaly
>>>>>
>>>>>
>>>> ========================================================================
>>>> ====================================================Disclaimer:
>>>>> This message and the information contained herein is proprietary and
>>>>> confidential and subject to the Tech Mahindra policy statement, you
>>>> may
>>>>> review the policy at<a
>>>> href="http://www.techmahindra.com/Disclaimer.html
>>>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>>>> href="
>>>>> http://tim.techmahindra.com/Disclaimer.html">
>>>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
>>>>>
>>>> Mahindra.===============================================================
>>>> =============================================================
>>>>
>>>>
>>>
>>
>> ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at<a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and<a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
>
>

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

In reply to this post by Jeroen van der Wal

Hi,

Need some help in JBPM integration, I have followed the steps mentioned in the link given below.

Now for the database i want to use derby instead of MySQL...
I have configured following in the context.xml (runtime/catalina/conf/context.xml)
<Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
maxActive="30" maxIdle="3" maxWait="2000"
username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
factory="org.ofbiz.entity.datasource.GenericHelperDAO"
url="jdbc:derby:ofbiz;create=true"/>

</Context>

Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also

<property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
<property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>

Regards,
Deepa

-----Original Message-----
From: [hidden email] on behalf of Jeroen van der Wal
Sent: Thu 9/9/2010 5:37 PM
To: [hidden email]
Subject: Re: Ofbiz WorkFlow Engine

There's SVn access available. Instructions here:
http://www.langhua.cn/download/ofbiz-jbpm.html

-Jeroen

On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:

> Hi Shi,
>
> Can you please help me to download the code from the location mentioned
> below? I tried FTP it did not work. Please advice.
>
>
> On 9/7/10 5:51 AM, Shi Jinghai wrote:
> > Here is a OFBiz-jBPM component:
> > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
> > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
> >
> > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
> > of jBPM.
> >
> > OSWorkflow can also work with OFBiz.
> >
> > Personally I like jBPM.
> >
> > Regards,
> >
> > Shi Jinghai/Beijing Langhua Ltd.
> >
> >
> > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
> >> Hi Varun,
> >>
> >> Yes I am looking for something similar to JBPM, not fullfledge but
> >> atleast it should have the configuration through XML (similar to Shark).
> >> Do we have something like this in Ofbiz integrated? If not, then has
> >> anyone integrated any webflows in Ofbiz? Please let me know..
> >>
> >> Regards,
> >> Deepa
> >>
> >> -----Original Message-----
> >> From: varun bhansaly [mailto:[hidden email]]
> >> Sent: Tuesday, September 07, 2010 1:38 PM
> >> To: [hidden email]
> >> Subject: Re: Ofbiz WorkFlow Engine
> >>
> >> Hi Deepa,
> >> Are you looking at something like designing the process flow, for eg as
> >> in
> >> jBPM workflow engine& the process designer ?
> >> Though processes could be implemented using SECAs, EECAs etc.
> >>
> >>
> >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
> >> <[hidden email]>wrote:
> >>
> >>> Thanks Varun for replying.. I have checked this link but its talking
> >>> about XPDL which actually comes with Shark implementation and in the
> >>> same link they have mentioned that Shark is not yet implemented in
> >>> Ofbiz. The alternative is event based. SO does this mean we don't have
> >>> workflow definition type of design in Ofbiz as of now other then the
> >>> events?
> >>>
> >>> Thanks,
> >>> Deepa
> >>>
> >>> -----Original Message-----
> >>> From: varun bhansaly [mailto:[hidden email]]
> >>> Sent: Monday, September 06, 2010 9:57 PM
> >>> To: [hidden email]
> >>> Subject: Re: Ofbiz WorkFlow Engine
> >>>
> >>> Hi,
> >>> This document might help http://ofbiz.apache.org/docs/workflow.html
> >>>
> >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
> >>> <[hidden email]>wrote:
> >>>
> >>>> Hi All,
> >>>>
> >>>>
> >>>>
> >>>> Need some help to know if we have any workflow integrated in ofbiz
> >>> 9.04
> >>>> version?
> >>>>
> >>>> if we already have the workflow is it using xpdl? Is it Shark
> >>> workflow?
> >>>> Please let me know.. need this urgently before i start designing for
> >>> one
> >>>> of my requirement.
> >>>>
> >>>>
> >>>>
> >>>> Appreciate your help.
> >>>>
> >>>>
> >>>> Thanks& Regards,
> >>>>
> >>>> Deepa
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >> ========================================================================
> >>> ====================================================Disclaimer:
> >>>> This message and the information contained herein is proprietary
> >> and
> >>>> confidential and subject to the Tech Mahindra policy statement, you
> >>> may
> >>>> review the policy at<a
> >>> href="http://www.techmahindra.com/Disclaimer.html
> >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> >>> href="
> >>>> http://tim.techmahindra.com/Disclaimer.html">
> >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> >> Tech
> >> Mahindra.===============================================================
> >>> =============================================================
> >>>
> >>>
> >>> --
> >>> Regards,
> >>> Varun Bhansaly
> >>>
> >>>
> >> ========================================================================
> >> ====================================================Disclaimer:
> >>> This message and the information contained herein is proprietary and
> >>> confidential and subject to the Tech Mahindra policy statement, you
> >> may
> >>> review the policy at<a
> >> href="http://www.techmahindra.com/Disclaimer.html
> >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> >> href="
> >>> http://tim.techmahindra.com/Disclaimer.html">
> >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> Tech
> >>>
> >> Mahindra.===============================================================
> >> =============================================================
> >>
> >>
> >
>
> ============================================================================================================================Disclaimer:
> This message and the information contained herein is proprietary and
> confidential and subject to the Tech Mahindra policy statement, you may
> review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
> ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
> http://tim.techmahindra.com/Disclaimer.html">
> http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> Mahindra.============================================================================================================================

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

Hi,

I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,

snippet from the logs

2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
at java.lang.Class.newInstance0(Class.java:335)
at java.lang.Class.newInstance(Class.java:303)
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
... 23 more

-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Sun 9/12/2010 8:37 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi,

Need some help in JBPM integration, I have followed the steps mentioned in the link given below.

Now for the database i want to use derby instead of MySQL...
I have configured following in the context.xml (runtime/catalina/conf/context.xml)
<Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
maxActive="30" maxIdle="3" maxWait="2000"
username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
factory="org.ofbiz.entity.datasource.GenericHelperDAO"
url="jdbc:derby:ofbiz;create=true"/>

</Context>

Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also

<property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
<property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>

Regards,
Deepa

-----Original Message-----
From: [hidden email] on behalf of Jeroen van der Wal
Sent: Thu 9/9/2010 5:37 PM
To: [hidden email]
Subject: Re: Ofbiz WorkFlow Engine

There's SVn access available. Instructions here:
http://www.langhua.cn/download/ofbiz-jbpm.html

-Jeroen

On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

Hi,

I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..

When i am trying to start the server, i am getting following error, Please help..

2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.

2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05

2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.

2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers

org.jbpm.JbpmException: couldn't find timers from the database

at org.jbpm.db.

________________________________

From: Deepa Priolkar [mailto:[hidden email]]
Sent: Sun 9/12/2010 8:41 PM
To: [hidden email]; [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi,

I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,

snippet from the logs

2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
at java.lang.Class.newInstance0(Class.java:335)
at java.lang.Class.newInstance(Class.java:303)
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
... 23 more

-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Sun 9/12/2010 8:37 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi,

Need some help in JBPM integration, I have followed the steps mentioned in the link given below.

Now for the database i want to use derby instead of MySQL...
I have configured following in the context.xml (runtime/catalina/conf/context.xml)
<Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
maxActive="30" maxIdle="3" maxWait="2000"
username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
factory="org.ofbiz.entity.datasource.GenericHelperDAO"
url="jdbc:derby:ofbiz;create=true"/>

</Context>

Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also

<property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
<property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>

Regards,
Deepa

-----Original Message-----
From: [hidden email] on behalf of Jeroen van der Wal
Sent: Thu 9/9/2010 5:37 PM
To: [hidden email]
Subject: Re: Ofbiz WorkFlow Engine

There's SVn access available. Instructions here:
http://www.langhua.cn/download/ofbiz-jbpm.html

-Jeroen

On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

can someone tell me how to create table in the derby database?

________________________________

From: Deepa Priolkar [mailto:[hidden email]]
Sent: Sun 9/12/2010 10:25 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi,

I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..

When i am trying to start the server, i am getting following error, Please help..

2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01

2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.

2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05

2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.

2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers

org.jbpm.JbpmException: couldn't find timers from the database

at org.jbpm.db.

________________________________

From: Deepa Priolkar [mailto:[hidden email]]
Sent: Sun 9/12/2010 8:41 PM
To: [hidden email]; [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi,

I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,

snippet from the logs

2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
at java.lang.Class.newInstance0(Class.java:335)
at java.lang.Class.newInstance(Class.java:303)
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
... 23 more

-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Sun 9/12/2010 8:37 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi,

Need some help in JBPM integration, I have followed the steps mentioned in the link given below.

Now for the database i want to use derby instead of MySQL...
I have configured following in the context.xml (runtime/catalina/conf/context.xml)
<Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
maxActive="30" maxIdle="3" maxWait="2000"
username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
factory="org.ofbiz.entity.datasource.GenericHelperDAO"
url="jdbc:derby:ofbiz;create=true"/>

</Context>

Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also

<property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
<property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>

Regards,
Deepa

-----Original Message-----
From: [hidden email] on behalf of Jeroen van der Wal
Sent: Thu 9/9/2010 5:37 PM
To: [hidden email]
Subject: Re: Ofbiz WorkFlow Engine

There's SVn access available. Instructions here:
http://www.langhua.cn/download/ofbiz-jbpm.html

-Jeroen

On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:

Shi Jinghai

RE: Ofbiz WorkFlow Engine

Hi Deepa,

The ofbiz-jbpm component is developed in maven style. We use eclipse +
iam as our standard develop tool.

You can find the built components in our maven repository:
http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

Download the zip files and unzip them to your ofbiz, rebuild (I changed
the StringUtil.java to make it work for iframe in htmlreport), add the 2
components to component-load.xml, config
${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
database and restart ofbiz, that's all. The jbpm tables will be created
automatically during startup.

The htmlreport is a tool to show the procedures of importing jbpm
process file and etc in web browser. There's demos in the component. You
can remove it from your tool bar if it works.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

在 2010-09-12日的 22:29 +0530，Deepa Priolkar写道：

> can someone tell me how to create table in the derby database?
>
> ________________________________
>
> From: Deepa Priolkar [mailto:[hidden email]]
> Sent: Sun 9/12/2010 10:25 PM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
>
>
> Hi,
>
> I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..
>
> When i am trying to start the server, i am getting following error, Please help..
>
> 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries
>
> 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
>
> 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.
>
> 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01
>
> 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.
>
> 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
>
> 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.
>
> 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
>
> 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
>
> 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers
>
> org.jbpm.JbpmException: couldn't find timers from the database
>
> at org.jbpm.db.
>
>
>
> ________________________________
>
> From: Deepa Priolkar [mailto:[hidden email]]
> Sent: Sun 9/12/2010 8:41 PM
> To: [hidden email]; [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
>
>
> Hi,
>
> I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,
>
> snippet from the logs
>
> 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
> javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
> at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
> at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
> at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
> at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
> at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
> at javax.naming.InitialContext.lookup(InitialContext.java:351)
> at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
> at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
> at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
> at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
> at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
> at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
> at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
> at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
> at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
> at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
> at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
> at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
> at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
> at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
> Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
> at java.lang.Class.newInstance0(Class.java:335)
> at java.lang.Class.newInstance(Class.java:303)
> at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
> ... 23 more
>
> -----Original Message-----
> From: Deepa Priolkar [mailto:[hidden email]]
> Sent: Sun 9/12/2010 8:37 PM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
>
> Hi,
>
> Need some help in JBPM integration, I have followed the steps mentioned in the link given below.
>
> Now for the database i want to use derby instead of MySQL...
> I have configured following in the context.xml (runtime/catalina/conf/context.xml)
> <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
> maxActive="30" maxIdle="3" maxWait="2000"
> username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
> factory="org.ofbiz.entity.datasource.GenericHelperDAO"
> url="jdbc:derby:ofbiz;create=true"/>
>
> </Context>
>
> Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also
>
> <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
> <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>
>
> Regards,
> Deepa
>
>
> -----Original Message-----
> From: [hidden email] on behalf of Jeroen van der Wal
> Sent: Thu 9/9/2010 5:37 PM
> To: [hidden email]
> Subject: Re: Ofbiz WorkFlow Engine
>
> There's SVn access available. Instructions here:
> http://www.langhua.cn/download/ofbiz-jbpm.html
>
> -Jeroen
>
> On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:
>
> > Hi Shi,
> >
> > Can you please help me to download the code from the location mentioned
> > below? I tried FTP it did not work. Please advice.
> >
> >
> > On 9/7/10 5:51 AM, Shi Jinghai wrote:
> > > Here is a OFBiz-jBPM component:
> > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
> > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
> > >
> > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
> > > of jBPM.
> > >
> > > OSWorkflow can also work with OFBiz.
> > >
> > > Personally I like jBPM.
> > >
> > > Regards,
> > >
> > > Shi Jinghai/Beijing Langhua Ltd.
> > >
> > >
> > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
> > >> Hi Varun,
> > >>
> > >> Yes I am looking for something similar to JBPM, not fullfledge but
> > >> atleast it should have the configuration through XML (similar to Shark).
> > >> Do we have something like this in Ofbiz integrated? If not, then has
> > >> anyone integrated any webflows in Ofbiz? Please let me know..
> > >>
> > >> Regards,
> > >> Deepa
> > >>
> > >> -----Original Message-----
> > >> From: varun bhansaly [mailto:[hidden email]]
> > >> Sent: Tuesday, September 07, 2010 1:38 PM
> > >> To: [hidden email]
> > >> Subject: Re: Ofbiz WorkFlow Engine
> > >>
> > >> Hi Deepa,
> > >> Are you looking at something like designing the process flow, for eg as
> > >> in
> > >> jBPM workflow engine& the process designer ?
> > >> Though processes could be implemented using SECAs, EECAs etc.
> > >>
> > >>
> > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
> > >> <[hidden email]>wrote:
> > >>
> > >>> Thanks Varun for replying.. I have checked this link but its talking
> > >>> about XPDL which actually comes with Shark implementation and in the
> > >>> same link they have mentioned that Shark is not yet implemented in
> > >>> Ofbiz. The alternative is event based. SO does this mean we don't have
> > >>> workflow definition type of design in Ofbiz as of now other then the
> > >>> events?
> > >>>
> > >>> Thanks,
> > >>> Deepa
> > >>>
> > >>> -----Original Message-----
> > >>> From: varun bhansaly [mailto:[hidden email]]
> > >>> Sent: Monday, September 06, 2010 9:57 PM
> > >>> To: [hidden email]
> > >>> Subject: Re: Ofbiz WorkFlow Engine
> > >>>
> > >>> Hi,
> > >>> This document might help http://ofbiz.apache.org/docs/workflow.html
> > >>>
> > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
> > >>> <[hidden email]>wrote:
> > >>>
> > >>>> Hi All,
> > >>>>
> > >>>>
> > >>>>
> > >>>> Need some help to know if we have any workflow integrated in ofbiz
> > >>> 9.04
> > >>>> version?
> > >>>>
> > >>>> if we already have the workflow is it using xpdl? Is it Shark
> > >>> workflow?
> > >>>> Please let me know.. need this urgently before i start designing for
> > >>> one
> > >>>> of my requirement.
> > >>>>
> > >>>>
> > >>>>
> > >>>> Appreciate your help.
> > >>>>
> > >>>>
> > >>>> Thanks& Regards,
> > >>>>
> > >>>> Deepa
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >> ========================================================================
> > >>> ====================================================Disclaimer:
> > >>>> This message and the information contained herein is proprietary
> > >> and
> > >>>> confidential and subject to the Tech Mahindra policy statement, you
> > >>> may
> > >>>> review the policy at<a
> > >>> href="http://www.techmahindra.com/Disclaimer.html
> > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > >>> href="
> > >>>> http://tim.techmahindra.com/Disclaimer.html">
> > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > >> Tech
> > >> Mahindra.===============================================================
> > >>> =============================================================
> > >>>
> > >>>
> > >>> --
> > >>> Regards,
> > >>> Varun Bhansaly
> > >>>
> > >>>
> > >> ========================================================================
> > >> ====================================================Disclaimer:
> > >>> This message and the information contained herein is proprietary and
> > >>> confidential and subject to the Tech Mahindra policy statement, you
> > >> may
> > >>> review the policy at<a
> > >> href="http://www.techmahindra.com/Disclaimer.html
> > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > >> href="
> > >>> http://tim.techmahindra.com/Disclaimer.html">
> > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > Tech
> > >>>
> > >> Mahindra.===============================================================
> > >> =============================================================
> > >>
> > >>
> > >
> >
> > ============================================================================================================================Disclaimer:
> > This message and the information contained herein is proprietary and
> > confidential and subject to the Tech Mahindra policy statement, you may
> > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
> > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
> > http://tim.techmahindra.com/Disclaimer.html">
> > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> > Mahindra.============================================================================================================================
>
>
>
>
> ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
>
>
>
>

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

In reply to this post by Deepa Priolkar

Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.

However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby database.. Please advice..

2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
The problematic instruction:
----------
==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
----------

Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

Regards,
Deepa

-----Original Message-----
From: Shi Jinghai [mailto:[hidden email]]
Sent: Mon 9/13/2010 3:06 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi Deepa,

The ofbiz-jbpm component is developed in maven style. We use eclipse +
iam as our standard develop tool.

You can find the built components in our maven repository:
http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

Download the zip files and unzip them to your ofbiz, rebuild (I changed
the StringUtil.java to make it work for iframe in htmlreport), add the 2
components to component-load.xml, config
${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
database and restart ofbiz, that's all. The jbpm tables will be created
automatically during startup.

The htmlreport is a tool to show the procedures of importing jbpm
process file and etc in web browser. There's demos in the component. You
can remove it from your tool bar if it works.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it clashes...

2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed: org.jbpm.taskmgmt.log.TaskAssignLog
java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)

Regards,
Deepa
-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Tue 9/14/2010 11:45 AM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.

However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby database.. Please advice..

2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
The problematic instruction:
----------
==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
----------

Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

Regards,
Deepa

-----Original Message-----
From: Shi Jinghai [mailto:[hidden email]]
Sent: Mon 9/13/2010 3:06 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi Deepa,

The ofbiz-jbpm component is developed in maven style. We use eclipse +
iam as our standard develop tool.

You can find the built components in our maven repository:
http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

Download the zip files and unzip them to your ofbiz, rebuild (I changed
the StringUtil.java to make it work for iframe in htmlreport), add the 2
components to component-load.xml, config
${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
database and restart ofbiz, that's all. The jbpm tables will be created
automatically during startup.

The htmlreport is a tool to show the procedures of importing jbpm
process file and etc in web browser. There's demos in the component. You
can remove it from your tool bar if it works.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:

Jack Liu-2

RE: Ofbiz WorkFlow Engine

I recommend OSWorkflow and it's easier to master.

-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: 2010年9月14日 14:25
To: [hidden email]; [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it clashes...

2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed: org.jbpm.taskmgmt.log.TaskAssignLog
java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)

Regards,
Deepa
-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Tue 9/14/2010 11:45 AM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.

However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby database.. Please advice..

2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
The problematic instruction:
----------
==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
----------

Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

Regards,
Deepa

-----Original Message-----
From: Shi Jinghai [mailto:[hidden email]]
Sent: Mon 9/13/2010 3:06 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi Deepa,

The ofbiz-jbpm component is developed in maven style. We use eclipse +
iam as our standard develop tool.

You can find the built components in our maven repository:
http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

Download the zip files and unzip them to your ofbiz, rebuild (I changed
the StringUtil.java to make it work for iframe in htmlreport), add the 2
components to component-load.xml, config
${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
database and restart ofbiz, that's all. The jbpm tables will be created
automatically during startup.

The htmlreport is a tool to show the procedures of importing jbpm
process file and etc in web browser. There's demos in the component. You
can remove it from your tool bar if it works.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:

Shi Jinghai

RE: Ofbiz WorkFlow Engine

In reply to this post by Deepa Priolkar

In asm2.2.jar, CodeVisitor class does not exist either, it's not used if
deployed correctly.

Sorry, we don't use derby. The bundled scripts are for mysql (for linux)
and mssql (for windows), you have to download jbpm source code to build
derby scripts. Then deploy the scripts to specialpurpose/jbpm/db/derby
and edit specialpurpose/jbpm/config/jbpm-config.xml to change the
datasource configurations.

Regards,

Shi Jinghai/Beijing Langhua Ltd.

在 2010-09-14二的 11:55 +0530，Deepa Priolkar写道：

> Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it clashes...
>
> 2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed: org.jbpm.taskmgmt.log.TaskAssignLog
> java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
> at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
> at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
> at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
> at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)
>
> Regards,
> Deepa
> -----Original Message-----
> From: Deepa Priolkar [mailto:[hidden email]]
> Sent: Tue 9/14/2010 11:45 AM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
>
> Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.
>
> However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby database.. Please advice..
>
> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
> Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
> The problematic instruction:
> ----------
> ==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
> ----------
>
> Java backtrace for programmers:
> ----------
> freemarker.template.TemplateModelException: Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
> at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
> at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
> at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
>
> Regards,
> Deepa
>
> -----Original Message-----
> From: Shi Jinghai [mailto:[hidden email]]
> Sent: Mon 9/13/2010 3:06 PM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
> Hi Deepa,
>
> The ofbiz-jbpm component is developed in maven style. We use eclipse +
> iam as our standard develop tool.
>
> You can find the built components in our maven repository:
> http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/
>
> http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/
>
> Download the zip files and unzip them to your ofbiz, rebuild (I changed
> the StringUtil.java to make it work for iframe in htmlreport), add the 2
> components to component-load.xml, config
> ${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
> database and restart ofbiz, that's all. The jbpm tables will be created
> automatically during startup.
>
> The htmlreport is a tool to show the procedures of importing jbpm
> process file and etc in web browser. There's demos in the component. You
> can remove it from your tool bar if it works.
>
> Good luck,
>
> Shi Jinghai/Beijing Langhua Ltd.
>
>
> ? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:
> > can someone tell me how to create table in the derby database?
> >
> > ________________________________
> >
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 10:25 PM
> > To: [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> >
> > Hi,
> >
> > I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..
> >
> > When i am trying to start the server, i am getting following error, Please help..
> >
> > 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> >
> > 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers
> >
> > org.jbpm.JbpmException: couldn't find timers from the database
> >
> > at org.jbpm.db.
> >
> >
> >
> > ________________________________
> >
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 8:41 PM
> > To: [hidden email]; [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> >
> > Hi,
> >
> > I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,
> >
> > snippet from the logs
> >
> > 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
> > javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
> > at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
> > at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
> > at javax.naming.InitialContext.lookup(InitialContext.java:351)
> > at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
> > at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
> > at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
> > at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
> > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
> > at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
> > at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
> > at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
> > at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
> > at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
> > at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
> > at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
> > Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
> > at java.lang.Class.newInstance0(Class.java:335)
> > at java.lang.Class.newInstance(Class.java:303)
> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
> > ... 23 more
> >
> > -----Original Message-----
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 8:37 PM
> > To: [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> > Hi,
> >
> > Need some help in JBPM integration, I have followed the steps mentioned in the link given below.
> >
> > Now for the database i want to use derby instead of MySQL...
> > I have configured following in the context.xml (runtime/catalina/conf/context.xml)
> > <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
> > maxActive="30" maxIdle="3" maxWait="2000"
> > username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
> > factory="org.ofbiz.entity.datasource.GenericHelperDAO"
> > url="jdbc:derby:ofbiz;create=true"/>
> >
> > </Context>
> >
> > Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also
> >
> > <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
> > <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>
> >
> > Regards,
> > Deepa
> >
> >
> > -----Original Message-----
> > From: [hidden email] on behalf of Jeroen van der Wal
> > Sent: Thu 9/9/2010 5:37 PM
> > To: [hidden email]
> > Subject: Re: Ofbiz WorkFlow Engine
> >
> > There's SVn access available. Instructions here:
> > http://www.langhua.cn/download/ofbiz-jbpm.html
> >
> > -Jeroen
> >
> > On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:
> >
> > > Hi Shi,
> > >
> > > Can you please help me to download the code from the location mentioned
> > > below? I tried FTP it did not work. Please advice.
> > >
> > >
> > > On 9/7/10 5:51 AM, Shi Jinghai wrote:
> > > > Here is a OFBiz-jBPM component:
> > > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
> > > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
> > > >
> > > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
> > > > of jBPM.
> > > >
> > > > OSWorkflow can also work with OFBiz.
> > > >
> > > > Personally I like jBPM.
> > > >
> > > > Regards,
> > > >
> > > > Shi Jinghai/Beijing Langhua Ltd.
> > > >
> > > >
> > > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
> > > >> Hi Varun,
> > > >>
> > > >> Yes I am looking for something similar to JBPM, not fullfledge but
> > > >> atleast it should have the configuration through XML (similar to Shark).
> > > >> Do we have something like this in Ofbiz integrated? If not, then has
> > > >> anyone integrated any webflows in Ofbiz? Please let me know..
> > > >>
> > > >> Regards,
> > > >> Deepa
> > > >>
> > > >> -----Original Message-----
> > > >> From: varun bhansaly [mailto:[hidden email]]
> > > >> Sent: Tuesday, September 07, 2010 1:38 PM
> > > >> To: [hidden email]
> > > >> Subject: Re: Ofbiz WorkFlow Engine
> > > >>
> > > >> Hi Deepa,
> > > >> Are you looking at something like designing the process flow, for eg as
> > > >> in
> > > >> jBPM workflow engine& the process designer ?
> > > >> Though processes could be implemented using SECAs, EECAs etc.
> > > >>
> > > >>
> > > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
> > > >> <[hidden email]>wrote:
> > > >>
> > > >>> Thanks Varun for replying.. I have checked this link but its talking
> > > >>> about XPDL which actually comes with Shark implementation and in the
> > > >>> same link they have mentioned that Shark is not yet implemented in
> > > >>> Ofbiz. The alternative is event based. SO does this mean we don't have
> > > >>> workflow definition type of design in Ofbiz as of now other then the
> > > >>> events?
> > > >>>
> > > >>> Thanks,
> > > >>> Deepa
> > > >>>
> > > >>> -----Original Message-----
> > > >>> From: varun bhansaly [mailto:[hidden email]]
> > > >>> Sent: Monday, September 06, 2010 9:57 PM
> > > >>> To: [hidden email]
> > > >>> Subject: Re: Ofbiz WorkFlow Engine
> > > >>>
> > > >>> Hi,
> > > >>> This document might help http://ofbiz.apache.org/docs/workflow.html
> > > >>>
> > > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
> > > >>> <[hidden email]>wrote:
> > > >>>
> > > >>>> Hi All,
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>> Need some help to know if we have any workflow integrated in ofbiz
> > > >>> 9.04
> > > >>>> version?
> > > >>>>
> > > >>>> if we already have the workflow is it using xpdl? Is it Shark
> > > >>> workflow?
> > > >>>> Please let me know.. need this urgently before i start designing for
> > > >>> one
> > > >>>> of my requirement.
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>> Appreciate your help.
> > > >>>>
> > > >>>>
> > > >>>> Thanks& Regards,
> > > >>>>
> > > >>>> Deepa
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >> ========================================================================
> > > >>> ====================================================Disclaimer:
> > > >>>> This message and the information contained herein is proprietary
> > > >> and
> > > >>>> confidential and subject to the Tech Mahindra policy statement, you
> > > >>> may
> > > >>>> review the policy at<a
> > > >>> href="http://www.techmahindra.com/Disclaimer.html
> > > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > > >>> href="
> > > >>>> http://tim.techmahindra.com/Disclaimer.html">
> > > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > > >> Tech
> > > >> Mahindra.===============================================================
> > > >>> =============================================================
> > > >>>
> > > >>>
> > > >>> --
> > > >>> Regards,
> > > >>> Varun Bhansaly
> > > >>>
> > > >>>
> > > >> ========================================================================
> > > >> ====================================================Disclaimer:
> > > >>> This message and the information contained herein is proprietary and
> > > >>> confidential and subject to the Tech Mahindra policy statement, you
> > > >> may
> > > >>> review the policy at<a
> > > >> href="http://www.techmahindra.com/Disclaimer.html
> > > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > > >> href="
> > > >>> http://tim.techmahindra.com/Disclaimer.html">
> > > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > > Tech
> > > >>>
> > > >> Mahindra.===============================================================
> > > >> =============================================================
> > > >>
> > > >>
> > > >
> > >
> > > ============================================================================================================================Disclaimer:
> > > This message and the information contained herein is proprietary and
> > > confidential and subject to the Tech Mahindra policy statement, you may
> > > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
> > > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
> > > http://tim.techmahindra.com/Disclaimer.html">
> > > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> > > Mahindra.============================================================================================================================
> >
> >
> >
> >
> > ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
> >
> >
> >
> >
>
>
>
>
>
> ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

Shi Jinghai

RE: Ofbiz WorkFlow Engine

In reply to this post by Jack Liu-2

Hi Jack,

I respect Hans' great work on OSWorkflow. Only 2 questions on OFBiz
OSWorkflow integration:
1. Support hot deploy a workflow in OFBiz? If yes, how the ongoing
processes run when a new version workflow deployed?
2. Support UI generation according to workflow definition?

Regards,

Shi Jinghai/Beijing Langhua Ltd.

在 2010-09-14二的 14:33 +0800，Jack Liu写道：

> I recommend OSWorkflow and it's easier to master.
>
>
>
> -----Original Message-----
> From: Deepa Priolkar [mailto:[hidden email]]
> Sent: 2010年9月14日 14:25
> To: [hidden email]; [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
> Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it clashes...
>
> 2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed: org.jbpm.taskmgmt.log.TaskAssignLog
> java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
> at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
> at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
> at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
> at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)
>
> Regards,
> Deepa
> -----Original Message-----
> From: Deepa Priolkar [mailto:[hidden email]]
> Sent: Tue 9/14/2010 11:45 AM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
>
> Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.
>
> However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby database.. Please advice..
>
> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
> Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
> The problematic instruction:
> ----------
> ==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
> ----------
>
> Java backtrace for programmers:
> ----------
> freemarker.template.TemplateModelException: Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
> at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
> at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
> at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
>
> Regards,
> Deepa
>
> -----Original Message-----
> From: Shi Jinghai [mailto:[hidden email]]
> Sent: Mon 9/13/2010 3:06 PM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
> Hi Deepa,
>
> The ofbiz-jbpm component is developed in maven style. We use eclipse +
> iam as our standard develop tool.
>
> You can find the built components in our maven repository:
> http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/
>
> http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/
>
> Download the zip files and unzip them to your ofbiz, rebuild (I changed
> the StringUtil.java to make it work for iframe in htmlreport), add the 2
> components to component-load.xml, config
> ${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
> database and restart ofbiz, that's all. The jbpm tables will be created
> automatically during startup.
>
> The htmlreport is a tool to show the procedures of importing jbpm
> process file and etc in web browser. There's demos in the component. You
> can remove it from your tool bar if it works.
>
> Good luck,
>
> Shi Jinghai/Beijing Langhua Ltd.
>
>
> ? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:
> > can someone tell me how to create table in the derby database?
> >
> > ________________________________
> >
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 10:25 PM
> > To: [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> >
> > Hi,
> >
> > I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..
> >
> > When i am trying to start the server, i am getting following error, Please help..
> >
> > 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> >
> > 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers
> >
> > org.jbpm.JbpmException: couldn't find timers from the database
> >
> > at org.jbpm.db.
> >
> >
> >
> > ________________________________
> >
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 8:41 PM
> > To: [hidden email]; [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> >
> > Hi,
> >
> > I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,
> >
> > snippet from the logs
> >
> > 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
> > javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
> > at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
> > at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
> > at javax.naming.InitialContext.lookup(InitialContext.java:351)
> > at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
> > at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
> > at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
> > at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
> > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
> > at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
> > at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
> > at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
> > at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
> > at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
> > at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
> > at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
> > Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
> > at java.lang.Class.newInstance0(Class.java:335)
> > at java.lang.Class.newInstance(Class.java:303)
> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
> > ... 23 more
> >
> > -----Original Message-----
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 8:37 PM
> > To: [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> > Hi,
> >
> > Need some help in JBPM integration, I have followed the steps mentioned in the link given below.
> >
> > Now for the database i want to use derby instead of MySQL...
> > I have configured following in the context.xml (runtime/catalina/conf/context.xml)
> > <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
> > maxActive="30" maxIdle="3" maxWait="2000"
> > username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
> > factory="org.ofbiz.entity.datasource.GenericHelperDAO"
> > url="jdbc:derby:ofbiz;create=true"/>
> >
> > </Context>
> >
> > Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also
> >
> > <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
> > <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>
> >
> > Regards,
> > Deepa
> >
> >
> > -----Original Message-----
> > From: [hidden email] on behalf of Jeroen van der Wal
> > Sent: Thu 9/9/2010 5:37 PM
> > To: [hidden email]
> > Subject: Re: Ofbiz WorkFlow Engine
> >
> > There's SVn access available. Instructions here:
> > http://www.langhua.cn/download/ofbiz-jbpm.html
> >
> > -Jeroen
> >
> > On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:
> >
> > > Hi Shi,
> > >
> > > Can you please help me to download the code from the location mentioned
> > > below? I tried FTP it did not work. Please advice.
> > >
> > >
> > > On 9/7/10 5:51 AM, Shi Jinghai wrote:
> > > > Here is a OFBiz-jBPM component:
> > > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
> > > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
> > > >
> > > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
> > > > of jBPM.
> > > >
> > > > OSWorkflow can also work with OFBiz.
> > > >
> > > > Personally I like jBPM.
> > > >
> > > > Regards,
> > > >
> > > > Shi Jinghai/Beijing Langhua Ltd.
> > > >
> > > >
> > > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
> > > >> Hi Varun,
> > > >>
> > > >> Yes I am looking for something similar to JBPM, not fullfledge but
> > > >> atleast it should have the configuration through XML (similar to Shark).
> > > >> Do we have something like this in Ofbiz integrated? If not, then has
> > > >> anyone integrated any webflows in Ofbiz? Please let me know..
> > > >>
> > > >> Regards,
> > > >> Deepa
> > > >>
> > > >> -----Original Message-----
> > > >> From: varun bhansaly [mailto:[hidden email]]
> > > >> Sent: Tuesday, September 07, 2010 1:38 PM
> > > >> To: [hidden email]
> > > >> Subject: Re: Ofbiz WorkFlow Engine
> > > >>
> > > >> Hi Deepa,
> > > >> Are you looking at something like designing the process flow, for eg as
> > > >> in
> > > >> jBPM workflow engine& the process designer ?
> > > >> Though processes could be implemented using SECAs, EECAs etc.
> > > >>
> > > >>
> > > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
> > > >> <[hidden email]>wrote:
> > > >>
> > > >>> Thanks Varun for replying.. I have checked this link but its talking
> > > >>> about XPDL which actually comes with Shark implementation and in the
> > > >>> same link they have mentioned that Shark is not yet implemented in
> > > >>> Ofbiz. The alternative is event based. SO does this mean we don't have
> > > >>> workflow definition type of design in Ofbiz as of now other then the
> > > >>> events?
> > > >>>
> > > >>> Thanks,
> > > >>> Deepa
> > > >>>
> > > >>> -----Original Message-----
> > > >>> From: varun bhansaly [mailto:[hidden email]]
> > > >>> Sent: Monday, September 06, 2010 9:57 PM
> > > >>> To: [hidden email]
> > > >>> Subject: Re: Ofbiz WorkFlow Engine
> > > >>>
> > > >>> Hi,
> > > >>> This document might help http://ofbiz.apache.org/docs/workflow.html
> > > >>>
> > > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
> > > >>> <[hidden email]>wrote:
> > > >>>
> > > >>>> Hi All,
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>> Need some help to know if we have any workflow integrated in ofbiz
> > > >>> 9.04
> > > >>>> version?
> > > >>>>
> > > >>>> if we already have the workflow is it using xpdl? Is it Shark
> > > >>> workflow?
> > > >>>> Please let me know.. need this urgently before i start designing for
> > > >>> one
> > > >>>> of my requirement.
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>> Appreciate your help.
> > > >>>>
> > > >>>>
> > > >>>> Thanks& Regards,
> > > >>>>
> > > >>>> Deepa
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >> ========================================================================
> > > >>> ====================================================Disclaimer:
> > > >>>> This message and the information contained herein is proprietary
> > > >> and
> > > >>>> confidential and subject to the Tech Mahindra policy statement, you
> > > >>> may
> > > >>>> review the policy at<a
> > > >>> href="http://www.techmahindra.com/Disclaimer.html
> > > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > > >>> href="
> > > >>>> http://tim.techmahindra.com/Disclaimer.html">
> > > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > > >> Tech
> > > >> Mahindra.===============================================================
> > > >>> =============================================================
> > > >>>
> > > >>>
> > > >>> --
> > > >>> Regards,
> > > >>> Varun Bhansaly
> > > >>>
> > > >>>
> > > >> ========================================================================
> > > >> ====================================================Disclaimer:
> > > >>> This message and the information contained herein is proprietary and
> > > >>> confidential and subject to the Tech Mahindra policy statement, you
> > > >> may
> > > >>> review the policy at<a
> > > >> href="http://www.techmahindra.com/Disclaimer.html
> > > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > > >> href="
> > > >>> http://tim.techmahindra.com/Disclaimer.html">
> > > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > > Tech
> > > >>>
> > > >> Mahindra.===============================================================
> > > >> =============================================================
> > > >>
> > > >>
> > > >
> > >
> > > ============================================================================================================================Disclaimer:
> > > This message and the information contained herein is proprietary and
> > > confidential and subject to the Tech Mahindra policy statement, you may
> > > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
> > > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
> > > http://tim.techmahindra.com/Disclaimer.html">
> > > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> > > Mahindra.============================================================================================================================
> >
> >
> >
> >
> > ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
> >
> >
> >
> >
>
>
>
>
>
> ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

Jacques Le Roux

Re: Ofbiz WorkFlow Engine

Administrator

From: "Shi Jinghai" <[hidden email]>
> Hi Jack,
>
> I respect Hans' great work on OSWorkflow. Only 2 questions on OFBiz

I guess you meant Hani's
http://www.opensymphony.com/osworkflow/members.action

Jacques

> OSWorkflow integration:
> 1. Support hot deploy a workflow in OFBiz? If yes, how the ongoing
> processes run when a new version workflow deployed?
> 2. Support UI generation according to workflow definition?
>
> Regards,
>
> Shi Jinghai/Beijing Langhua Ltd.
>
>
> 在 2010-09-14二的 14:33 +0800，Jack Liu写道：
>> I recommend OSWorkflow and it's easier to master.
>>
>>
>>
>> -----Original Message-----
>> From: Deepa Priolkar [mailto:[hidden email]]
>> Sent: 2010年9月14日 14:25
>> To: [hidden email]; [hidden email]
>> Subject: RE: Ofbiz WorkFlow Engine
>>
>> Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has
>> asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other
>> classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it
>> clashes...
>>
>> 2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed:
>> org.jbpm.taskmgmt.log.TaskAssignLog
>> java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
>> at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
>> at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
>> at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
>> at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)
>>
>> Regards,
>> Deepa
>> -----Original Message-----
>> From: Deepa Priolkar [mailto:[hidden email]]
>> Sent: Tue 9/14/2010 11:45 AM
>> To: [hidden email]
>> Subject: RE: Ofbiz WorkFlow Engine
>>
>>
>> Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.
>>
>> However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not
>> found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby
>> database.. Please advice..
>>
>> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not
>> exist.
>> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
>> Method public static java.util.List
>> org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue)
>> threw an exception
>> The problematic instruction:
>> ----------
>> ==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on
>> line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
>> ----------
>>
>> Java backtrace for programmers:
>> ----------
>> freemarker.template.TemplateModelException: Method public static java.util.List
>> org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue)
>> threw an exception
>> at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
>> at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
>> at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
>>
>> Regards,
>> Deepa
>>
>> -----Original Message-----
>> From: Shi Jinghai [mailto:[hidden email]]
>> Sent: Mon 9/13/2010 3:06 PM
>> To: [hidden email]
>> Subject: RE: Ofbiz WorkFlow Engine
>>
>> Hi Deepa,
>>
>> The ofbiz-jbpm component is developed in maven style. We use eclipse +
>> iam as our standard develop tool.
>>
>> You can find the built components in our maven repository:
>> http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/
>>
>> http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/
>>
>> Download the zip files and unzip them to your ofbiz, rebuild (I changed
>> the StringUtil.java to make it work for iframe in htmlreport), add the 2
>> components to component-load.xml, config
>> ${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
>> database and restart ofbiz, that's all. The jbpm tables will be created
>> automatically during startup.
>>
>> The htmlreport is a tool to show the procedures of importing jbpm
>> process file and etc in web browser. There's demos in the component. You
>> can remove it from your tool bar if it works.
>>
>> Good luck,
>>
>> Shi Jinghai/Beijing Langhua Ltd.
>>
>>
>> ? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:
>> > can someone tell me how to create table in the derby database?
>> >
>> > ________________________________
>> >
>> > From: Deepa Priolkar [mailto:[hidden email]]
>> > Sent: Sun 9/12/2010 10:25 PM
>> > To: [hidden email]
>> > Subject: RE: Ofbiz WorkFlow Engine
>> >
>> >
>> >
>> > Hi,
>> >
>> > I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..
>> >
>> > When i am trying to start the server, i am getting following error, Please help..
>> >
>> > 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries
>> >
>> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
>> >
>> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.
>> >
>> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01
>> >
>> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection
>> > made to existing database instead.
>> >
>> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
>> >
>> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.
>> >
>> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could
>> > not execute query using iterate
>> >
>> > 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR]
>> > org.hibernate.exception.SQLGrammarException: could not execute query using iterate
>> >
>> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers
>> >
>> > org.jbpm.JbpmException: couldn't find timers from the database
>> >
>> > at org.jbpm.db.
>> >
>> >
>> >
>> > ________________________________
>> >
>> > From: Deepa Priolkar [mailto:[hidden email]]
>> > Sent: Sun 9/12/2010 8:41 PM
>> > To: [hidden email]; [hidden email]
>> > Subject: RE: Ofbiz WorkFlow Engine
>> >
>> >
>> >
>> > Hi,
>> >
>> > I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,
>> >
>> > snippet from the logs
>> >
>> > 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource:
>> > java:comp/env/jBPM_DS
>> > javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException:
>> > org.ofbiz.entity.datasource.GenericHelperDAO]
>> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
>> > at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
>> > at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
>> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
>> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
>> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
>> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
>> > at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
>> > at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
>> > at javax.naming.InitialContext.lookup(InitialContext.java:351)
>> > at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
>> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
>> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
>> > at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
>> > at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
>> > at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
>> > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
>> > at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
>> > at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
>> > at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
>> > at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
>> > at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
>> > at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
>> > at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
>> > Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
>> > at java.lang.Class.newInstance0(Class.java:335)
>> > at java.lang.Class.newInstance(Class.java:303)
>> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
>> > ... 23 more
>> >
>> > -----Original Message-----
>> > From: Deepa Priolkar [mailto:[hidden email]]
>> > Sent: Sun 9/12/2010 8:37 PM
>> > To: [hidden email]
>> > Subject: RE: Ofbiz WorkFlow Engine
>> >
>> >
>> > Hi,
>> >
>> > Need some help in JBPM integration, I have followed the steps mentioned in the link given below.
>> >
>> > Now for the database i want to use derby instead of MySQL...
>> > I have configured following in the context.xml (runtime/catalina/conf/context.xml)
>> > <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
>> > maxActive="30" maxIdle="3" maxWait="2000"
>> > username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>> > factory="org.ofbiz.entity.datasource.GenericHelperDAO"
>> > url="jdbc:derby:ofbiz;create=true"/>
>> >
>> > </Context>
>> >
>> > Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also
>> >
>> > <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
>> > <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>
>> >
>> > Regards,
>> > Deepa
>> >
>> >
>> > -----Original Message-----
>> > From: [hidden email] on behalf of Jeroen van der Wal
>> > Sent: Thu 9/9/2010 5:37 PM
>> > To: [hidden email]
>> > Subject: Re: Ofbiz WorkFlow Engine
>> >
>> > There's SVn access available. Instructions here:
>> > http://www.langhua.cn/download/ofbiz-jbpm.html
>> >
>> > -Jeroen
>> >
>> > On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:
>> >
>> > > Hi Shi,
>> > >
>> > > Can you please help me to download the code from the location mentioned
>> > > below? I tried FTP it did not work. Please advice.
>> > >
>> > >
>> > > On 9/7/10 5:51 AM, Shi Jinghai wrote:
>> > > > Here is a OFBiz-jBPM component:
>> > > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
>> > > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
>> > > >
>> > > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
>> > > > of jBPM.
>> > > >
>> > > > OSWorkflow can also work with OFBiz.
>> > > >
>> > > > Personally I like jBPM.
>> > > >
>> > > > Regards,
>> > > >
>> > > > Shi Jinghai/Beijing Langhua Ltd.
>> > > >
>> > > >
>> > > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
>> > > >> Hi Varun,
>> > > >>
>> > > >> Yes I am looking for something similar to JBPM, not fullfledge but
>> > > >> atleast it should have the configuration through XML (similar to Shark).
>> > > >> Do we have something like this in Ofbiz integrated? If not, then has
>> > > >> anyone integrated any webflows in Ofbiz? Please let me know..
>> > > >>
>> > > >> Regards,
>> > > >> Deepa
>> > > >>
>> > > >> -----Original Message-----
>> > > >> From: varun bhansaly [mailto:[hidden email]]
>> > > >> Sent: Tuesday, September 07, 2010 1:38 PM
>> > > >> To: [hidden email]
>> > > >> Subject: Re: Ofbiz WorkFlow Engine
>> > > >>
>> > > >> Hi Deepa,
>> > > >> Are you looking at something like designing the process flow, for eg as
>> > > >> in
>> > > >> jBPM workflow engine& the process designer ?
>> > > >> Though processes could be implemented using SECAs, EECAs etc.
>> > > >>
>> > > >>
>> > > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
>> > > >> <[hidden email]>wrote:
>> > > >>
>> > > >>> Thanks Varun for replying.. I have checked this link but its talking
>> > > >>> about XPDL which actually comes with Shark implementation and in the
>> > > >>> same link they have mentioned that Shark is not yet implemented in
>> > > >>> Ofbiz. The alternative is event based. SO does this mean we don't have
>> > > >>> workflow definition type of design in Ofbiz as of now other then the
>> > > >>> events?
>> > > >>>
>> > > >>> Thanks,
>> > > >>> Deepa
>> > > >>>
>> > > >>> -----Original Message-----
>> > > >>> From: varun bhansaly [mailto:[hidden email]]
>> > > >>> Sent: Monday, September 06, 2010 9:57 PM
>> > > >>> To: [hidden email]
>> > > >>> Subject: Re: Ofbiz WorkFlow Engine
>> > > >>>
>> > > >>> Hi,
>> > > >>> This document might help http://ofbiz.apache.org/docs/workflow.html
>> > > >>>
>> > > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
>> > > >>> <[hidden email]>wrote:
>> > > >>>
>> > > >>>> Hi All,
>> > > >>>>
>> > > >>>>
>> > > >>>>
>> > > >>>> Need some help to know if we have any workflow integrated in ofbiz
>> > > >>> 9.04
>> > > >>>> version?
>> > > >>>>
>> > > >>>> if we already have the workflow is it using xpdl? Is it Shark
>> > > >>> workflow?
>> > > >>>> Please let me know.. need this urgently before i start designing for
>> > > >>> one
>> > > >>>> of my requirement.
>> > > >>>>
>> > > >>>>
>> > > >>>>
>> > > >>>> Appreciate your help.
>> > > >>>>
>> > > >>>>
>> > > >>>> Thanks& Regards,
>> > > >>>>
>> > > >>>> Deepa
>> > > >>>>
>> > > >>>>
>> > > >>>>
>> > > >>>>
>> > > >>>>
>> > > >>>>
>> > > >>>>
>> > > >> ========================================================================
>> > > >>> ====================================================Disclaimer:
>> > > >>>> This message and the information contained herein is proprietary
>> > > >> and
>> > > >>>> confidential and subject to the Tech Mahindra policy statement, you
>> > > >>> may
>> > > >>>> review the policy at<a
>> > > >>> href="http://www.techmahindra.com/Disclaimer.html
>> > > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>> > > >>> href="
>> > > >>>> http://tim.techmahindra.com/Disclaimer.html">
>> > > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
>> > > >> Tech
>> > > >> Mahindra.===============================================================
>> > > >>> =============================================================
>> > > >>>
>> > > >>>
>> > > >>> --
>> > > >>> Regards,
>> > > >>> Varun Bhansaly
>> > > >>>
>> > > >>>
>> > > >> ========================================================================
>> > > >> ====================================================Disclaimer:
>> > > >>> This message and the information contained herein is proprietary and
>> > > >>> confidential and subject to the Tech Mahindra policy statement, you
>> > > >> may
>> > > >>> review the policy at<a
>> > > >> href="http://www.techmahindra.com/Disclaimer.html
>> > > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>> > > >> href="
>> > > >>> http://tim.techmahindra.com/Disclaimer.html">
>> > > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
>> > > Tech
>> > > >>>
>> > > >> Mahindra.===============================================================
>> > > >> =============================================================
>> > > >>
>> > > >>
>> > > >
>> > >
>> > > ============================================================================================================================Disclaimer:
>> > > This message and the information contained herein is proprietary and
>> > > confidential and subject to the Tech Mahindra policy statement, you may
>> > > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
>> > > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
>> > > http://tim.techmahindra.com/Disclaimer.html">
>> > > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
>> > > Mahindra.============================================================================================================================
>> >
>> >
>> >
>> >
>> > ============================================================================================================================Disclaimer:
>> > This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy
>> > statement, you may review the policy at <a
>> > href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a
>> > href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
>> > Mahindra.============================================================================================================================
>> >
>> >
>> >
>> >
>>
>>
>>
>>
>>
>> ============================================================================================================================Disclaimer:
>> This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy
>> statement, you may review the policy at <a
>> href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a
>> href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
>> Mahindra.============================================================================================================================
>

Shi Jinghai

Re: Ofbiz WorkFlow Engine

Yes, Hani Suleiman.

在 2010-09-14二的 12:26 +0200，Jacques Le Roux写道：

> From: "Shi Jinghai" <[hidden email]>
> > Hi Jack,
> >
> > I respect Hans' great work on OSWorkflow. Only 2 questions on OFBiz
>
> I guess you meant Hani's
> http://www.opensymphony.com/osworkflow/members.action
>
> Jacques
>
> > OSWorkflow integration:
> > 1. Support hot deploy a workflow in OFBiz? If yes, how the ongoing
> > processes run when a new version workflow deployed?
> > 2. Support UI generation according to workflow definition?
> >
> > Regards,
> >
> > Shi Jinghai/Beijing Langhua Ltd.
> >
> >
> > 在 2010-09-14二的 14:33 +0800，Jack Liu写道：
> >> I recommend OSWorkflow and it's easier to master.
> >>
> >>
> >>
> >> -----Original Message-----
> >> From: Deepa Priolkar [mailto:[hidden email]]
> >> Sent: 2010年9月14日 14:25
> >> To: [hidden email]; [hidden email]
> >> Subject: RE: Ofbiz WorkFlow Engine
> >>
> >> Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has
> >> asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other
> >> classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it
> >> clashes...
> >>
> >> 2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed:
> >> org.jbpm.taskmgmt.log.TaskAssignLog
> >> java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
> >> at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
> >> at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
> >> at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
> >> at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)
> >>
> >> Regards,
> >> Deepa
> >> -----Original Message-----
> >> From: Deepa Priolkar [mailto:[hidden email]]
> >> Sent: Tue 9/14/2010 11:45 AM
> >> To: [hidden email]
> >> Subject: RE: Ofbiz WorkFlow Engine
> >>
> >>
> >> Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.
> >>
> >> However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not
> >> found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby
> >> database.. Please advice..
> >>
> >> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not
> >> exist.
> >> 2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
> >> Method public static java.util.List
> >> org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue)
> >> threw an exception
> >> The problematic instruction:
> >> ----------
> >> ==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on
> >> line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
> >> ----------
> >>
> >> Java backtrace for programmers:
> >> ----------
> >> freemarker.template.TemplateModelException: Method public static java.util.List
> >> org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue)
> >> threw an exception
> >> at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
> >> at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
> >> at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
> >>
> >> Regards,
> >> Deepa
> >>
> >> -----Original Message-----
> >> From: Shi Jinghai [mailto:[hidden email]]
> >> Sent: Mon 9/13/2010 3:06 PM
> >> To: [hidden email]
> >> Subject: RE: Ofbiz WorkFlow Engine
> >>
> >> Hi Deepa,
> >>
> >> The ofbiz-jbpm component is developed in maven style. We use eclipse +
> >> iam as our standard develop tool.
> >>
> >> You can find the built components in our maven repository:
> >> http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/
> >>
> >> http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/
> >>
> >> Download the zip files and unzip them to your ofbiz, rebuild (I changed
> >> the StringUtil.java to make it work for iframe in htmlreport), add the 2
> >> components to component-load.xml, config
> >> ${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
> >> database and restart ofbiz, that's all. The jbpm tables will be created
> >> automatically during startup.
> >>
> >> The htmlreport is a tool to show the procedures of importing jbpm
> >> process file and etc in web browser. There's demos in the component. You
> >> can remove it from your tool bar if it works.
> >>
> >> Good luck,
> >>
> >> Shi Jinghai/Beijing Langhua Ltd.
> >>
> >>
> >> ? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:
> >> > can someone tell me how to create table in the derby database?
> >> >
> >> > ________________________________
> >> >
> >> > From: Deepa Priolkar [mailto:[hidden email]]
> >> > Sent: Sun 9/12/2010 10:25 PM
> >> > To: [hidden email]
> >> > Subject: RE: Ofbiz WorkFlow Engine
> >> >
> >> >
> >> >
> >> > Hi,
> >> >
> >> > I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..
> >> >
> >> > When i am trying to start the server, i am getting following error, Please help..
> >> >
> >> > 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries
> >> >
> >> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >> >
> >> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.
> >> >
> >> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01
> >> >
> >> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection
> >> > made to existing database instead.
> >> >
> >> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >> >
> >> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.
> >> >
> >> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could
> >> > not execute query using iterate
> >> >
> >> > 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR]
> >> > org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> >> >
> >> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers
> >> >
> >> > org.jbpm.JbpmException: couldn't find timers from the database
> >> >
> >> > at org.jbpm.db.
> >> >
> >> >
> >> >
> >> > ________________________________
> >> >
> >> > From: Deepa Priolkar [mailto:[hidden email]]
> >> > Sent: Sun 9/12/2010 8:41 PM
> >> > To: [hidden email]; [hidden email]
> >> > Subject: RE: Ofbiz WorkFlow Engine
> >> >
> >> >
> >> >
> >> > Hi,
> >> >
> >> > I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,
> >> >
> >> > snippet from the logs
> >> >
> >> > 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource:
> >> > java:comp/env/jBPM_DS
> >> > javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException:
> >> > org.ofbiz.entity.datasource.GenericHelperDAO]
> >> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
> >> > at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
> >> > at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
> >> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> >> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> >> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> >> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> >> > at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
> >> > at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
> >> > at javax.naming.InitialContext.lookup(InitialContext.java:351)
> >> > at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
> >> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
> >> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
> >> > at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
> >> > at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
> >> > at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
> >> > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
> >> > at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
> >> > at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
> >> > at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
> >> > at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
> >> > at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
> >> > at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
> >> > at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
> >> > Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
> >> > at java.lang.Class.newInstance0(Class.java:335)
> >> > at java.lang.Class.newInstance(Class.java:303)
> >> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
> >> > ... 23 more
> >> >
> >> > -----Original Message-----
> >> > From: Deepa Priolkar [mailto:[hidden email]]
> >> > Sent: Sun 9/12/2010 8:37 PM
> >> > To: [hidden email]
> >> > Subject: RE: Ofbiz WorkFlow Engine
> >> >
> >> >
> >> > Hi,
> >> >
> >> > Need some help in JBPM integration, I have followed the steps mentioned in the link given below.
> >> >
> >> > Now for the database i want to use derby instead of MySQL...
> >> > I have configured following in the context.xml (runtime/catalina/conf/context.xml)
> >> > <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
> >> > maxActive="30" maxIdle="3" maxWait="2000"
> >> > username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
> >> > factory="org.ofbiz.entity.datasource.GenericHelperDAO"
> >> > url="jdbc:derby:ofbiz;create=true"/>
> >> >
> >> > </Context>
> >> >
> >> > Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also
> >> >
> >> > <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
> >> > <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>
> >> >
> >> > Regards,
> >> > Deepa
> >> >
> >> >
> >> > -----Original Message-----
> >> > From: [hidden email] on behalf of Jeroen van der Wal
> >> > Sent: Thu 9/9/2010 5:37 PM
> >> > To: [hidden email]
> >> > Subject: Re: Ofbiz WorkFlow Engine
> >> >
> >> > There's SVn access available. Instructions here:
> >> > http://www.langhua.cn/download/ofbiz-jbpm.html
> >> >
> >> > -Jeroen
> >> >
> >> > On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:
> >> >
> >> > > Hi Shi,
> >> > >
> >> > > Can you please help me to download the code from the location mentioned
> >> > > below? I tried FTP it did not work. Please advice.
> >> > >
> >> > >
> >> > > On 9/7/10 5:51 AM, Shi Jinghai wrote:
> >> > > > Here is a OFBiz-jBPM component:
> >> > > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
> >> > > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
> >> > > >
> >> > > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
> >> > > > of jBPM.
> >> > > >
> >> > > > OSWorkflow can also work with OFBiz.
> >> > > >
> >> > > > Personally I like jBPM.
> >> > > >
> >> > > > Regards,
> >> > > >
> >> > > > Shi Jinghai/Beijing Langhua Ltd.
> >> > > >
> >> > > >
> >> > > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
> >> > > >> Hi Varun,
> >> > > >>
> >> > > >> Yes I am looking for something similar to JBPM, not fullfledge but
> >> > > >> atleast it should have the configuration through XML (similar to Shark).
> >> > > >> Do we have something like this in Ofbiz integrated? If not, then has
> >> > > >> anyone integrated any webflows in Ofbiz? Please let me know..
> >> > > >>
> >> > > >> Regards,
> >> > > >> Deepa
> >> > > >>
> >> > > >> -----Original Message-----
> >> > > >> From: varun bhansaly [mailto:[hidden email]]
> >> > > >> Sent: Tuesday, September 07, 2010 1:38 PM
> >> > > >> To: [hidden email]
> >> > > >> Subject: Re: Ofbiz WorkFlow Engine
> >> > > >>
> >> > > >> Hi Deepa,
> >> > > >> Are you looking at something like designing the process flow, for eg as
> >> > > >> in
> >> > > >> jBPM workflow engine& the process designer ?
> >> > > >> Though processes could be implemented using SECAs, EECAs etc.
> >> > > >>
> >> > > >>
> >> > > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
> >> > > >> <[hidden email]>wrote:
> >> > > >>
> >> > > >>> Thanks Varun for replying.. I have checked this link but its talking
> >> > > >>> about XPDL which actually comes with Shark implementation and in the
> >> > > >>> same link they have mentioned that Shark is not yet implemented in
> >> > > >>> Ofbiz. The alternative is event based. SO does this mean we don't have
> >> > > >>> workflow definition type of design in Ofbiz as of now other then the
> >> > > >>> events?
> >> > > >>>
> >> > > >>> Thanks,
> >> > > >>> Deepa
> >> > > >>>
> >> > > >>> -----Original Message-----
> >> > > >>> From: varun bhansaly [mailto:[hidden email]]
> >> > > >>> Sent: Monday, September 06, 2010 9:57 PM
> >> > > >>> To: [hidden email]
> >> > > >>> Subject: Re: Ofbiz WorkFlow Engine
> >> > > >>>
> >> > > >>> Hi,
> >> > > >>> This document might help http://ofbiz.apache.org/docs/workflow.html
> >> > > >>>
> >> > > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
> >> > > >>> <[hidden email]>wrote:
> >> > > >>>
> >> > > >>>> Hi All,
> >> > > >>>>
> >> > > >>>>
> >> > > >>>>
> >> > > >>>> Need some help to know if we have any workflow integrated in ofbiz
> >> > > >>> 9.04
> >> > > >>>> version?
> >> > > >>>>
> >> > > >>>> if we already have the workflow is it using xpdl? Is it Shark
> >> > > >>> workflow?
> >> > > >>>> Please let me know.. need this urgently before i start designing for
> >> > > >>> one
> >> > > >>>> of my requirement.
> >> > > >>>>
> >> > > >>>>
> >> > > >>>>
> >> > > >>>> Appreciate your help.
> >> > > >>>>
> >> > > >>>>
> >> > > >>>> Thanks& Regards,
> >> > > >>>>
> >> > > >>>> Deepa
> >> > > >>>>
> >> > > >>>>
> >> > > >>>>
> >> > > >>>>
> >> > > >>>>
> >> > > >>>>
> >> > > >>>>
> >> > > >> ========================================================================
> >> > > >>> ====================================================Disclaimer:
> >> > > >>>> This message and the information contained herein is proprietary
> >> > > >> and
> >> > > >>>> confidential and subject to the Tech Mahindra policy statement, you
> >> > > >>> may
> >> > > >>>> review the policy at<a
> >> > > >>> href="http://www.techmahindra.com/Disclaimer.html
> >> > > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> >> > > >>> href="
> >> > > >>>> http://tim.techmahindra.com/Disclaimer.html">
> >> > > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> >> > > >> Tech
> >> > > >> Mahindra.===============================================================
> >> > > >>> =============================================================
> >> > > >>>
> >> > > >>>
> >> > > >>> --
> >> > > >>> Regards,
> >> > > >>> Varun Bhansaly
> >> > > >>>
> >> > > >>>
> >> > > >> ========================================================================
> >> > > >> ====================================================Disclaimer:
> >> > > >>> This message and the information contained herein is proprietary and
> >> > > >>> confidential and subject to the Tech Mahindra policy statement, you
> >> > > >> may
> >> > > >>> review the policy at<a
> >> > > >> href="http://www.techmahindra.com/Disclaimer.html
> >> > > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> >> > > >> href="
> >> > > >>> http://tim.techmahindra.com/Disclaimer.html">
> >> > > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> >> > > Tech
> >> > > >>>
> >> > > >> Mahindra.===============================================================
> >> > > >> =============================================================
> >> > > >>
> >> > > >>
> >> > > >
> >> > >
> >> > > ============================================================================================================================Disclaimer:
> >> > > This message and the information contained herein is proprietary and
> >> > > confidential and subject to the Tech Mahindra policy statement, you may
> >> > > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
> >> > > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
> >> > > http://tim.techmahindra.com/Disclaimer.html">
> >> > > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> >> > > Mahindra.============================================================================================================================
> >> >
> >> >
> >> >
> >> >
> >> > ============================================================================================================================Disclaimer:
> >> > This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy
> >> > statement, you may review the policy at <a
> >> > href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a
> >> > href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> >> > Mahindra.============================================================================================================================
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >>
> >>
> >> ============================================================================================================================Disclaimer:
> >> This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy
> >> statement, you may review the policy at <a
> >> href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a
> >> href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> >> Mahindra.============================================================================================================================
> >
>
>

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

In reply to this post by Deepa Priolkar

Thanks Shi.. I have done the integration, but one query regarding the process definition.
In one of the step its mentioned to create the "sample.process" and upload it.. I did not catch up on how to create this file..tried all the scripts but no luck..please advice.

Regards,
Deepa

-----Original Message-----
From: Shi Jinghai [mailto:[hidden email]]
Sent: Mon 9/13/2010 3:06 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi Deepa,

The ofbiz-jbpm component is developed in maven style. We use eclipse +
iam as our standard develop tool.

You can find the built components in our maven repository:
http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

Download the zip files and unzip them to your ofbiz, rebuild (I changed
the StringUtil.java to make it work for iframe in htmlreport), add the 2
components to component-load.xml, config
${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
database and restart ofbiz, that's all. The jbpm tables will be created
automatically during startup.

The htmlreport is a tool to show the procedures of importing jbpm
process file and etc in web browser. There's demos in the component. You
can remove it from your tool bar if it works.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:

Shi Jinghai

RE: Ofbiz WorkFlow Engine

Hi Deepa,

Edit the project pom.xml, make processes module available, and run maven
package, the sample.process will be built under processes/target/
<modules>

<module>processes</module>
</modules>

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

在 2010-09-15三的 02:00 +0530，Deepa Priolkar写道：

> Thanks Shi.. I have done the integration, but one query regarding the process definition.
> In one of the step its mentioned to create the "sample.process" and upload it.. I did not catch up on how to create this file..tried all the scripts but no luck..please advice.
>
> Regards,
> Deepa
>
>
> -----Original Message-----
> From: Shi Jinghai [mailto:[hidden email]]
> Sent: Mon 9/13/2010 3:06 PM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
> Hi Deepa,
>
> The ofbiz-jbpm component is developed in maven style. We use eclipse +
> iam as our standard develop tool.
>
> You can find the built components in our maven repository:
> http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/
>
> http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/
>
> Download the zip files and unzip them to your ofbiz, rebuild (I changed
> the StringUtil.java to make it work for iframe in htmlreport), add the 2
> components to component-load.xml, config
> ${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
> database and restart ofbiz, that's all. The jbpm tables will be created
> automatically during startup.
>
> The htmlreport is a tool to show the procedures of importing jbpm
> process file and etc in web browser. There's demos in the component. You
> can remove it from your tool bar if it works.
>
> Good luck,
>
> Shi Jinghai/Beijing Langhua Ltd.
>
>
> ? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:
> > can someone tell me how to create table in the derby database?
> >
> > ________________________________
> >
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 10:25 PM
> > To: [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> >
> > Hi,
> >
> > I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..
> >
> > When i am trying to start the server, i am getting following error, Please help..
> >
> > 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01
> >
> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> >
> > 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> >
> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers
> >
> > org.jbpm.JbpmException: couldn't find timers from the database
> >
> > at org.jbpm.db.
> >
> >
> >
> > ________________________________
> >
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 8:41 PM
> > To: [hidden email]; [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> >
> > Hi,
> >
> > I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,
> >
> > snippet from the logs
> >
> > 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
> > javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
> > at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
> > at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
> > at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
> > at javax.naming.InitialContext.lookup(InitialContext.java:351)
> > at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
> > at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
> > at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
> > at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
> > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
> > at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
> > at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
> > at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
> > at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
> > at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
> > at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
> > at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
> > Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
> > at java.lang.Class.newInstance0(Class.java:335)
> > at java.lang.Class.newInstance(Class.java:303)
> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
> > ... 23 more
> >
> > -----Original Message-----
> > From: Deepa Priolkar [mailto:[hidden email]]
> > Sent: Sun 9/12/2010 8:37 PM
> > To: [hidden email]
> > Subject: RE: Ofbiz WorkFlow Engine
> >
> >
> > Hi,
> >
> > Need some help in JBPM integration, I have followed the steps mentioned in the link given below.
> >
> > Now for the database i want to use derby instead of MySQL...
> > I have configured following in the context.xml (runtime/catalina/conf/context.xml)
> > <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
> > maxActive="30" maxIdle="3" maxWait="2000"
> > username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
> > factory="org.ofbiz.entity.datasource.GenericHelperDAO"
> > url="jdbc:derby:ofbiz;create=true"/>
> >
> > </Context>
> >
> > Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also
> >
> > <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
> > <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>
> >
> > Regards,
> > Deepa
> >
> >
> > -----Original Message-----
> > From: [hidden email] on behalf of Jeroen van der Wal
> > Sent: Thu 9/9/2010 5:37 PM
> > To: [hidden email]
> > Subject: Re: Ofbiz WorkFlow Engine
> >
> > There's SVn access available. Instructions here:
> > http://www.langhua.cn/download/ofbiz-jbpm.html
> >
> > -Jeroen
> >
> > On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:
> >
> > > Hi Shi,
> > >
> > > Can you please help me to download the code from the location mentioned
> > > below? I tried FTP it did not work. Please advice.
> > >
> > >
> > > On 9/7/10 5:51 AM, Shi Jinghai wrote:
> > > > Here is a OFBiz-jBPM component:
> > > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
> > > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
> > > >
> > > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
> > > > of jBPM.
> > > >
> > > > OSWorkflow can also work with OFBiz.
> > > >
> > > > Personally I like jBPM.
> > > >
> > > > Regards,
> > > >
> > > > Shi Jinghai/Beijing Langhua Ltd.
> > > >
> > > >
> > > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
> > > >> Hi Varun,
> > > >>
> > > >> Yes I am looking for something similar to JBPM, not fullfledge but
> > > >> atleast it should have the configuration through XML (similar to Shark).
> > > >> Do we have something like this in Ofbiz integrated? If not, then has
> > > >> anyone integrated any webflows in Ofbiz? Please let me know..
> > > >>
> > > >> Regards,
> > > >> Deepa
> > > >>
> > > >> -----Original Message-----
> > > >> From: varun bhansaly [mailto:[hidden email]]
> > > >> Sent: Tuesday, September 07, 2010 1:38 PM
> > > >> To: [hidden email]
> > > >> Subject: Re: Ofbiz WorkFlow Engine
> > > >>
> > > >> Hi Deepa,
> > > >> Are you looking at something like designing the process flow, for eg as
> > > >> in
> > > >> jBPM workflow engine& the process designer ?
> > > >> Though processes could be implemented using SECAs, EECAs etc.
> > > >>
> > > >>
> > > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
> > > >> <[hidden email]>wrote:
> > > >>
> > > >>> Thanks Varun for replying.. I have checked this link but its talking
> > > >>> about XPDL which actually comes with Shark implementation and in the
> > > >>> same link they have mentioned that Shark is not yet implemented in
> > > >>> Ofbiz. The alternative is event based. SO does this mean we don't have
> > > >>> workflow definition type of design in Ofbiz as of now other then the
> > > >>> events?
> > > >>>
> > > >>> Thanks,
> > > >>> Deepa
> > > >>>
> > > >>> -----Original Message-----
> > > >>> From: varun bhansaly [mailto:[hidden email]]
> > > >>> Sent: Monday, September 06, 2010 9:57 PM
> > > >>> To: [hidden email]
> > > >>> Subject: Re: Ofbiz WorkFlow Engine
> > > >>>
> > > >>> Hi,
> > > >>> This document might help http://ofbiz.apache.org/docs/workflow.html
> > > >>>
> > > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
> > > >>> <[hidden email]>wrote:
> > > >>>
> > > >>>> Hi All,
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>> Need some help to know if we have any workflow integrated in ofbiz
> > > >>> 9.04
> > > >>>> version?
> > > >>>>
> > > >>>> if we already have the workflow is it using xpdl? Is it Shark
> > > >>> workflow?
> > > >>>> Please let me know.. need this urgently before i start designing for
> > > >>> one
> > > >>>> of my requirement.
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>> Appreciate your help.
> > > >>>>
> > > >>>>
> > > >>>> Thanks& Regards,
> > > >>>>
> > > >>>> Deepa
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >>>>
> > > >> ========================================================================
> > > >>> ====================================================Disclaimer:
> > > >>>> This message and the information contained herein is proprietary
> > > >> and
> > > >>>> confidential and subject to the Tech Mahindra policy statement, you
> > > >>> may
> > > >>>> review the policy at<a
> > > >>> href="http://www.techmahindra.com/Disclaimer.html
> > > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > > >>> href="
> > > >>>> http://tim.techmahindra.com/Disclaimer.html">
> > > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > > >> Tech
> > > >> Mahindra.===============================================================
> > > >>> =============================================================
> > > >>>
> > > >>>
> > > >>> --
> > > >>> Regards,
> > > >>> Varun Bhansaly
> > > >>>
> > > >>>
> > > >> ========================================================================
> > > >> ====================================================Disclaimer:
> > > >>> This message and the information contained herein is proprietary and
> > > >>> confidential and subject to the Tech Mahindra policy statement, you
> > > >> may
> > > >>> review the policy at<a
> > > >> href="http://www.techmahindra.com/Disclaimer.html
> > > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
> > > >> href="
> > > >>> http://tim.techmahindra.com/Disclaimer.html">
> > > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
> > > Tech
> > > >>>
> > > >> Mahindra.===============================================================
> > > >> =============================================================
> > > >>
> > > >>
> > > >
> > >
> > > ============================================================================================================================Disclaimer:
> > > This message and the information contained herein is proprietary and
> > > confidential and subject to the Tech Mahindra policy statement, you may
> > > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
> > > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
> > > http://tim.techmahindra.com/Disclaimer.html">
> > > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
> > > Mahindra.============================================================================================================================
> >
> >
> >
> >
> > ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
> >
> >
> >
> >
>
>
>

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

In reply to this post by Deepa Priolkar

Hi,

I am facing one issue while inserting data into the JBPM_USER_ID table, here the ID is auto_increment and primary key..but the JBPM workflow tries to programmatically enter value against this column, because of which I am getting the error.. Please help.

2010-09-15 15:13:20,208 (http-0.0.0.0-8443-1) [ AbstractBatcher.java:346:DEBUG] insert into JBPM_ID_USER (NAME_, EMAIL_, PASSWORD_, CLASS_, ID_) values (?, ?, ?, 'U', ?)
2010-09-15 15:13:20,208 (http-0.0.0.0-8443-1) [ AbstractBatcher.java:424:TRACE] preparing statement
2010-09-15 15:13:20,208 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:63 :DEBUG] could not insert: [org.jbpm.identity.User] [insert into JBPM_ID_USER (NAME_, EMAIL_, PASSWORD_, CLASS_, ID_) values (?, ?, ?, 'U', ?)]
java.sql.SQLException: Attempt to modify an identity column 'ID_'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)

-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Tuesday, September 14, 2010 11:55 AM
To: [hidden email]; [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it clashes...

2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed: org.jbpm.taskmgmt.log.TaskAssignLog
java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)

Regards,
Deepa
-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Tue 9/14/2010 11:45 AM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.

However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby database.. Please advice..

2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
The problematic instruction:
----------
==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
----------

Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

Regards,
Deepa

-----Original Message-----
From: Shi Jinghai [mailto:[hidden email]]
Sent: Mon 9/13/2010 3:06 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi Deepa,

The ofbiz-jbpm component is developed in maven style. We use eclipse +
iam as our standard develop tool.

You can find the built components in our maven repository:
http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

Download the zip files and unzip them to your ofbiz, rebuild (I changed
the StringUtil.java to make it work for iframe in htmlreport), add the 2
components to component-load.xml, config
${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
database and restart ofbiz, that's all. The jbpm tables will be created
automatically during startup.

The htmlreport is a tool to show the procedures of importing jbpm
process file and etc in web browser. There's demos in the component. You
can remove it from your tool bar if it works.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

Ignore this question, this is fixed now :)

-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Wednesday, September 15, 2010 4:17 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi,

I am facing one issue while inserting data into the JBPM_USER_ID table, here the ID is auto_increment and primary key..but the JBPM workflow tries to programmatically enter value against this column, because of which I am getting the error.. Please help.

2010-09-15 15:13:20,208 (http-0.0.0.0-8443-1) [ AbstractBatcher.java:346:DEBUG] insert into JBPM_ID_USER (NAME_, EMAIL_, PASSWORD_, CLASS_, ID_) values (?, ?, ?, 'U', ?)
2010-09-15 15:13:20,208 (http-0.0.0.0-8443-1) [ AbstractBatcher.java:424:TRACE] preparing statement
2010-09-15 15:13:20,208 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:63 :DEBUG] could not insert: [org.jbpm.identity.User] [insert into JBPM_ID_USER (NAME_, EMAIL_, PASSWORD_, CLASS_, ID_) values (?, ?, ?, 'U', ?)]
java.sql.SQLException: Attempt to modify an identity column 'ID_'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)

-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Tuesday, September 14, 2010 11:55 AM
To: [hidden email]; [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Also one more concern, when i am starting the server i am seeing some more error. this error is due to the asm.jar. Ofbiz has asm2.2.jar which does not have the CodeVisitor class, and i cannot include the older version because it does not have many other classes used by Groovy.. please suggest how we can resolve this error.. cos two versions of asm cannot exists in one workspace it clashes...

2010-09-14 11:54:46,453 (JbpmCommandExecutor) [CGLIBLazyInitializer.java:130:ERROR] CGLIB Enhancement failed: org.jbpm.taskmgmt.log.TaskAssignLog
java.lang.NoClassDefFoundError: org/objectweb/asm/CodeVisitor
at net.sf.cglib.core.KeyFactory$Generator.generateClass(KeyFactory.java:165)
at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:25)
at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)

Regards,
Deepa
-----Original Message-----
From: Deepa Priolkar [mailto:[hidden email]]
Sent: Tue 9/14/2010 11:45 AM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Thanks Shi... i have done the necessary configurations in my workspace for the JBPM integration as adviced below.

However when i am trying to run the application, on clicking "New WorkFlow" I am getting table/view "HIBERNATE_UNIQUE_KEY" not found error in the logs. I have created all the tables as mentioned in the create.sql.. please note that i am using derby database.. Please advice..

2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'HIBERNATE_UNIQUE_KEY' does not exist.
2010-09-14 11:42:47,328 (http-0.0.0.0-8443-1) [ Log4JLoggerFactory.java:96 :ERROR]
Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
The problematic instruction:
----------
==> assignment: processList=Static["org.langhua.ofbiz.jbpm.OFBizNewProcessInstance"].getWorkflowOptions(delegator,userLogin) [on line 19, column 1 in component://jbpm/webapp/jbpm/jbpm/newWorkflow.ftl]
----------

Java backtrace for programmers:
----------
freemarker.template.TemplateModelException: Method public static java.util.List org.langhua.ofbiz.jbpm.OFBizNewProcessInstance.getWorkflowOptions(org.ofbiz.entity.GenericDelegator,org.ofbiz.entity.GenericValue) threw an exception
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:125)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

Regards,
Deepa

-----Original Message-----
From: Shi Jinghai [mailto:[hidden email]]
Sent: Mon 9/13/2010 3:06 PM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi Deepa,

The ofbiz-jbpm component is developed in maven style. We use eclipse +
iam as our standard develop tool.

You can find the built components in our maven repository:
http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

Download the zip files and unzip them to your ofbiz, rebuild (I changed
the StringUtil.java to make it work for iframe in htmlreport), add the 2
components to component-load.xml, config
${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
database and restart ofbiz, that's all. The jbpm tables will be created
automatically during startup.

The htmlreport is a tool to show the procedures of importing jbpm
process file and etc in web browser. There's demos in the component. You
can remove it from your tool bar if it works.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:

============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

Deepa Priolkar

RE: Ofbiz WorkFlow Engine

In reply to this post by Shi Jinghai

Hi Shi,

I have build the sample.process zip file. But it does not have the productdefination.xml file. I am totally new to Maven script, I am using the same script which you had provided not sure how to edit that file to add the productdefination.xml

As of now it has only

Pom.xml

Pom.properties

MANIFEST.MF

OfBizJBPMSample.class

If I try to upload the same zip I am getting error, Please advice.

org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://jbpm/widget/JbpmScreens.xml#uploadProcess]: org.ofbiz.base.util.GeneralException: Error running BSH script at location [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh] (Error running BSH script at [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh], line [34]: Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit : at Line: 34 : in file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : upload .actionCommit ( request )

Target exception: org.jbpm.jpdl.JpdlException: [[ERROR] no processdefinition.xml inside process archive]

(Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit)) (Error running BSH script at location [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh] (Error running BSH script at [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh], line [34]: Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit : at Line: 34 : in file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : upload .actionCommit ( request )

Target exception: org.jbpm.jpdl.JpdlException: [[ERROR] no processdefinition.xml inside process archive]

(Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit)))

Thanks & Regards,

Deepa

-----Original Message-----
From: Shi Jinghai [mailto:[hidden email]]
Sent: Wednesday, September 15, 2010 2:43 AM
To: [hidden email]
Subject: RE: Ofbiz WorkFlow Engine

Hi Deepa,

Edit the project pom.xml, make processes module available, and run maven

package, the sample.process will be built under processes/target/

<modules>



<module>processes</module>

</modules>

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

在 2010-09-15三的 02:00 +0530，Deepa Priolkar写道：

> Thanks Shi.. I have done the integration, but one query regarding the process definition.

> In one of the step its mentioned to create the "sample.process" and upload it.. I did not catch up on how to create this file..tried all the scripts but no luck..please advice.

>

> Regards,

> Deepa

>

>

> -----Original Message-----

> From: Shi Jinghai [mailto:[hidden email]]

> Sent: Mon 9/13/2010 3:06 PM

> To: [hidden email]

> Subject: RE: Ofbiz WorkFlow Engine

>

> Hi Deepa,

>

> The ofbiz-jbpm component is developed in maven style. We use eclipse +

> iam as our standard develop tool.

>

> You can find the built components in our maven repository:

> http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/

>

> http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/

>

> Download the zip files and unzip them to your ofbiz, rebuild (I changed

> the StringUtil.java to make it work for iframe in htmlreport), add the 2

> components to component-load.xml, config

> ${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your

> database and restart ofbiz, that's all. The jbpm tables will be created

> automatically during startup.

>

> The htmlreport is a tool to show the procedures of importing jbpm

> process file and etc in web browser. There's demos in the component. You

> can remove it from your tool bar if it works.

>

> Good luck,

>

> Shi Jinghai/Beijing Langhua Ltd.

>

>

> ? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:

> > can someone tell me how to create table in the derby database?

> >

> > ________________________________

> >

> > From: Deepa Priolkar [mailto:[hidden email]]

> > Sent: Sun 9/12/2010 10:25 PM

> > To: [hidden email]

> > Subject: RE: Ofbiz WorkFlow Engine

> >

> >

> >

> > Hi,

> >

> > I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..

> >

> > When i am trying to start the server, i am getting following error, Please help..

> >

> > 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries

> >

> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05

> >

> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.

> >

> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01

> >

> > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.

> >

> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05

> >

> > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.

> >

> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

> >

> > 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

> >

> > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers

> >

> > org.jbpm.JbpmException: couldn't find timers from the database

> >

> > at org.jbpm.db.

> >

> >

> >

> > ________________________________

> >

> > From: Deepa Priolkar [mailto:[hidden email]]

> > Sent: Sun 9/12/2010 8:41 PM

> > To: [hidden email]; [hidden email]

> > Subject: RE: Ofbiz WorkFlow Engine

> >

> >

> >

> > Hi,

> >

> > I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,

> >

> > snippet from the logs

> >

> > 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS

> > javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]

> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)

> > at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)

> > at org.apache.naming.NamingContext.lookup(NamingContext.java:793)

> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)

> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)

> > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)

> > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)

> > at org.apache.naming.NamingContext.lookup(NamingContext.java:153)

> > at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)

> > at javax.naming.InitialContext.lookup(InitialContext.java:351)

> > at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)

> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)

> > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)

> > at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)

> > at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)

> > at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)

> > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)

> > at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)

> > at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)

> > at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)

> > at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)

> > at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)

> > at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)

> > at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)

> > Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO

> > at java.lang.Class.newInstance0(Class.java:335)

> > at java.lang.Class.newInstance(Class.java:303)

> > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)

> > ... 23 more

> >

> > -----Original Message-----

> > From: Deepa Priolkar [mailto:[hidden email]]

> > Sent: Sun 9/12/2010 8:37 PM

> > To: [hidden email]

> > Subject: RE: Ofbiz WorkFlow Engine

> >

> >

> > Hi,

> >

> > Need some help in JBPM integration, I have followed the steps mentioned in the link given below.

> >

> > Now for the database i want to use derby instead of MySQL...

> > I have configured following in the context.xml (runtime/catalina/conf/context.xml)

> > <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"

> > maxActive="30" maxIdle="3" maxWait="2000"

> > username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"

> > factory="org.ofbiz.entity.datasource.GenericHelperDAO"

> > url="jdbc:derby:ofbiz;create=true"/>

> >

> > </Context>

> >

> > Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also

> >

> > <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>

> > <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>

> >

> > Regards,

> > Deepa

> >

> >

> > -----Original Message-----

> > From: [hidden email] on behalf of Jeroen van der Wal

> > Sent: Thu 9/9/2010 5:37 PM

> > To: [hidden email]

> > Subject: Re: Ofbiz WorkFlow Engine

> >

> > There's SVn access available. Instructions here:

> > http://www.langhua.cn/download/ofbiz-jbpm.html

> >

> > -Jeroen

> >

> > On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:

> >

> > > Hi Shi,

> > >

> > > Can you please help me to download the code from the location mentioned

> > > below? I tried FTP it did not work. Please advice.

> > >

> > >

> > > On 9/7/10 5:51 AM, Shi Jinghai wrote:

> > > > Here is a OFBiz-jBPM component:

> > > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%

> > > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F

> > > >

> > > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future

> > > > of jBPM.

> > > >

> > > > OSWorkflow can also work with OFBiz.

> > > >

> > > > Personally I like jBPM.

> > > >

> > > > Regards,

> > > >

> > > > Shi Jinghai/Beijing Langhua Ltd.

> > > >

> > > >

> > > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s

> > > >> Hi Varun,

> > > >>

> > > >> Yes I am looking for something similar to JBPM, not fullfledge but

> > > >> atleast it should have the configuration through XML (similar to Shark).

> > > >> Do we have something like this in Ofbiz integrated? If not, then has

> > > >> anyone integrated any webflows in Ofbiz? Please let me know..

> > > >>

> > > >> Regards,

> > > >> Deepa

> > > >>

> > > >> -----Original Message-----

> > > >> From: varun bhansaly [mailto:[hidden email]]

> > > >> Sent: Tuesday, September 07, 2010 1:38 PM

> > > >> To: [hidden email]

> > > >> Subject: Re: Ofbiz WorkFlow Engine

> > > >>

> > > >> Hi Deepa,

> > > >> Are you looking at something like designing the process flow, for eg as

> > > >> in

> > > >> jBPM workflow engine& the process designer ?

> > > >> Though processes could be implemented using SECAs, EECAs etc.

> > > >>

> > > >>

> > > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar

> > > >> <[hidden email]>wrote:

> > > >>

> > > >>> Thanks Varun for replying.. I have checked this link but its talking

> > > >>> about XPDL which actually comes with Shark implementation and in the

> > > >>> same link they have mentioned that Shark is not yet implemented in

> > > >>> Ofbiz. The alternative is event based. SO does this mean we don't have

> > > >>> workflow definition type of design in Ofbiz as of now other then the

> > > >>> events?

> > > >>>

> > > >>> Thanks,

> > > >>> Deepa

> > > >>>

> > > >>> -----Original Message-----

> > > >>> From: varun bhansaly [mailto:[hidden email]]

> > > >>> Sent: Monday, September 06, 2010 9:57 PM

> > > >>> To: [hidden email]

> > > >>> Subject: Re: Ofbiz WorkFlow Engine

> > > >>>

> > > >>> Hi,

> > > >>> This document might help http://ofbiz.apache.org/docs/workflow.html

> > > >>>

> > > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar

> > > >>> <[hidden email]>wrote:

> > > >>>

> > > >>>> Hi All,

> > > >>>>

> > > >>>>

> > > >>>>

> > > >>>> Need some help to know if we have any workflow integrated in ofbiz

> > > >>> 9.04

> > > >>>> version?

> > > >>>>

> > > >>>> if we already have the workflow is it using xpdl? Is it Shark

> > > >>> workflow?

> > > >>>> Please let me know.. need this urgently before i start designing for

> > > >>> one

> > > >>>> of my requirement.

> > > >>>>

> > > >>>>

> > > >>>>

> > > >>>> Appreciate your help.

> > > >>>>

> > > >>>>

> > > >>>> Thanks& Regards,

> > > >>>>

> > > >>>> Deepa

> > > >>>>

> > > >>>>

> > > >>>>

> > > >>>>

> > > >>>>

> > > >>>>

> > > >>>>

> > > >> ========================================================================

> > > >>> ====================================================Disclaimer:

> > > >>>> This message and the information contained herein is proprietary

> > > >> and

> > > >>>> confidential and subject to the Tech Mahindra policy statement, you

> > > >>> may

> > > >>>> review the policy at<a

> > > >>> href="http://www.techmahindra.com/Disclaimer.html

> > > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a

> > > >>> href="

> > > >>>> http://tim.techmahindra.com/Disclaimer.html">

> > > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within

> > > >> Tech

> > > >> Mahindra.===============================================================

> > > >>> =============================================================

> > > >>>

> > > >>>

> > > >>> --

> > > >>> Regards,

> > > >>> Varun Bhansaly

> > > >>>

> > > >>>

> > > >> ========================================================================

> > > >> ====================================================Disclaimer:

> > > >>> This message and the information contained herein is proprietary and

> > > >>> confidential and subject to the Tech Mahindra policy statement, you

> > > >> may

> > > >>> review the policy at<a

> > > >> href="http://www.techmahindra.com/Disclaimer.html

> > > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a

> > > >> href="

> > > >>> http://tim.techmahindra.com/Disclaimer.html">

> > > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within

> > > Tech

> > > >>>

> > > >> Mahindra.===============================================================

> > > >> =============================================================

> > > >>

> > > >>

> > > >

> > >

> > > ============================================================================================================================Disclaimer:

> > > This message and the information contained herein is proprietary and

> > > confidential and subject to the Tech Mahindra policy statement, you may

> > > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html

> > > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="

> > > http://tim.techmahindra.com/Disclaimer.html">

> > > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech

> > > Mahindra.============================================================================================================================

> >

> >

> >

> >

> > ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

> >

> >

> >

> >

>

>

>

============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

Shi Jinghai

RE: Ofbiz WorkFlow Engine

Bug, now fixed. Please update the source code and rebuild.

Good luck,

Shi Jinghai/Beijing Langhua Ltd.

在 2010-09-16四的 16:16 +0530，Deepa Priolkar写道：

> Hi Shi,
>
>
>
> I have build the sample.process zip file. But it does not have the productdefination.xml file. I am totally new to Maven script, I am using the same script which you had provided not sure how to edit that file to add the productdefination.xml
>
>
>
> As of now it has only
>
> Pom.xml
>
> Pom.properties
>
> MANIFEST.MF
>
> OfBizJBPMSample.class
>
>
>
> If I try to upload the same zip I am getting error, Please advice.
>
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://jbpm/widget/JbpmScreens.xml#uploadProcess]: org.ofbiz.base.util.GeneralException: Error running BSH script at location [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh] (Error running BSH script at [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh], line [34]: Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit : at Line: 34 : in file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : upload .actionCommit ( request )
>
>
>
> Target exception: org.jbpm.jpdl.JpdlException: [[ERROR] no processdefinition.xml inside process archive]
>
> (Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit)) (Error running BSH script at location [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh] (Error running BSH script at [component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh], line [34]: Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit : at Line: 34 : in file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : upload .actionCommit ( request )
>
>
>
> Target exception: org.jbpm.jpdl.JpdlException: [[ERROR] no processdefinition.xml inside process archive]
>
> (Sourced file: component://jbpm/webapp/jbpm/WEB-INF/actions/jbpm/uploadProcess.bsh : Method Invocation upload.actionCommit)))
>
>
>
> Thanks & Regards,
>
> Deepa
>
>
>
>
>
> -----Original Message-----
> From: Shi Jinghai [mailto:[hidden email]]
> Sent: Wednesday, September 15, 2010 2:43 AM
> To: [hidden email]
> Subject: RE: Ofbiz WorkFlow Engine
>
>
>
> Hi Deepa,
>
>
>
> Edit the project pom.xml, make processes module available, and run maven
>
> package, the sample.process will be built under processes/target/
>
> <modules>
>
> 
>
> <module>processes</module>
>
> </modules>
>
>
>
> Good luck,
>
>
>
> Shi Jinghai/Beijing Langhua Ltd.
>
>
>
> 在 2010-09-15三的 02:00 +0530，Deepa Priolkar写道：
>
> > Thanks Shi.. I have done the integration, but one query regarding the process definition.
>
> > In one of the step its mentioned to create the "sample.process" and upload it.. I did not catch up on how to create this file..tried all the scripts but no luck..please advice.
>
> >
>
> > Regards,
>
> > Deepa
>
> >
>
> >
>
> > -----Original Message-----
>
> > From: Shi Jinghai [mailto:[hidden email]]
>
> > Sent: Mon 9/13/2010 3:06 PM
>
> > To: [hidden email]
>
> > Subject: RE: Ofbiz WorkFlow Engine
>
> >
>
> > Hi Deepa,
>
> >
>
> > The ofbiz-jbpm component is developed in maven style. We use eclipse +
>
> > iam as our standard develop tool.
>
> >
>
> > You can find the built components in our maven repository:
>
> > http://maven2.langhua.org/public/ofbiz/ofbiz-htmlreport/09.04/
>
> >
>
> > http://maven2.langhua.org/public/ofbiz/ofbiz-jbpm-core/09.04/
>
> >
>
> > Download the zip files and unzip them to your ofbiz, rebuild (I changed
>
> > the StringUtil.java to make it work for iframe in htmlreport), add the 2
>
> > components to component-load.xml, config
>
> > ${your_ofbiz_home}/runtime/catalina/conf/context.xml to fit your
>
> > database and restart ofbiz, that's all. The jbpm tables will be created
>
> > automatically during startup.
>
> >
>
> > The htmlreport is a tool to show the procedures of importing jbpm
>
> > process file and etc in web browser. There's demos in the component. You
>
> > can remove it from your tool bar if it works.
>
> >
>
> > Good luck,
>
> >
>
> > Shi Jinghai/Beijing Langhua Ltd.
>
> >
>
> >
>
> > ? 2010-09-12?? 22:29 +0530,Deepa Priolkar??:
>
> > > can someone tell me how to create table in the derby database?
>
> > >
>
> > > ________________________________
>
> > >
>
> > > From: Deepa Priolkar [mailto:[hidden email]]
>
> > > Sent: Sun 9/12/2010 10:25 PM
>
> > > To: [hidden email]
>
> > > Subject: RE: Ofbiz WorkFlow Engine
>
> > >
>
> > >
>
> > >
>
> > > Hi,
>
> > >
>
> > > I was able to solve the issue related to the database configuration, but looks like now i am totally stuck..
>
> > >
>
> > > When i am trying to start the server, i am getting following error, Please help..
>
> > >
>
> > > 2010-09-12 22:22:26,218 (JbpmCommandExecutor) [ SessionFactoryImpl.java:373:INFO ] Checking 0 named SQL queries
>
> > >
>
> > > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
>
> > >
>
> > > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_MESSAGE' does not exist.
>
> > >
>
> > > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:48 :WARN ] SQL Warning: 10000, SQLState: 01J01
>
> > >
>
> > > 2010-09-12 22:22:26,296 (JbpmCommandExecutor) [JDBCExceptionReporter.java:49 :WARN ] Database 'ofbiz' not created, connection made to existing database instead.
>
> > >
>
> > > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:71 :WARN ] SQL Error: 20000, SQLState: 42X05
>
> > >
>
> > > 2010-09-12 22:22:26,328 (JbpmScheduler) [JDBCExceptionReporter.java:72 :ERROR] Table/View 'JBPM_TIMER' does not exist.
>
> > >
>
> > > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerSession.java:86 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
>
> > >
>
> > > 2010-09-12 22:22:26,328 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
>
> > >
>
> > > 2010-09-12 22:22:26,328 (JbpmScheduler) [ SchedulerThread.java:79 :INFO ] runtime exception while executing timers
>
> > >
>
> > > org.jbpm.JbpmException: couldn't find timers from the database
>
> > >
>
> > > at org.jbpm.db.
>
> > >
>
> > >
>
> > >
>
> > > ________________________________
>
> > >
>
> > > From: Deepa Priolkar [mailto:[hidden email]]
>
> > > Sent: Sun 9/12/2010 8:41 PM
>
> > > To: [hidden email]; [hidden email]
>
> > > Subject: RE: Ofbiz WorkFlow Engine
>
> > >
>
> > >
>
> > >
>
> > > Hi,
>
> > >
>
> > > I forgot to mention that i am getting error after doing the configuration mentioned in my last mail,
>
> > >
>
> > > snippet from the logs
>
> > >
>
> > > 2010-09-12 20:23:29,953 (JbpmScheduler) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS
>
> > > javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO]
>
> > > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:102)
>
> > > at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
>
> > > at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
>
> > > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
>
> > > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
>
> > > at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
>
> > > at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
>
> > > at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
>
> > > at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
>
> > > at javax.naming.InitialContext.lookup(InitialContext.java:351)
>
> > > at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
>
> > > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
>
> > > at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
>
> > > at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
>
> > > at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
>
> > > at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
>
> > > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
>
> > > at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
>
> > > at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
>
> > > at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
>
> > > at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:245)
>
> > > at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
>
> > > at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:103)
>
> > > at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
>
> > > Caused by: java.lang.InstantiationException: org.ofbiz.entity.datasource.GenericHelperDAO
>
> > > at java.lang.Class.newInstance0(Class.java:335)
>
> > > at java.lang.Class.newInstance(Class.java:303)
>
> > > at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:98)
>
> > > ... 23 more
>
> > >
>
> > > -----Original Message-----
>
> > > From: Deepa Priolkar [mailto:[hidden email]]
>
> > > Sent: Sun 9/12/2010 8:37 PM
>
> > > To: [hidden email]
>
> > > Subject: RE: Ofbiz WorkFlow Engine
>
> > >
>
> > >
>
> > > Hi,
>
> > >
>
> > > Need some help in JBPM integration, I have followed the steps mentioned in the link given below.
>
> > >
>
> > > Now for the database i want to use derby instead of MySQL...
>
> > > I have configured following in the context.xml (runtime/catalina/conf/context.xml)
>
> > > <Resource name="jBPM_DS" auth="Container" type="javax.sql.DataSource" removeAbandoned="true"
>
> > > maxActive="30" maxIdle="3" maxWait="2000"
>
> > > username="ofbiz" password="ofbiz" driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>
> > > factory="org.ofbiz.entity.datasource.GenericHelperDAO"
>
> > > url="jdbc:derby:ofbiz;create=true"/>
>
> > >
>
> > > </Context>
>
> > >
>
> > > Please let me know what else i need to configure.. I have configured the hibernate.cfg.xml also
>
> > >
>
> > > <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
>
> > > <property name="hibernate.connection.datasource">java:comp/env/jBPM_DS</property>
>
> > >
>
> > > Regards,
>
> > > Deepa
>
> > >
>
> > >
>
> > > -----Original Message-----
>
> > > From: [hidden email] on behalf of Jeroen van der Wal
>
> > > Sent: Thu 9/9/2010 5:37 PM
>
> > > To: [hidden email]
>
> > > Subject: Re: Ofbiz WorkFlow Engine
>
> > >
>
> > > There's SVn access available. Instructions here:
>
> > > http://www.langhua.cn/download/ofbiz-jbpm.html
>
> > >
>
> > > -Jeroen
>
> > >
>
> > > On Thu, Sep 9, 2010 at 1:24 PM, Deepa Priolkar <[hidden email]>wrote:
>
> > >
>
> > > > Hi Shi,
>
> > > >
>
> > > > Can you please help me to download the code from the location mentioned
>
> > > > below? I tried FTP it did not work. Please advice.
>
> > > >
>
> > > >
>
> > > > On 9/7/10 5:51 AM, Shi Jinghai wrote:
>
> > > > > Here is a OFBiz-jBPM component:
>
> > > > > <a href="http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%">http://langhua.org/portal/portal/default/iframe?pageurl=%2Fviewvc%
>
> > > > > 2Fopensource%2Fofbiz%2Fofbiz-jbpm%2F
>
> > > > >
>
> > > > > As Tom has left jboss and go to Alfresco, I'm not sure what's the future
>
> > > > > of jBPM.
>
> > > > >
>
> > > > > OSWorkflow can also work with OFBiz.
>
> > > > >
>
> > > > > Personally I like jBPM.
>
> > > > >
>
> > > > > Regards,
>
> > > > >
>
> > > > > Shi Jinghai/Beijing Langhua Ltd.
>
> > > > >
>
> > > > >
>
> > > > > åo¨ 2010-09-07äºOçs" 14:47 +0530ï¼ODeepa Priolkarå?Té "ï¼s
>
> > > > >> Hi Varun,
>
> > > > >>
>
> > > > >> Yes I am looking for something similar to JBPM, not fullfledge but
>
> > > > >> atleast it should have the configuration through XML (similar to Shark).
>
> > > > >> Do we have something like this in Ofbiz integrated? If not, then has
>
> > > > >> anyone integrated any webflows in Ofbiz? Please let me know..
>
> > > > >>
>
> > > > >> Regards,
>
> > > > >> Deepa
>
> > > > >>
>
> > > > >> -----Original Message-----
>
> > > > >> From: varun bhansaly [mailto:[hidden email]]
>
> > > > >> Sent: Tuesday, September 07, 2010 1:38 PM
>
> > > > >> To: [hidden email]
>
> > > > >> Subject: Re: Ofbiz WorkFlow Engine
>
> > > > >>
>
> > > > >> Hi Deepa,
>
> > > > >> Are you looking at something like designing the process flow, for eg as
>
> > > > >> in
>
> > > > >> jBPM workflow engine& the process designer ?
>
> > > > >> Though processes could be implemented using SECAs, EECAs etc.
>
> > > > >>
>
> > > > >>
>
> > > > >> On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar
>
> > > > >> <[hidden email]>wrote:
>
> > > > >>
>
> > > > >>> Thanks Varun for replying.. I have checked this link but its talking
>
> > > > >>> about XPDL which actually comes with Shark implementation and in the
>
> > > > >>> same link they have mentioned that Shark is not yet implemented in
>
> > > > >>> Ofbiz. The alternative is event based. SO does this mean we don't have
>
> > > > >>> workflow definition type of design in Ofbiz as of now other then the
>
> > > > >>> events?
>
> > > > >>>
>
> > > > >>> Thanks,
>
> > > > >>> Deepa
>
> > > > >>>
>
> > > > >>> -----Original Message-----
>
> > > > >>> From: varun bhansaly [mailto:[hidden email]]
>
> > > > >>> Sent: Monday, September 06, 2010 9:57 PM
>
> > > > >>> To: [hidden email]
>
> > > > >>> Subject: Re: Ofbiz WorkFlow Engine
>
> > > > >>>
>
> > > > >>> Hi,
>
> > > > >>> This document might help http://ofbiz.apache.org/docs/workflow.html
>
> > > > >>>
>
> > > > >>> On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar
>
> > > > >>> <[hidden email]>wrote:
>
> > > > >>>
>
> > > > >>>> Hi All,
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>> Need some help to know if we have any workflow integrated in ofbiz
>
> > > > >>> 9.04
>
> > > > >>>> version?
>
> > > > >>>>
>
> > > > >>>> if we already have the workflow is it using xpdl? Is it Shark
>
> > > > >>> workflow?
>
> > > > >>>> Please let me know.. need this urgently before i start designing for
>
> > > > >>> one
>
> > > > >>>> of my requirement.
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>> Appreciate your help.
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>> Thanks& Regards,
>
> > > > >>>>
>
> > > > >>>> Deepa
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >>>>
>
> > > > >> ========================================================================
>
> > > > >>> ====================================================Disclaimer:
>
> > > > >>>> This message and the information contained herein is proprietary
>
> > > > >> and
>
> > > > >>>> confidential and subject to the Tech Mahindra policy statement, you
>
> > > > >>> may
>
> > > > >>>> review the policy at<a
>
> > > > >>> href="http://www.techmahindra.com/Disclaimer.html
>
> > > > >>>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>
> > > > >>> href="
>
> > > > >>>> http://tim.techmahindra.com/Disclaimer.html">
>
> > > > >>>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
>
> > > > >> Tech
>
> > > > >> Mahindra.===============================================================
>
> > > > >>> =============================================================
>
> > > > >>>
>
> > > > >>>
>
> > > > >>> --
>
> > > > >>> Regards,
>
> > > > >>> Varun Bhansaly
>
> > > > >>>
>
> > > > >>>
>
> > > > >> ========================================================================
>
> > > > >> ====================================================Disclaimer:
>
> > > > >>> This message and the information contained herein is proprietary and
>
> > > > >>> confidential and subject to the Tech Mahindra policy statement, you
>
> > > > >> may
>
> > > > >>> review the policy at<a
>
> > > > >> href="http://www.techmahindra.com/Disclaimer.html
>
> > > > >>> ">http://www.techmahindra.com/Disclaimer.html</a> externally and<a
>
> > > > >> href="
>
> > > > >>> http://tim.techmahindra.com/Disclaimer.html">
>
> > > > >>> http://tim.techmahindra.com/Disclaimer.html</a> internally within
>
> > > > Tech
>
> > > > >>>
>
> > > > >> Mahindra.===============================================================
>
> > > > >> =============================================================
>
> > > > >>
>
> > > > >>
>
> > > > >
>
> > > >
>
> > > > ============================================================================================================================Disclaimer:
>
> > > > This message and the information contained herein is proprietary and
>
> > > > confidential and subject to the Tech Mahindra policy statement, you may
>
> > > > review the policy at <a href="http://www.techmahindra.com/Disclaimer.html
>
> > > > ">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
>
> > > > http://tim.techmahindra.com/Disclaimer.html">
>
> > > > http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
>
> > > > Mahindra.============================================================================================================================
>
> > >
>
> > >
>
> > >
>
> > >
>
> > > ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
>
> > >
>
> > >
>
> > >
>
> > >
>
> >
>
> >
>
> >
>
>
>
>
> ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================

123