reset password
Author Message
yogesh
Posts: 24
Posted 11:18 May 13, 2010 |

2010-05-13 08:23:54,205  INFO HomeController: Username: s0001, Role: ROLE_STUDENT
2010-05-13 08:24:32,653  WARN JDBCExceptionReporter: SQL Error: 0, SQLState: 23505
2010-05-13 08:24:32,653 ERROR JDBCExceptionReporter: Batch entry 0 insert into wiki (path, title, password, person_id, date, id) values ('/yog', 'yogesh  ', 'yogesh', '1100001', '2010-05-13 08:24:32.576000 -07:00:00', '2000063') was aborted.  Call getNextException to see the cause.
2010-05-13 08:24:32,653  WARN JDBCExceptionReporter: SQL Error: 0, SQLState: 23505
2010-05-13 08:24:32,653 ERROR JDBCExceptionReporter: ERROR: duplicate key value violates unique constraint "wiki_path_key"
2010-05-13 08:24:32,656 ERROR AbstractFlushingEventListener: Could not synchronize database state with session
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:253)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
 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)
 

hsankav
Posts: 18
Posted 11:36 May 13, 2010 |

Check if you have entry for path  with value'/yog' in the database. If you try to insert  another entry with the same path you will get this error since path is unique

yogesh
Posts: 24
Posted 11:55 May 13, 2010 |

actually i already have that entry in database and i m trying update  it using same Dao(save or uptade).

 

and i m getting this error at that time.

Pallavi0205
Posts: 30
Posted 14:13 May 13, 2010 |

while doing update check if you are not saving path in page table again. you need to only update Revision.