I recommend OSWorkflow and it's easier to master.
-----Original Message-----
From: Deepa Priolkar [mailto:[email protected]]
Sent: 2010年9月14日 14:25
To: [email protected]; [email protected]
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:[email protected]]
Sent: Tue 9/14/2010 11:45 AM
To: [email protected]
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:[email protected]]
Sent: Mon 9/13/2010 3:06 PM
To: [email protected]
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:[email protected]]
> Sent: Sun 9/12/2010 10:25 PM
> To: [email protected]
> 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:[email protected]]
> Sent: Sun 9/12/2010 8:41 PM
> To: [email protected]; [email protected]
> 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:[email protected]]
> Sent: Sun 9/12/2010 8:37 PM
> To: [email protected]
> 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: [email protected] on behalf of Jeroen van der Wal
> Sent: Thu 9/9/2010 5:37 PM
> To: [email protected]
> 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 <[email protected]>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:[email protected]]
> > >> Sent: Tuesday, September 07, 2010 1:38 PM
> > >> To: [email protected]
> > >> 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
> > >> <[email protected]>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:[email protected]]
> > >>> Sent: Monday, September 06, 2010 9:57 PM
> > >>> To: [email protected]
> > >>> 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
> > >>> <[email protected]>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.============================================================================================================================
