I have the following hibernate properites:
hibernate.connection.url:
jdbc:h2:/app/h2/test;TRACE_LEVEL_FILE=3;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE;TRACE_LEVEL_SYSTEM_OUT=3
hibernate.connection.driver_class: org.h2.Driver
hibernate.dialect: org.hibernate.dialect.PostgreSQL10Dialect
hibernate.connection.username: username
hibernate.connection.password: password
when restarting my application hibernate checks in the
`information_schema.sequences` table and fail to find `start_value` field
/**/PreparedStatement prep0 = conn0.prepareStatement("select * from
information_schema.sequences");
2021-11-18 07:33:41 jdbc[3]: Plan : calculate cost for plan
[sequences:-9:org.h2.table.MetaTable@61b5969]
2021-11-18 07:33:41 jdbc[3]: Plan : for table filter
sequences:-9:org.h2.table.MetaTable@61b5969
2021-11-18 07:33:41 jdbc[3]: Table : potential plan item cost
10,000 index meta
2021-11-18 07:33:41 jdbc[3]: Plan : best plan item cost 10,000
index meta
2021-11-18 07:33:41 jdbc[3]: Plan : plan cost 10,001
2021-11-18 07:33:41 jdbc[3]:
/**/ResultSet rs0 = prep0.executeQuery();
2021-11-18 07:33:41 jdbc[3]:
/*SQL #:1 t:1*/select * from information_schema.sequences;
2021-11-18 07:33:41 jdbc[3]:
/**/rs0.next();
2021-11-18 07:33:41 jdbc[3]:
/**/rs0.getString("sequence_catalog");
2021-11-18 07:33:41 jdbc[3]:
/**/rs0.getString("sequence_schema");
2021-11-18 07:33:41 jdbc[3]:
/**/rs0.getString("sequence_name");
2021-11-18 07:33:41 jdbc[3]:
/**/rs0.getLong("start_value");
2021-11-18 07:33:41 jdbc[3]: exception
org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "start_value" not found
[42122-200]
according to documentation there is a `current_value`, a `min_value` and a
`max_value`:
http://h2database.com/html/systemtables.html
how to overcome this?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/fd457f26-3349-4433-890e-fe3441d88cfcn%40googlegroups.com.
