[h2] index problem

2022-12-25 Thread mche...@gmail.com
hi, i got 18 millions role, i select and order with a column with index, very fast. Then i manually changed nearly all the values of that column, select become very slow, seems the index won't rebuild after i changed the column values, how to prevent it? thanks -- You received this message bec

[h2] Re: Getting names of unique constraints via hibernate

2022-12-25 Thread Evgenij Ryazanov
Hello! H2 doesn't return names of constrains in these exceptions (maybe it will in future versions). If you need to find name of constraint, you need to check INFORMATION_SCHEMA.TABLE_CONSTRAINTS table. You need only rows where TABLE_SCHEMA and TABLE_NAME match schema and name of updated table.

[h2] Getting names of unique constraints via hibernate

2022-12-25 Thread Tadashi Shibata
I need to fix hibernate so that I can get names of unique constraints from exceptions. I made a fix and it works fine at least for me. Before pull request, there are two points I want to know: - I can not extract constraint name from the message in case of primary key constraint violation even wh

[h2] H2Database 1.4.x security backports

2022-12-25 Thread Boris Unckel
Please find some backports of CVE fixes for H2Database 1.4.x here: https://github.com/boris-unckel/h2database/releases Initially done to keep a fork of WF26.x fixed, it seems some other libraries have transitive dependencies to these old versions. At all: It's better to migrate to the latest ori