0

org.hibernate.exception.JDBCConnectionException: could not execute query

asked 2009-04-15 13:47:30 +0800

bob007 gravatar image bob007
384 3 4

updated 2009-04-24 14:38:22 +0800

*** SOLVED ***

What can cause this error ?

org.hibernate.exception.JDBCConnectionException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2231)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
org.hibernate.loader.Loader.list(Loader.java:2120)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
groupes.GroupeDAO.findAllJustSigle(GroupeDAO.java:37)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
bsh.Reflect.invokeMethod(Unknown Source)
bsh.Reflect.invokeObjectMethod(Unknown Source)
bsh.Name.invokeMethod(Unknown Source)
bsh.BSHMethodInvocation.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHAssignment.eval(Unknown Source)
bsh.BSHBlock.evalBlock(Unknown Source)
bsh.BSHBlock.eval(Unknown Source)
bsh.BshMethod.invokeImpl(Unknown Source)
bsh.BshMethod.invoke(Unknown Source)
bsh.BshMethod.invoke(Unknown Source)
bsh.Name.invokeLocalMethod(Unknown Source)
bsh.Name.invokeMethod(Unknown Source)
bsh.BSHMethodInvocation.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.Interpreter.eval(Unknown Source)
bsh.Interpreter.eval(Unknown Source)
org.zkoss.zk.scripting.bsh.BSHInterpreter.exec(BSHInterpreter.java:108)
org.zkoss.zk.scripting.util.GenericInterpreter.interpret(GenericInterpreter.java:310)
org.zkoss.zk.ui.impl.PageImpl.interpret(PageImpl.java:771)
org.zkoss.zk.ui.impl.UiEngineImpl.execNonComponent(UiEngineImpl.java:730)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:549)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:559)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:527)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:494)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:375)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:296)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:229)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:166)
javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

delete flag offensive retag edit

7 Replies

Sort by ยป oldest newest

answered 2009-04-15 16:22:57 +0800

bob007 gravatar image bob007
384 3 4

Ok I redeployed my application and its reworking.

link publish delete flag offensive edit

answered 2009-04-16 13:53:53 +0800

bob007 gravatar image bob007
384 3 4

Its very odd my application work well when i quit the evening but I get this exception each morning and I had to restart the application to make it work.

What can cause this ?

Thanks,

link publish delete flag offensive edit

answered 2009-04-16 14:30:17 +0800

terrytornado gravatar image terrytornado flag of Germany
9393 3 7 16
http://www.oxitec.de/

It seems like a timeout from the database. ?

link publish delete flag offensive edit

answered 2009-04-16 19:50:04 +0800

bob007 gravatar image bob007
384 3 4

What can I do to avoid that ?

Thanks,

link publish delete flag offensive edit

answered 2009-04-17 00:47:13 +0800

PeterKuo gravatar image PeterKuo
481 2

updated 2009-04-17 00:47:42 +0800

I googled "hibernate timeout", wish this can help you.
http://www.codefin.net/2007/05/hibernate-and-mysql-connection-timeouts.html

link publish delete flag offensive edit

answered 2009-04-24 14:40:19 +0800

bob007 gravatar image bob007
384 3 4

Thank you for your help Terry and Peter its was exactly the problem.

Now the application dont disconnect anymore.

link publish delete flag offensive edit

answered 2009-04-25 15:41:52 +0800

terrytornado gravatar image terrytornado flag of Germany
9393 3 7 16
http://www.oxitec.de/

:-)

Do you change settings in the database or tomcat?

Stephan

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2009-04-15 13:47:30 +0800

Seen: 4,230 times

Last updated: Apr 25 '09

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More