Service builder java.sql.BatchUpdateException: Batch entry 0 insert into

[7年前 に Lee Chamberlain によって更新されました。]

I've used Service builder to add some data to a database and I get the following error

ERROR [http-bio-8080-exec-6][JDBCExceptionReporter:82] Batch entry 0 insert into ....

After a bit of tracking I realised that it's due to

ERROR [http-bio-8080-exec-6][JDBCExceptionReporter:82] Batch entry 0 insert into
08:14:44,450 ERROR [http-bio-8080-exec-6][JDBCExceptionReporter:82] ERROR: duplicate key value violates unique constraint "mydatabase_mydatabase_pkey"

This took me ages to discover as there is no data being submitted to the database (we're using Postgres).


Does anybody know where this error is being caused if the database has no data in it?

[7年前 に Lee Chamberlain によって更新されました。]

I should add that the code runs with no errors when submitted with new data in the field for the primary key

[7年前 に Lee Chamberlain によって更新されました。]

It appears that it wasn't deploying to the database I thought it was - and I was blocked from directly viewing it through postgres.

All solved now.

Thanks
Lee