Thanks Shi, I have successful done with the integration :)
Need one more favor from you, all the text is coming in Chinese :( can you please help me translate the same in English? if you can send me the updated ftl file it will help me alot. Thanks in advance. Thanks & Regards, Deepa -----Original Message----- From: Shi Jinghai [mailto:[hidden email]] Sent: Sun 9/19/2010 4:14 AM To: [hidden email] Subject: 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>core</module> --> > > <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.============================================================================================================================ |
Done. UI labels are in config/JBPMUiLabels.properties.
在 2010-09-19日的 22:35 +0530,Deepa Priolkar写道: > Thanks Shi, I have successful done with the integration :) > > Need one more favor from you, all the text is coming in Chinese :( can you please help me translate the same in English? if you can send me the updated ftl file it will help me alot. Thanks in advance. > > Thanks & Regards, > Deepa > > > -----Original Message----- > From: Shi Jinghai [mailto:[hidden email]] > Sent: Sun 9/19/2010 4:14 AM > To: [hidden email] > Subject: 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>core</module> --> > > > > <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.============================================================================================================================ > > > |
Thanks a lot Shi
-----Original Message----- From: Shi Jinghai [mailto:[hidden email]] Sent: Tuesday, September 21, 2010 3:55 AM To: [hidden email] Subject: RE: Ofbiz WorkFlow Engine Done. UI labels are in config/JBPMUiLabels.properties. 在 2010-09-19日的 22:35 +0530,Deepa Priolkar写道: > Thanks Shi, I have successful done with the integration :) > > Need one more favor from you, all the text is coming in Chinese :( can you please help me translate the same in English? if you can send me the updated ftl file it will help me alot. Thanks in advance. > > Thanks & Regards, > Deepa > > > -----Original Message----- > From: Shi Jinghai [mailto:[hidden email]] > Sent: Sun 9/19/2010 4:14 AM > To: [hidden email] > Subject: 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>core</module> --> > > > > <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.============================================================================================================================ > > > ============================================================================================================================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.============================================================================================================================ |
In reply to this post by Jack Liu-2
Can you give me some advice or guide on how to integrate osworkflow in ofbiz?
Thank you very much! |
this will give you what has been discussed so far
http://markmail.org/search/?q=ofbiz+workflow ========================= BJ Freeman 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 zhiyongcui sent the following on 11/2/2010 11:20 PM: > > Can you give me some advice or guide on how to integrate osworkflow in > ofbiz? > Thank you very much! |
I can't find anything valuable
|
In reply to this post by Shi Jinghai
Hi Shi
I have done what you said step by step.but I got a error message as below 2010-11-08 16:01:38,921 (JbpmCommandExecutor) [ NamingHelper.java:26 :INFO ] JNDI InitialContext properties:{} 2010-11-08 16:01:38,936 (JbpmCommandExecutor) [DatasourceConnectionProvider.java:55 :FATAL] Could not find datasource: java:comp/env/jBPM_DS javax.naming.NameNotFoundException: java:comp at com.sun.jndi.rmi.registry.RegistryContext.lookup(RegistryContext.java:99) at com.sun.jndi.rmi.registry.RegistryContext.lookup(RegistryContext.java:107) at javax.naming.InitialContext.lookup(InitialContext.java:392) 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.getMessagingSession(DbPersistenceService.java:236) at org.jbpm.JbpmContext.getMessagingSession(JbpmContext.java:521) at org.jbpm.msg.db.DbMessageService.<init>(DbMessageService.java:49) at org.jbpm.msg.db.DbMessageServiceFactory.openService(DbMessageServiceFactory.java:32) at org.jbpm.svc.Services.getService(Services.java:136) at org.jbpm.svc.Services.getMessageService(Services.java:172) at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExecutorThread.java:112) at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.java:79) 2010-11-08 16:01:38,936 (JbpmCommandExecutor) [CommandExecutorThread.java:88 :ERROR] org.hibernate.HibernateException: Could not find datasource what should I do then? |
Free forum by Nabble | Edit this page |