[h2] ResultSet.cancelRowUpdates() throw Exception If no updates have been made

Hi, H2 seems not to follow the JDBC specs and throws an exception when calling the ResultSet.cancelRowUpdates() method, if no updates have been made, with the following message:

Re: [h2] Re: No SYSTEM TABLE in TABLE_TYPE column returned by DatabaseMetaData.getTables()

Thanks Evgenij, I will try to do something with this request... Le jeudi 23 juin 2022 à 12:09:07 UTC+2, Evgenij Ryazanov a écrit : > I forgot to add TABLE_TYPE alias after CASE … END. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Re: No SYSTEM TABLE in TABLE_TYPE column returned by DatabaseMetaData.getTables()

I forgot to add TABLE_TYPE alias after CASE … END. -- 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 h2-database+unsubscr...@googlegroups.com. To view this

Re: [h2] Re: No SYSTEM TABLE in TABLE_TYPE column returned by DatabaseMetaData.getTables()

You can use something like that: SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, CASE WHEN TABLE_SCHEMA = 'INFORMATION_SCHEMA' THEN 'SYSTEM TABLE' WHEN TABLE_TYPE = 'BASE TABLE' THEN 'TABLE' ELSE TABLE_TYPE END, REMARKS, CAST(NULL AS VARCHAR)

Re: [h2] Re: No SYSTEM TABLE in TABLE_TYPE column returned by DatabaseMetaData.getTables()

This is exactly what I wanted to avoid, but I can override the Databsae.getTables() method... What would be the SQL query to obtain a resultset with SYSTEM TABLE as TABLE_TYPE for the table and view contained in INFORMATION_SCHEMA? Le jeudi 23 juin 2022 à 09:58:11 UTC+2, prrvchr a écrit : >

Re: [h2] Re: No SYSTEM TABLE in TABLE_TYPE column returned by DatabaseMetaData.getTables()

Hi Noel, *What you can do, is to special case H2 in your JDBC driver* I already have java services specific to each driver, but unfortunately for this problem, not being able

Re: [h2] Re: No SYSTEM TABLE in TABLE_TYPE column returned by DatabaseMetaData.getTables()

On 2022/06/23 9:30 am, prrvchr wrote: /I don't know what do you mean by system table and why you need to distinguish them from normal tables and views./ Unfortunately, we cannot change this easily because of backwards compatibility. What you can do, is to special case H2 in your JDBC

[h2] Re: No SYSTEM TABLE in TABLE_TYPE column returned by DatabaseMetaData.getTables()

Hi Evgenij, *I don't know what do you mean by system table and why you need to distinguish them from normal tables and views.* I don't know the JDBC specification, but with all other driver: Hsqldb, Derby, smallSQL, all table and view in the INFORMATION_SCHEMA have SYSTEM TABLE as

[h2] Re: Table not found after ALTER table - leftover "_COPY_" table

Hi, Were you able to find the cause as I am also getting the same issue in my application. Thanks, Shubham On Monday, 1 March 2021 at 16:22:44 UTC+5:30 jackp...@gmail.com wrote: > Hi, just wondered if there were any more thoughts? > > On Thursday, 4 February 2021 at 16:04:58 UTC

[h2] Re: App run some time then throw table not found exception

Hi, Were you able to identify the root cause and solve the issue as I am also facing the same issue. On Wednesday, 8 September 2021 at 14:24:57 UTC+5:30 wjj145...@gmail.com wrote: > Hi all, I have use SpringBoot, Mybatis and H2 for my app. > when the app first started, it is normal, it can