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


Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to