On 12 March 2014 15:07, james agada <[email protected]> wrote: > I thought I did. I am persistently getting another error now. > > > > 16:14:35,803 [Schema main DEBUG] Creating table > > "DailySalesTotalForParty" > > > > 16:14:35,803 [Schema main DEBUG] Creating table > > "DailySalesTotalForParty" > > > > > > 16:14:35,804 [Datastore main ERROR] Error thrown > > executing CREATE VIEW DailySalesTotalForParty ( "transactionDate", > > "totalAmount" , "fromPartyReference", "transactiontype" ) AS SELECT > > "Transaction"."transactionDate" , SUM("Transaction"."faceValue") AS > > totalAmount , "Transaction"."fromPartyReference" , > > "Transaction"."transactiontype" FROM "Transaction" GROUP BY > > "Transaction"."transactionDate", "Transaction"."fromPartyReference", > > "Transaction"."transactiontype" : object name already exists: > > DAILYSALESTOTALFORPARTY in statement [CREATE VIEW > DailySalesTotalForParty ( > > "transactionDate", "totalAmount" , "fromPartyReference", > > "transactiontype" ) AS SELECT "Transaction"."transactionDate" , > > SUM("Transaction"."faceValue") AS totalAmount , > > "Transaction"."fromPartyReference" , "Transaction"."transactiontype" > > FROM "Transaction" GROUP BY "Transaction"."transactionDate", > > "Transaction"."fromPartyReference", "Transaction"."transactiontype" ] > > > > java.sql.SQLSyntaxErrorException: object name already exists: > > > > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > > >
> > Not sure why it says object name already exists!!. > > Me neither. But I don't think I can help without more information. What did you change since it worked? Does it work if you checkout an earlier version of the app that did work? Is the HSQLDB database configured to run in-memory, or is it persistent? Dan
