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.============================================================================================================================
