[h2] Re: RecoverTools creating scrip with tablenames 0_Number pattern? why

2023-01-05 Thread Ram K
thank you for the reply, I have gone through the generated script, some how the RunScript did not fail after creating the tamporary (O_N) tables. I manually copied the script and ran in it in the console worked. I am trying to migrate to sql server, could you please give me some tips to

[h2] Re: Hibernate 5.6.9 @Version annotation requires precision 9 for timestamp

2023-01-05 Thread Michael Brizic
Hi Evgenij, Thanks for the explanation, very helpful! Wondering if you could would know any additional details ... With respect to "Hibernate reads it back it gets a rounded value instead of expected original one" do you have any further details as to exactly HOW this fails if for example,

[h2] Re: Hibernate 5.6.9 @Version annotation requires precision 9 for timestamp

2023-01-05 Thread Evgenij Ryazanov
Hello! Resolution of system timestamps in JVM depends on Java version and operating system. Old versions of Java (Java 8 and older) provide only 3 digits. Resolution was improved in Java 9, this version provides 7 digits on Windows, but only 6 digits on Linux, because it uses an old system

[h2] Hibernate 5.6.9 @Version annotation requires precision 9 for timestamp

2023-01-05 Thread Michael Brizic
Does anyone know why using H2 on Java 15+ and Spring/Hibernate with entitys that are versioned using timestamps require a precision of 9 instead of 6? We upgraded our web app to use Java 17. Since Java 15+ the JDK/JRE support nanosecond precision for datetime objects. Our integration tests use