Driver may not support getAutocommit()
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 04:11 AM
Hey.
I use the Activiti 5.2 demo on a Windows 7 machine with a MySQL 5.5.
The Database works fine, but i have a Problem when i long time not logged in (f.e. in the Explorer).
Then i got the first time the follow Exception:
When i wait 5-10 Seconds after these, i can problemless log in.
What can i do? Change the JDBC-driver? How? (I am new in all these Java/JDBC-things.)
Thanks.
Palumpa
I use the Activiti 5.2 demo on a Windows 7 machine with a MySQL 5.5.
The Database works fine, but i have a Problem when i long time not logged in (f.e. in the Explorer).
Then i got the first time the follow Exception:
org.springframework.extensions.webscripts.connector.AuthenticatingConnector handshakeSCHWERWIEGEND: An exception occurred while attempting authentication handshake for endpoint: http://localhost:8080/activiti-rest/serviceorg.springframework.extensions.surf.exception.AuthenticationException: 05280003 Wrapped Exception (with status template): Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureLast packet sent to the server was 147 ms ago. at org.activiti.surf.ActivitiRESTAuthenticator.authenticate(ActivitiRESTAuthenticator.java:97) at org.springframework.extensions.webscripts.connector.AuthenticatingConnector.handshake(AuthenticatingConnector.java:403) at org.activiti.surf.ActivitiUserFactory.authenticate(ActivitiUserFactory.java:141) at org.springframework.extensions.surf.mvc.LoginController.handleRequestInternal(LoginController.java:67) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:563) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 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:646) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417) 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:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)
When i wait 5-10 Seconds after these, i can problemless log in.
What can i do? Change the JDBC-driver? How? (I am new in all these Java/JDBC-things.)
Thanks.
Palumpa
Labels:
- Labels:
-
Archive
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 05:25 AM
Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Looks like some connection issue while trying to use the connection… Is it a local MySQL database or does the db-connection go over the wire?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 07:42 AM
The databaseserver is on localhost.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 10:35 AM
this happens if you do not use something like c3p0 for connectionpooling… at least in other apps with hibernate/mysql. Might be Ibatis has built-in functionality that needs to be configured. Not sure.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2011 03:29 AM
Ok, i have no idea what Ibatis is. Maybe Google can help me
When i need to configure this, how can i do this?
Thanks.
When i need to configure this, how can i do this?
Thanks.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2012 02:56 AM
I have the same problem.
Did you solved it through configuration of the connectionpool ?
Did you solved it through configuration of the connectionpool ?