java.lang.IllegalArgumentException when running sample code with MYSQL

[CC-Damo]

MYSQL Server Version: 8.0.23
mysql-connector-java Version: 8.0.23

When attempting to run the Sample code located here: https://github.com/dieselpoint/norm/blob/master/src/test/java/com/dieselpoint/norm/SampleCode.java

The below Exception is thrown:
java.lang.IllegalArgumentException: Can not set long field org.example.SampleCode$Name.id to java.math.BigInteger

Please can you advise if this is a known issue or if there is a known fix as the same problem is also occurring in my own code when using this library.

[ccleve]

It's a mysql jdbc bug pertaining to generated keys. There is a workaround. I'm at a ballgame right now, but I'll find it when I get back.

…

On Sat, Apr 24, 2021, 5:21 PM Damien ***@***.***> wrote: MYSQL Server Version: 8.0.23 mysql-connector-java Version: 8.0.23 When attempting to run the Sample code located here: https://github.com/dieselpoint/norm/blob/master/src/test/java/com/dieselpoint/norm/SampleCode.java The below Exception is thrown: java.lang.IllegalArgumentException: Can not set long field org.example.SampleCode$Name.id to java.math.BigInteger Please can you advise if this is a known issue or if there is a known fix as the same problem is also occurring in my own code when using this library. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#55>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAITHKQFR23L7K5MVJ6XRLTTKM77TANCNFSM43QSN26Q> .

[ccleve]

https://bugs.mysql.com/bug.php?id=101823 I don't recall now if there is a workaround. You could make your primary key a BigInteger. On Sat, Apr 24, 2021, 5:31 PM Chris Cleveland ***@***.***> wrote:

…

It's a mysql jdbc bug pertaining to generated keys. There is a workaround. I'm at a ballgame right now, but I'll find it when I get back. On Sat, Apr 24, 2021, 5:21 PM Damien ***@***.***> wrote: > MYSQL Server Version: 8.0.23 > mysql-connector-java Version: 8.0.23 > > When attempting to run the Sample code located here: > https://github.com/dieselpoint/norm/blob/master/src/test/java/com/dieselpoint/norm/SampleCode.java > > The below Exception is thrown: > java.lang.IllegalArgumentException: Can not set long field > org.example.SampleCode$Name.id to java.math.BigInteger > > Please can you advise if this is a known issue or if there is a known fix > as the same problem is also occurring in my own code when using this > library. > > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub > <#55>, or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AAITHKQFR23L7K5MVJ6XRLTTKM77TANCNFSM43QSN26Q> > . >

[CC-Damo]

Hi CCleve,

I hope you enjoyed your ball game!

I did attempt to make my PK a big int before opening this bug with the below snippet:

@Id @GeneratedValue public BigInteger id;

However, a SQLSyntaxErrorException is thrown due to Incorrect column specifier for column 'id'.

I have found however that an upsert does appear to work without error, I'm yet to see if this will function for my use case however.

Thanks

[ccleve]

Fixed by #79