I recommend OSWorkflow and it's easier to master.
-----Original Message----- From: Deepa Priolkar [mailto:dee...@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:dee...@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:sh...@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:dee...@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:dee...@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:dee...@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: jvander...@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 <dee...@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:vbhans...@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 > > >> <dee...@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:vbhans...@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 > > >>> <dee...@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.============================================================================================================================
