ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Priolkar" <dee...@TechMahindra.com>
Subject RE: Ofbiz WorkFlow Engine
Date Thu, 16 Sep 2010 09:57:48 GMT
Ignore this question, this is fixed now :) 

-----Original Message-----
From: Deepa Priolkar [mailto:deepap@TechMahindra.com] 
Sent: Wednesday, September 15, 2010 4:17 PM
To: user@ofbiz.apache.org
Subject: RE: Ofbiz WorkFlow Engine

Hi,

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

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

-----Original Message-----
From: Deepa Priolkar [mailto:deepap@TechMahindra.com] 
Sent: Tuesday, September 14, 2010 11:55 AM
To: user@ofbiz.apache.org; user@ofbiz.apache.org
Subject: RE: Ofbiz WorkFlow Engine

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

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

Regards,
Deepa
-----Original Message-----
From: Deepa Priolkar [mailto:deepap@TechMahindra.com]
Sent: Tue 9/14/2010 11:45 AM
To: user@ofbiz.apache.org
Subject: RE: Ofbiz WorkFlow Engine
 

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

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

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

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

Regards,
Deepa

-----Original Message-----
From: Shi Jinghai [mailto:shijh@langhua.cn]
Sent: Mon 9/13/2010 3:06 PM
To: user@ofbiz.apache.org
Subject: RE: Ofbiz WorkFlow Engine
 
Hi Deepa,

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

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

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

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

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

Good luck,

Shi Jinghai/Beijing Langhua Ltd.


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





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

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

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

Mime
View raw message