OFBiz › OFBiz - User

MySql related

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Selvakumar Ganesan

MySql related

*This is what I got when I followed steps to configure MySql and used url to
check whether it worked fine.What should I do to get rid of this?
*

*type* Exception report

*message*

*description* *The server encountered an internal error () that prevented it
from fulfilling this request.*

*exception*

java.lang.IllegalArgumentException: Could not get next sequenced ID
for sequence name: Visit
org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3123)
org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3109)
org.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:553)
org.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:703)
org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:169)
org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:88)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:185)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)

*note* *The full stack trace of the root cause is available in the Apache
Tomcat/6.0.16 logs.*

Ashish Vijaywargiya

Re: MySql related

Few questions:

1) Are you using trunk? Which version?
2) Are you deploying application on external tomcat?

--
Ashish

On Tue, Apr 27, 2010 at 10:38 AM, Selvakumar Ganesan
<[hidden email]> wrote:

> *This is what I got when I followed steps to configure MySql and used url to
> check whether it worked fine.What should I do to get rid of this?
> *
>
> *type* Exception report
>
> *message*
>
> *description* *The server encountered an internal error () that prevented it
> from fulfilling this request.*
>
> *exception*
>
> java.lang.IllegalArgumentException: Could not get next sequenced ID
> for sequence name: Visit
> org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3123)
> org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3109)
> org.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:553)
> org.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:703)
> org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:169)
> org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:88)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:185)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
>
> *note* *The full stack trace of the root cause is available in the Apache
> Tomcat/6.0.16 logs.*
>

Selvakumar Ganesan

Re: MySql related

On Tue, Apr 27, 2010 at 11:20 AM, Ashish Vijaywargiya <
[hidden email]> wrote:

> Few questions:
>
> 1) Are you using trunk? Which version?
> 2) Are you deploying application on external tomcat?
>
> --
> Ashish
>
> On Tue, Apr 27, 2010 at 10:38 AM, Selvakumar Ganesan
> <[hidden email]> wrote:
> > *This is what I got when I followed steps to configure MySql and used url
> to
> > check whether it worked fine.What should I do to get rid of this?
> > *
> >
> > *type* Exception report
> >
> > *message*
> >
> > *description* *The server encountered an internal error () that prevented
> it
> > from fulfilling this request.*
> >
> > *exception*
> >
> > java.lang.IllegalArgumentException: Could not get next sequenced ID
> > for sequence name: Visit
> >
> org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3123)
> >
> org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3109)
> >
> org.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:553)
> >
> org.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:703)
> >
> org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:169)
> >
> org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:88)
> >
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:185)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> >
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
> >
> > *note* *The full stack trace of the root cause is available in the Apache
> > Tomcat/6.0.16 logs.*
> >I am using ofbiz-release9.04.when I configured I got many xml exception
> like
>

[java] org.ofbiz.base.start.Start.main(Start.java:399)
[java] --------------------------------------------------------------------
------------
[java]
[java] 2010-04-27 12:29:46,171 (main) [ GenericDelegator.java:143:ERROR]

[java] ---- exception report ----------------------------------------------
------------
[java] Error creating delegator
[java] Exception: org.ofbiz.entity.GenericEntityConfException
[java] Message: Could not find a delegator with the name default
[java] ---- stack trace ---------------------------------------------------
------------
[java] org.ofbiz.entity.GenericEntityConfException: Could not find a delega
tor with the name default
[java] org.ofbiz.entity.model.ModelReader.getModelReader(ModelReader.java:8
4)
[java] org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:246)
[java] org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegat
or.java:141)
[java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa
dContainer.java:193)
[java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:
101)
[java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
[java] org.ofbiz.base.start.Start.startServer(Start.java:312)
[java] org.ofbiz.base.start.Start.start(Start.java:316)
[java] org.ofbiz.base.start.Start.main(Start.java:399)
[java] --------------------------------------------------------------------
------------
[java]
[java] 2010-04-27 12:29:46,171 (main) [ GenericDelegator.java:148:ERROR]
Could not create delegator with name default, constructor failed (got null
value
) not sure why/how.
[java] 2010-04-27 12:29:46,171 (OFBiz_Shutdown_Hook) [ ContainerLoader.j
ava:114:INFO ] Shutting down containers
[java] Java Result: 99

BUILD SUCCESSFUL

I want to know how it is configured that entity-engine.xml "odbcmysql"
datasource .

BJ Freeman

Re: MySql related

In reply to this post by Selvakumar Ganesan

look in the ofbiz.log for any reference to the db.
it looks like you have not setup the mysql in the entityengine.xml or in
the mysql server.

=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>

Selvakumar Ganesan sent the following on 4/26/2010 10:08 PM:

Scott Gray-2

Re: MySql related

In reply to this post by Selvakumar Ganesan

Sounds like you've messed up your entityengine.xml file. If you post the first 20 or so lines then someone should be able to guide you back to the right spot.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 27/04/2010, at 7:10 PM, Selvakumar Ganesan wrote:

> [java] Exception: org.ofbiz.entity.GenericEntityConfException
> [java] Message: Could not find a delegator with the name default

smime.p7s (3K) Download Attachment