You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Kapil garg <ga...@hotmail.com> on 2010/10/30 11:16:51 UTC
RE:Stack Trace here for IllegalArgumentException--> Issues Creating
Entities in Ofbiz from existing Schema
This is the complete Stack Trace. Do I need a delegaotr for this. I did not put it as suggested by BJ however I d like to know what am I missing? I need to generate entities out of the existing schema in mysql
2010-10-30 11:12:07,809 (http-0.0.0.0-8443-1) [ ContextFilter.java:193:INFO ] [Request]: /webtools/control/view/ModelInduceFromDb
2010-10-30 11:12:07,810 (http-0.0.0.0-8443-1) [ ControlServlet.java:131:INFO ] [[[view] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-10-30 11:12:07,814 (http-0.0.0.0-8443-1) [ RequestHandler.java:697:INFO ] Rendering View [ModelInduceFromDb], sessionId=BEE5B18BDD3CE034ACFFCAAC40D343BC.jvm1
2010-10-30 11:12:07,838 (http-0.0.0.0-8443-1) [ApplicationDispatcher.java:662:ERROR] Servlet.service() for servlet jsp threw exception
java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
at org.ofbiz.entity.model.ModelFieldTypeReader.getModelFieldTypeReader(ModelFieldTypeReader.java:62)
at org.ofbiz.entity.datasource.GenericDAO.<init>(GenericDAO.java:87)
at org.ofbiz.entity.datasource.GenericDAO.getGenericDAO(GenericDAO.java:77)
at org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:100)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
at org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76)
at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:789)
at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:202)
at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
at org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:62)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2010-10-30 11:12:07,847 (http-0.0.0.0-8443-1) [ JspViewHandler.java:87 :ERROR]
---- runtime exception report --------------------------------------------------
ServletException rendering JSP view
Exception: java.lang.IllegalArgumentException
Message: Could not find a datasource/helper with the name mysql
---- stack trace ---------------------------------------------------------------
java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
org.ofbiz.entity.model.ModelFieldTypeReader.getModelFieldTypeReader(ModelFieldTypeReader.java:62)
org.ofbiz.entity.datasource.GenericDAO.<init>(GenericDAO.java:87)
org.ofbiz.entity.datasource.GenericDAO.getGenericDAO(GenericDAO.java:77)
org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:100)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:789)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:202)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:62)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2010-10-30 11:12:07,850 (http-0.0.0.0-8443-1) [ ControlServlet.java:205:ERROR]
---- runtime exception report --------------------------------------------------
Error in request handler:
Exception: java.lang.IllegalArgumentException
Message: Could not find a datasource/helper with the name mysql
---- stack trace ---------------------------------------------------------------
java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
org.ofbiz.entity.model.ModelFieldTypeReader.getModelFieldTypeReader(ModelFieldTypeReader.java:62)
org.ofbiz.entity.datasource.GenericDAO.<init>(GenericDAO.java:87)
org.ofbiz.entity.datasource.GenericDAO.getGenericDAO(GenericDAO.java:77)
org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:100)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:789)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:202)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:62)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2010-10-30 11:12:07,851 (http-0.0.0.0-8443-1) [ ControlServlet.java:221:ERROR] An error occurred, going to the errorPage: /error/error.jsp
2010-10-30 11:12:07,851 (http-0.0.0.0-8443-1) [ ControlServlet.java:228:ERROR] Including errorPage: /error/error.jsp
2010-10-30 11:12:08,213 (http-0.0.0.0-8443-1) [ ControlServlet.java:302:INFO ] [[[view] Request Done- total:0.403,since last([view] Request Be...):0.403]]
Kapil Garg
> From: gargkapil@hotmail.com
> To: user@ofbiz.apache.org
> Subject: IllegalArgumentException--> Issues Creating Entities in Ofbiz from existing Schema
> Date: Sat, 30 Oct 2010 18:57:04 +1000
>
>
> I just added mysql datasource tag but I got
> java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
> I restarted and still got the same exception. ANy help? This is a pretty coomon task for any application to do. Ofbiz being bottom up, someone has to statr with the defined external schema. I am quiete hopeful on ofbiz and the use rlist here, so would appreciate if you guys could contribute in spreading this technology so that more and more people could use it without difficulty.
>
>
> Kapil Garg
>
>
>
>
>
> > Date: Sat, 30 Oct 2010 00:59:02 -0700
> > From: bjfree@free-man.net
> > To: user@ofbiz.apache.org
> > Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> >
> > you should not assign the datasource as your default.
> > you should not change any of the code having to do with decelerators for
> > this step.
> >
> >
> >
> > =========================
> > 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
> > Santosh Singh sent the following on 10/29/2010 9:21 PM:
> > > *Hello Kapil,
> > > *Update your code, you are having two entries of same name it must look like
> > > <delegator name="default" entity-model-reader="main"
> > > entity-group-reader="main" entity-eca-reader="main"
> > > distributed-cache-clear-enabled="false">
> > > <group-map group-name="org.ofbiz" datasource-name="mysql"/>
> > > <group-map group-name="org.ofbiz.olap"
> > > datasource-name="localderbyolap"/>
> > > <group-map group-name="org.ofbiz.tenant"
> > > datasource-name="ocalderbytenant"/>
> > > </delegator>
> > > now create database and execute commands for "clean-all" and "run-install"
> > > Its done now.
> > > *
> > > Yours,
> > >
> > > Santosh Singh.*
> > >
> > >
> > >
> > > On Sat, Oct 30, 2010 at 1:52 AM, BJ Freeman<bj...@free-man.net> wrote:
> > >
> > >> just declare the datasource for you db.
> > >>
> > >>
> > >>
> > >> =========================
> > >> 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
> > >>
> > >>
> > >> Kapil garg sent the following on 10/29/2010 1:01 PM:
> > >>
> > >>
> > >>> Does that mean that I dont need to associate a datsource I create with a
> > >>> delagator ? As in the datasource entry need not have a group associated
> > >>> with it? or a delagator associated with it?
> > >>>
> > >>>
> > >>> Kapil Garg
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> Date: Fri, 29 Oct 2010 12:54:13 -0700
> > >>>> From: bjfree@free-man.net
> > >>>> To: user@ofbiz.apache.org
> > >>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> > >>>>
> > >>>> you did add more than the datasource
> > >>>> you make it default delegator.
> > >>>> this will cause the database to be updated with ofbiz schema
> > >>>>
> > >>>>
> > >>>> =========================
> > >>>>
> > >>>> 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
> > >>>>
> > >>>>
> > >>>> Kapil garg sent the following on 10/29/2010 12:45 PM:
> > >>>>
> > >>>>>
> > >>>>> Yes I created only the datasource by putting an entry in the
> > >>>>> entity-engine.xml file. I did not create anything else and intentionally put
> > >>>>> it in default delegator. Still I am not ale to Induce. IT says unrecognised
> > >>>>> datasource. I also get Null Pointer exception for localmysql datasource
> > >>>>> whose entry is already in there. DO I need to do anything else?
> > >>>>>
> > >>>>> Do I need to do ant run-install, restart before hitting induce?
> > >>>>>
> > >>>>>
> > >>>>> Kapil Garg
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>> Date: Fri, 29 Oct 2010 12:41:59 -0700
> > >>>>>> From: bjfree@free-man.net
> > >>>>>> To: user@ofbiz.apache.org
> > >>>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> > >>>>>>
> > >>>>>> only create a datasource. nothing else
> > >>>>>> the mysql one you created you use the name.
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>> =========================
> > >>>>>> 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
> > >>>>>>
> > >>>>>>
> > >>>>>> Kapil garg sent the following on 10/29/2010 12:29 PM:
> > >>>>>>
> > >>>>>>>
> > >>>>>>>
> > >>>>>>>
> > >>>>>>> I actually did use mysql as the datasource and tried using the link
> > >>>>>>> below by putting in the datasource name in the text box and clicking on
> > >>>>>>> Induce. For existing datasources name such as localmysql or localderby, I
> > >>>>>>> got a NullPointer Exception.
> > >>>>>>> For the one that I had an new entry witin the default delegator, I got
> > >>>>>>> " unrecognized datasource" name sort of message. Do I need to create a new
> > >>>>>>> entity-group.xml file for the datasource mysql I created below even if I am
> > >>>>>>> using a default delagator similar to the data-source localmysql? Does it
> > >>>>>>> need to be having group name org.ofbiz or something else within the
> > >>>>>>> delegator tag?
> > >>>>>>>
> > >>>>>>>
> > >>>>>>>
> > >>>>>>> Date: Fri, 29 Oct 2010 12:23:37 -0700
> > >>>>>>>> From: bjfree@free-man.net
> > >>>>>>>> To: user@ofbiz.apache.org
> > >>>>>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> > >>>>>>>>
> > >>>>>>>> use mysql as the datasource
> > >>>>>>>> https://localhost:8443/webtools/control/view/ModelInduceFromDb
> > >>>>>>>>
> > >>>>>>>> =========================
> > >>>>>>>> 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
> > >>>>>>>>
> > >>>>>>>>
> > >>>>>>>> Kapil garg sent the following on 10/29/2010 12:09 PM:
> > >>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>> I am trying to create a entities within OFbiz out of an existing
> > >>>>>>>>> schema in production. Not sure if this is the best way to create entties out
> > >>>>>>>>> of an existing schema. Suggestions are welcomed!!
> > >>>>>>>>>
> > >>>>>>>>> I tried to add a datasource tag in default delegator in
> > >>>>>>>>> entity-engine.xml
> > >>>>>>>>> Followed the instructions on
> > >>>>>>>>>
> > >>>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
> > >>>>>>>>> Would like to know where I am going wrong. On restart, I realised
> > >>>>>>>>> that ofbiz does not finish to the point that I can get webtools or even
> > >>>>>>>>> login for ecommerce. IT has just stuck at soem point saying
> > >>>>>>>>> ServiceDispatcher.java 584 INFO Sync service..
> > >>>>>>>>> There is no exception or anything but OFbiz does not go further with
> > >>>>>>>>> complete laoding. Anything I am doing wrong?
> > >>>>>>>>> Being a default delegaotr, there was no special entity-group.xml
> > >>>>>>>>> file in the ofbiz 9_04 code base. Hence I did not bother to create an
> > >>>>>>>>> entity-group.xml file
> > >>>>>>>>> My schema name is lronline, following are the entries I had in
> > >>>>>>>>> entity-engine.xml
> > >>>>>>>>> <delegator name="default" entity-model-reader="main"
> > >>>>>>>>> entity-group-reader="main" entity-eca-reader="main"
> > >>>>>>>>> distributed-cache-clear-enabled="false">
> > >>>>>>>>> <group-map group-name="org.ofbiz"
> > >>>>>>>>> datasource-name="localderby"/>
> > >>>>>>>>> <group-map group-name="org.ofbiz.olap"
> > >>>>>>>>> datasource-name="localderbyolap"/>
> > >>>>>>>>> <group-map group-name="org.ofbiz"
> > >>>>>>>>> datasource-name="mysql"/>
> > >>>>>>>>> </delegator>
> > >>>>>>>>>
> > >>>>>>>>> <datasource name="mysql"
> > >>>>>>>>>
> > >>>>>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > >>>>>>>>> field-type-name="mysql"
> > >>>>>>>>> check-on-start="true"
> > >>>>>>>>> add-missing-on-start="true"
> > >>>>>>>>> check-pks-on-start="false"
> > >>>>>>>>> use-foreign-keys="true"
> > >>>>>>>>> join-style="ansi-no-parenthesis"
> > >>>>>>>>> alias-view-columns="false"
> > >>>>>>>>> drop-fk-use-foreign-key-keyword="true"
> > >>>>>>>>> table-type="InnoDB"
> > >>>>>>>>> character-set="latin1"
> > >>>>>>>>> collate="latin1_general_cs">
> > >>>>>>>>> <read-data reader-name="seed"/>
> > >>>>>>>>> <read-data reader-name="seed-initial"/>
> > >>>>>>>>> <read-data reader-name="demo"/>
> > >>>>>>>>> <read-data reader-name="ext"/>
> > >>>>>>>>> <inline-jdbc
> > >>>>>>>>> jdbc-driver="com.mysql.jdbc.Driver"
> > >>>>>>>>> jdbc-uri="jdbc:mysql://
> > >>>>>>>>> 127.0.0.1/lronlineonedb?autoReconnect=true"
> > >>>>>>>>> jdbc-username="root"
> > >>>>>>>>> jdbc-password=""
> > >>>>>>>>> isolation-level="ReadCommitted"
> > >>>>>>>>> pool-minsize="2"
> > >>>>>>>>> pool-maxsize="250"/>
> > >>>>>>>>> <!--<jndi-jdbc jndi-server-name="localjndi"
> > >>>>>>>>> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
> > >>>>>>>>> </datasource>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>> Kapil Garg
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>>
> > >>>>>>>>
> > >>>>>>>>
> > >>>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>
> > >>>>
> > >>>>
> > >>>
> > >>
> > >>
> > >
>
RE: Stack Trace here for IllegalArgumentException--> Issues
Creating Entities in Ofbiz from existing Schema
Posted by Kapil garg <ga...@hotmail.com>.
The link here talks about adding the connector jar and having a delegator entry, which I already did, still I am still getting IllegalArgumentException
http://www.higherpass.com/apache/Tutorials/Configuring-Ofbiz-To-Use-A-Mysql-Database/
What about the creat-component task, do I need to run that and have a component so that mysql DB can be loaded?
Kapil Garg
> From: gargkapil@hotmail.com
> To: user@ofbiz.apache.org
> Subject: RE:Stack Trace here for IllegalArgumentException--> Issues Creating Entities in Ofbiz from existing Schema
> Date: Sat, 30 Oct 2010 19:16:51 +1000
>
>
>
> This is the complete Stack Trace. Do I need a delegaotr for this. I did not put it as suggested by BJ however I d like to know what am I missing? I need to generate entities out of the existing schema in mysql
> 2010-10-30 11:12:07,809 (http-0.0.0.0-8443-1) [ ContextFilter.java:193:INFO ] [Request]: /webtools/control/view/ModelInduceFromDb
> 2010-10-30 11:12:07,810 (http-0.0.0.0-8443-1) [ ControlServlet.java:131:INFO ] [[[view] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
> 2010-10-30 11:12:07,814 (http-0.0.0.0-8443-1) [ RequestHandler.java:697:INFO ] Rendering View [ModelInduceFromDb], sessionId=BEE5B18BDD3CE034ACFFCAAC40D343BC.jvm1
> 2010-10-30 11:12:07,838 (http-0.0.0.0-8443-1) [ApplicationDispatcher.java:662:ERROR] Servlet.service() for servlet jsp threw exception
> java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
> at org.ofbiz.entity.model.ModelFieldTypeReader.getModelFieldTypeReader(ModelFieldTypeReader.java:62)
> at org.ofbiz.entity.datasource.GenericDAO.<init>(GenericDAO.java:87)
> at org.ofbiz.entity.datasource.GenericDAO.getGenericDAO(GenericDAO.java:77)
> at org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:100)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
> at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
> at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
> at org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76)
> at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:789)
> at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
> at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:202)
> at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> at org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:62)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Thread.java:619)
> 2010-10-30 11:12:07,847 (http-0.0.0.0-8443-1) [ JspViewHandler.java:87 :ERROR]
> ---- runtime exception report --------------------------------------------------
> ServletException rendering JSP view
> Exception: java.lang.IllegalArgumentException
> Message: Could not find a datasource/helper with the name mysql
> ---- stack trace ---------------------------------------------------------------
> java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
> org.ofbiz.entity.model.ModelFieldTypeReader.getModelFieldTypeReader(ModelFieldTypeReader.java:62)
> org.ofbiz.entity.datasource.GenericDAO.<init>(GenericDAO.java:87)
> org.ofbiz.entity.datasource.GenericDAO.getGenericDAO(GenericDAO.java:77)
> org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:100)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
> org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:789)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:202)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:62)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-10-30 11:12:07,850 (http-0.0.0.0-8443-1) [ ControlServlet.java:205:ERROR]
> ---- runtime exception report --------------------------------------------------
> Error in request handler:
> Exception: java.lang.IllegalArgumentException
> Message: Could not find a datasource/helper with the name mysql
> ---- stack trace ---------------------------------------------------------------
> java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
> org.ofbiz.entity.model.ModelFieldTypeReader.getModelFieldTypeReader(ModelFieldTypeReader.java:62)
> org.ofbiz.entity.datasource.GenericDAO.<init>(GenericDAO.java:87)
> org.ofbiz.entity.datasource.GenericDAO.getGenericDAO(GenericDAO.java:77)
> org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:100)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
> org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:789)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:202)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:62)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-10-30 11:12:07,851 (http-0.0.0.0-8443-1) [ ControlServlet.java:221:ERROR] An error occurred, going to the errorPage: /error/error.jsp
> 2010-10-30 11:12:07,851 (http-0.0.0.0-8443-1) [ ControlServlet.java:228:ERROR] Including errorPage: /error/error.jsp
> 2010-10-30 11:12:08,213 (http-0.0.0.0-8443-1) [ ControlServlet.java:302:INFO ] [[[view] Request Done- total:0.403,since last([view] Request Be...):0.403]]
>
>
>
> Kapil Garg
>
>
>
>
>
> > From: gargkapil@hotmail.com
> > To: user@ofbiz.apache.org
> > Subject: IllegalArgumentException--> Issues Creating Entities in Ofbiz from existing Schema
> > Date: Sat, 30 Oct 2010 18:57:04 +1000
> >
> >
> > I just added mysql datasource tag but I got
> > java.lang.IllegalArgumentException: Could not find a datasource/helper with the name mysql
> > I restarted and still got the same exception. ANy help? This is a pretty coomon task for any application to do. Ofbiz being bottom up, someone has to statr with the defined external schema. I am quiete hopeful on ofbiz and the use rlist here, so would appreciate if you guys could contribute in spreading this technology so that more and more people could use it without difficulty.
> >
> >
> > Kapil Garg
> >
> >
> >
> >
> >
> > > Date: Sat, 30 Oct 2010 00:59:02 -0700
> > > From: bjfree@free-man.net
> > > To: user@ofbiz.apache.org
> > > Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> > >
> > > you should not assign the datasource as your default.
> > > you should not change any of the code having to do with decelerators for
> > > this step.
> > >
> > >
> > >
> > > =========================
> > > 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
> > > Santosh Singh sent the following on 10/29/2010 9:21 PM:
> > > > *Hello Kapil,
> > > > *Update your code, you are having two entries of same name it must look like
> > > > <delegator name="default" entity-model-reader="main"
> > > > entity-group-reader="main" entity-eca-reader="main"
> > > > distributed-cache-clear-enabled="false">
> > > > <group-map group-name="org.ofbiz" datasource-name="mysql"/>
> > > > <group-map group-name="org.ofbiz.olap"
> > > > datasource-name="localderbyolap"/>
> > > > <group-map group-name="org.ofbiz.tenant"
> > > > datasource-name="ocalderbytenant"/>
> > > > </delegator>
> > > > now create database and execute commands for "clean-all" and "run-install"
> > > > Its done now.
> > > > *
> > > > Yours,
> > > >
> > > > Santosh Singh.*
> > > >
> > > >
> > > >
> > > > On Sat, Oct 30, 2010 at 1:52 AM, BJ Freeman<bj...@free-man.net> wrote:
> > > >
> > > >> just declare the datasource for you db.
> > > >>
> > > >>
> > > >>
> > > >> =========================
> > > >> 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
> > > >>
> > > >>
> > > >> Kapil garg sent the following on 10/29/2010 1:01 PM:
> > > >>
> > > >>
> > > >>> Does that mean that I dont need to associate a datsource I create with a
> > > >>> delagator ? As in the datasource entry need not have a group associated
> > > >>> with it? or a delagator associated with it?
> > > >>>
> > > >>>
> > > >>> Kapil Garg
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>> Date: Fri, 29 Oct 2010 12:54:13 -0700
> > > >>>> From: bjfree@free-man.net
> > > >>>> To: user@ofbiz.apache.org
> > > >>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> > > >>>>
> > > >>>> you did add more than the datasource
> > > >>>> you make it default delegator.
> > > >>>> this will cause the database to be updated with ofbiz schema
> > > >>>>
> > > >>>>
> > > >>>> =========================
> > > >>>>
> > > >>>> 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
> > > >>>>
> > > >>>>
> > > >>>> Kapil garg sent the following on 10/29/2010 12:45 PM:
> > > >>>>
> > > >>>>>
> > > >>>>> Yes I created only the datasource by putting an entry in the
> > > >>>>> entity-engine.xml file. I did not create anything else and intentionally put
> > > >>>>> it in default delegator. Still I am not ale to Induce. IT says unrecognised
> > > >>>>> datasource. I also get Null Pointer exception for localmysql datasource
> > > >>>>> whose entry is already in there. DO I need to do anything else?
> > > >>>>>
> > > >>>>> Do I need to do ant run-install, restart before hitting induce?
> > > >>>>>
> > > >>>>>
> > > >>>>> Kapil Garg
> > > >>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>> Date: Fri, 29 Oct 2010 12:41:59 -0700
> > > >>>>>> From: bjfree@free-man.net
> > > >>>>>> To: user@ofbiz.apache.org
> > > >>>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> > > >>>>>>
> > > >>>>>> only create a datasource. nothing else
> > > >>>>>> the mysql one you created you use the name.
> > > >>>>>>
> > > >>>>>>
> > > >>>>>>
> > > >>>>>>
> > > >>>>>> =========================
> > > >>>>>> 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
> > > >>>>>>
> > > >>>>>>
> > > >>>>>> Kapil garg sent the following on 10/29/2010 12:29 PM:
> > > >>>>>>
> > > >>>>>>>
> > > >>>>>>>
> > > >>>>>>>
> > > >>>>>>> I actually did use mysql as the datasource and tried using the link
> > > >>>>>>> below by putting in the datasource name in the text box and clicking on
> > > >>>>>>> Induce. For existing datasources name such as localmysql or localderby, I
> > > >>>>>>> got a NullPointer Exception.
> > > >>>>>>> For the one that I had an new entry witin the default delegator, I got
> > > >>>>>>> " unrecognized datasource" name sort of message. Do I need to create a new
> > > >>>>>>> entity-group.xml file for the datasource mysql I created below even if I am
> > > >>>>>>> using a default delagator similar to the data-source localmysql? Does it
> > > >>>>>>> need to be having group name org.ofbiz or something else within the
> > > >>>>>>> delegator tag?
> > > >>>>>>>
> > > >>>>>>>
> > > >>>>>>>
> > > >>>>>>> Date: Fri, 29 Oct 2010 12:23:37 -0700
> > > >>>>>>>> From: bjfree@free-man.net
> > > >>>>>>>> To: user@ofbiz.apache.org
> > > >>>>>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
> > > >>>>>>>>
> > > >>>>>>>> use mysql as the datasource
> > > >>>>>>>> https://localhost:8443/webtools/control/view/ModelInduceFromDb
> > > >>>>>>>>
> > > >>>>>>>> =========================
> > > >>>>>>>> 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
> > > >>>>>>>>
> > > >>>>>>>>
> > > >>>>>>>> Kapil garg sent the following on 10/29/2010 12:09 PM:
> > > >>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>> I am trying to create a entities within OFbiz out of an existing
> > > >>>>>>>>> schema in production. Not sure if this is the best way to create entties out
> > > >>>>>>>>> of an existing schema. Suggestions are welcomed!!
> > > >>>>>>>>>
> > > >>>>>>>>> I tried to add a datasource tag in default delegator in
> > > >>>>>>>>> entity-engine.xml
> > > >>>>>>>>> Followed the instructions on
> > > >>>>>>>>>
> > > >>>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
> > > >>>>>>>>> Would like to know where I am going wrong. On restart, I realised
> > > >>>>>>>>> that ofbiz does not finish to the point that I can get webtools or even
> > > >>>>>>>>> login for ecommerce. IT has just stuck at soem point saying
> > > >>>>>>>>> ServiceDispatcher.java 584 INFO Sync service..
> > > >>>>>>>>> There is no exception or anything but OFbiz does not go further with
> > > >>>>>>>>> complete laoding. Anything I am doing wrong?
> > > >>>>>>>>> Being a default delegaotr, there was no special entity-group.xml
> > > >>>>>>>>> file in the ofbiz 9_04 code base. Hence I did not bother to create an
> > > >>>>>>>>> entity-group.xml file
> > > >>>>>>>>> My schema name is lronline, following are the entries I had in
> > > >>>>>>>>> entity-engine.xml
> > > >>>>>>>>> <delegator name="default" entity-model-reader="main"
> > > >>>>>>>>> entity-group-reader="main" entity-eca-reader="main"
> > > >>>>>>>>> distributed-cache-clear-enabled="false">
> > > >>>>>>>>> <group-map group-name="org.ofbiz"
> > > >>>>>>>>> datasource-name="localderby"/>
> > > >>>>>>>>> <group-map group-name="org.ofbiz.olap"
> > > >>>>>>>>> datasource-name="localderbyolap"/>
> > > >>>>>>>>> <group-map group-name="org.ofbiz"
> > > >>>>>>>>> datasource-name="mysql"/>
> > > >>>>>>>>> </delegator>
> > > >>>>>>>>>
> > > >>>>>>>>> <datasource name="mysql"
> > > >>>>>>>>>
> > > >>>>>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > > >>>>>>>>> field-type-name="mysql"
> > > >>>>>>>>> check-on-start="true"
> > > >>>>>>>>> add-missing-on-start="true"
> > > >>>>>>>>> check-pks-on-start="false"
> > > >>>>>>>>> use-foreign-keys="true"
> > > >>>>>>>>> join-style="ansi-no-parenthesis"
> > > >>>>>>>>> alias-view-columns="false"
> > > >>>>>>>>> drop-fk-use-foreign-key-keyword="true"
> > > >>>>>>>>> table-type="InnoDB"
> > > >>>>>>>>> character-set="latin1"
> > > >>>>>>>>> collate="latin1_general_cs">
> > > >>>>>>>>> <read-data reader-name="seed"/>
> > > >>>>>>>>> <read-data reader-name="seed-initial"/>
> > > >>>>>>>>> <read-data reader-name="demo"/>
> > > >>>>>>>>> <read-data reader-name="ext"/>
> > > >>>>>>>>> <inline-jdbc
> > > >>>>>>>>> jdbc-driver="com.mysql.jdbc.Driver"
> > > >>>>>>>>> jdbc-uri="jdbc:mysql://
> > > >>>>>>>>> 127.0.0.1/lronlineonedb?autoReconnect=true"
> > > >>>>>>>>> jdbc-username="root"
> > > >>>>>>>>> jdbc-password=""
> > > >>>>>>>>> isolation-level="ReadCommitted"
> > > >>>>>>>>> pool-minsize="2"
> > > >>>>>>>>> pool-maxsize="250"/>
> > > >>>>>>>>> <!--<jndi-jdbc jndi-server-name="localjndi"
> > > >>>>>>>>> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
> > > >>>>>>>>> </datasource>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>> Kapil Garg
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>>
> > > >>>>>>>>
> > > >>>>>>>>
> > > >>>>>>>
> > > >>>>>>
> > > >>>>>>
> > > >>>>>
> > > >>>>
> > > >>>>
> > > >>>
> > > >>
> > > >>
> > > >
> >
>