Hi, thanks for reply.
>From the database trace file it looks like that rolled back and commited is
another transaction that it should. I'll modify test I have created and
exchange datasource implementation and than i'll exchange database and I
will consult it with hikari authors or with Spring
Hello,
when we upgrade version of H2 we sometimes(sometimes not) got this
exception:
IllegalArgumentException: timeNanos out of range 864003
at org.h2.value.ValueTimestamp.(ValueTimestamp.java:54)
at org.h2.value.ValueTimestamp.fromDateValueAndNanos(ValueTimestamp.java:68)
a
That's not a format change, that's a "we prefer to detect corruption
earlier rather than later" change
Obviously your DB become corrupted at some point in the past, but H2 didn't
notice back then because it was not checking the range of such things.
I suggest you revert to an earlier version, do
Hello Noel,
thanks for clarification.
> I suggest you revert to an earlier version, do a dump, and restore into
the new version, after fixing up the data.
That's exactly what I did - I am unwanted H2 recovery expert :( I have
recently recovered about 20-30 corrupted customer's databases :(
Sinc
Hi,
You could use "cast":
SELECT * FROM (SELECT CAST(? AS VARCHAR) FROM DUAL)
On Thursday, November 17, 2016, Boris Granveaud wrote:
> Hello,
>
> I have a problem with the following statement:
>
> SELECT * FROM (SELECT ? FROM DUAL)
>
> it gives this error with H2 1.4.191:
>
> org.h2.jdbc.JdbcS