99Views3Replies

Author Options:

Facebook Error Answered

Getting this when I try to log in using facebook for the first time:

org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
 at com.instructables.transaction.TransactionHandler.invoke(TransactionHandler.java:112)
 at $Proxy9.save(Unknown Source)
 at com.instructables.filter.SecurityFilter.createUserFromFacebookDetails(SecurityFilter.java:279)
 at com.instructables.filter.SecurityFilter.doFilter(SecurityFilter.java:152)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
 at com.instructables.filter.SetupFilter.doFilter(SetupFilter.java:68)
 at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
 at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:514)
 at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:527)
 at com.caucho.util.ThreadPool.run(ThreadPool.java:449)
 at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.BatchUpdateException: Duplicate entry 'ahick1' for key 2
 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
 ... 21 more

Discussions

0
None
StumpChunkman

7 years ago

Would you mind trying to clear your cache? It's possible that you have several different facebook login cookies on your computer, and it's confusing the login. If that doesn't work, I'll pass this on to those who know much more then I do.

0
None
Anth420StumpChunkman

Reply 7 years ago

Thanks for your quick response. I did try clearing the cache, and I also tried using 3 different browsers, and they all had the same issue.

It seems to be letting me log in fine now, so the issue seems resolved. If I have any more issues I'll let you guys know.

0
None
StumpChunkmanAnth420

Reply 7 years ago

Awesome! I'm glad it worked. Yeah, hopefully it was just a weird temporary thing.