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

[Lee Chamberlain, geändert vor 7 Jahren.]

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?

[Lee Chamberlain, geändert vor 7 Jahren.]

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

[Lee Chamberlain, geändert vor 7 Jahren.]

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