86Views3Replies

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

3 Replies

user
StumpChunkman (author)2011-04-02

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.

Select as Best AnswerUndo Best Answer

user
Anth420 (author)StumpChunkman2011-04-02

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.

Select as Best AnswerUndo Best Answer

user
StumpChunkman (author)Anth4202011-04-03

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

Select as Best AnswerUndo Best Answer