ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux" <jacques.le.r...@les7arts.com>
Subject Re: Ofbiz WorkFlow Engine
Date Tue, 14 Sep 2010 10:26:03 GMT
From: "Shi Jinghai" <shijh@langhua.cn>
> 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:deepap@TechMahindra.com]
>> Sent: 2010年9月14日 14:25
>> To: user@ofbiz.apache.org; user@ofbiz.apache.org
>> 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:deepap@TechMahindra.com]
>> Sent: Tue 9/14/2010 11:45 AM
>> To: user@ofbiz.apache.org
>> 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:shijh@langhua.cn]
>> Sent: Mon 9/13/2010 3:06 PM
>> To: user@ofbiz.apache.org
>> 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:deepap@TechMahindra.com]
>> > Sent: Sun 9/12/2010 10:25 PM
>> > To: user@ofbiz.apache.org
>> > 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:deepap@TechMahindra.com]
>> > Sent: Sun 9/12/2010 8:41 PM
>> > To: user@ofbiz.apache.org; user@ofbiz.apache.org
>> > 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:deepap@TechMahindra.com]
>> > Sent: Sun 9/12/2010 8:37 PM
>> > To: user@ofbiz.apache.org
>> > 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: jvanderwal@stromboli.it on behalf of Jeroen van der Wal
>> > Sent: Thu 9/9/2010 5:37 PM
>> > To: user@ofbiz.apache.org
>> > 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 <deepap@techmahindra.com>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:
>> > > > 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:vbhansaly@gmail.com]
>> > > >> Sent: Tuesday, September 07, 2010 1:38 PM
>> > > >> To: user@ofbiz.apache.org
>> > > >> 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
>> > > >> <deepap@techmahindra.com>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:vbhansaly@gmail.com]
>> > > >>> Sent: Monday, September 06, 2010 9:57 PM
>> > > >>> To: user@ofbiz.apache.org
>> > > >>> 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
>> > > >>> <deepap@techmahindra.com>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.============================================================================================================================
> 



Mime
View raw message