Getting java.sql.SQLException Field 'id' doesn't have a default value

[kumawatanupriya]

Probably this is happening because in database table primary keys are not auto increment and they are in java entity class.
So can you fix that, project (branch 0.2.0) is not running because of that.
@knjk04

[knjk04]

Thanks for bringing this up. Could you please share the stack trace of the error? Also, which of the setup instructions did you follow in the README (1, 2 or 3)?

[knjk04]

For reference: https://gist.github.com/knjk04/c41a13102b232fe583278a4911152ca1

[kumawatanupriya]

Hey @knjk04 this is the only issue the database tables doesn't have A_I checked, https://beginnersbug.com/field-id-doesnt-have-a-default-value/ .

[knjk04]

@kumawatanupriya Thanks for the link. We are using identity already, but I needed to auto increment in our SQL scripts.

I'm working on a fix for this: https://github.com/Project-Books/book-project/pull/638/files. It works in this PR, but I still need to fix some failing tests.

I'll let you know once I've merged in that pull request

[knjk04]

It should be fixed now. Let me know if it works for you on the latest 0.2.0

[kumawatanupriya]

yeah..backend is running now

[knjk04]

Fixed. This should work in 0.2.0 now

[CongDatt]

you means mysql-connector-java version, right ?