• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

org.hibernate.TransactionException: Transaction not successfully started

 
arushi tomar
Ranch Hand
Posts: 91
3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I am trying to register users using hibernate. I am using mysql database server and following is my code






I keep getting this exception

org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)
at com.javaweb.service.CustomerRegisterService.isUserExists(CustomerRegisterService.java:52)
at com.javaweb.service.CustomerRegisterService.register1(CustomerRegisterService.java:13)
at com.javaweb.controller.CustomerRegisterServlet.doPost(CustomerRegisterServlet.java:19)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
 
Dave Tolls
Ranch Hand
Posts: 2112
16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since it's attempting a rollback, this means an exception was thrown earlier.
Can I suggest changing your catch blocks to this:


At the moment, with the printStackTrace last, the exception you get from the rollback is causing you to lose the exception that caused the need to rollback.

I suspect the tx.begin() call failed for some reason.
 
arushi tomar
Ranch Hand
Posts: 91
3
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Resolved

The problem was in the hibernate mapping file:
Since i was using a url for an online Mysql server, instead of this
<property name="connection.url">jdbc:mysql://http://url:3306/development</property>
I had to do this and it works fine now
<property name="connection.url">jdbc:mysql://url:3306/development</property>
Thank you
 
Roel De Nijs
Sheriff
Posts: 10666
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Glad to hear you solved it!

And thanks for coming back and sharing your solution. It might be helpful for other ranchers facing a similar issue. Have a cow!
 
arushi tomar
Ranch Hand
Posts: 91
3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Roel De Nijs wrote:Glad to hear you solved it!

And thanks for coming back and sharing your solution. It might be helpful for other ranchers facing a similar issue. Have a cow!



Thank you
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic