Thanks Scott! It worked!! On Sun, Dec 13, 2009 at 4:52 AM, Scott Wilson < [email protected]> wrote:
> Hi Gunith, > > This is caused if you shutdown and re-run Wookie in standalone (testing) > mode without first clearing the database. > > If you type: > > ant clean-db run > > This should work OK. > > S > > On 12 Dec 2009, at 16:41, Gunith Devasurendra wrote: > > Hi, > > I was trying to install Wookie (in the standalone mode) I get this > > With normal user privileges, ant run (also tried ant clean-build run) I get > this, > [java] 21:38:05,635 ERROR JDBCExceptionReporter:101 - The statement > was aborted because it would have caused a duplicate key value in a unique > or primary key constraint or unique index identified by 'SQL091212204704060' > defined on 'WIDGET'. > [java] Exception in thread "main" > org.hibernate.exception.ConstraintViolationException: could not execute > native bulk manipulation query > [java] at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) > [java] at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > [java] at > org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:198) > [java] at > org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1190) > [java] at > org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:357) > [java] at > org.apache.wookie.server.Start.configureDatabase(Start.java:58) > [java] at org.apache.wookie.server.Start.main(Start.java:36) > [java] Caused by: java.sql.SQLIntegrityConstraintViolationException: > The statement was aborted because it would have caused a duplicate key value > in a unique or primary key constraint or unique index identified by > 'SQL091212204704060' defined on 'WIDGET'. > [java] at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > [java] at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown > Source) > [java] at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) > [java] at > org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:189) > [java] ... 4 more > [java] Caused by: java.sql.SQLException: The statement was aborted > because it would have caused a duplicate key value in a unique or primary > key constraint or unique index identified by 'SQL091212204704060' defined on > 'WIDGET'. > [java] at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > [java] at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown > Source) > [java] ... 15 more > [java] Caused by: ERROR 23505: The statement was aborted because it > would have caused a duplicate key value in a unique or primary key > constraint or unique index identified by 'SQL091212204704060' defined on > 'WIDGET'. > [java] at > org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > [java] at > org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown > Source) > [java] at > org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) > [java] at > org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) > [java] at > org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) > [java] at > org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) > [java] at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown > Source) > [java] at > org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > [java] at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > [java] ... 9 more > > BUILD FAILED > /data/projects/wookie/trunk/build.xml:39: The following error occurred > while executing this line: > /data/projects/wookie/trunk/ant/ivy-java-common.xml:106: Java returned: 1 > > > I get this even with SU Priviledges. Any hint in how to resolve this would > be really helpful. > > Thanks in advance* > > * > -- > Regards, > Gunith Devasurendra - ගුණිත් දේවසුරේන්ද්ර > > linkedin.com/in/gunith - facebook.com/gunith - foss.lk > > > -- Regards, Gunith Devasurendra - ගුණිත් දේවසුරේන්ද්ර linkedin.com/in/gunith - facebook.com/gunith - foss.lk
