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 : > Hi Noel, > > *What you can do, is to special case H2 in your JDBC driver* > > I already have java services > <https://github.com/prrvchr/jdbcDriverOOo/tree/master/source/Driver-HsqlDB/source/io/github/prrvchr/jdbcdriver/hsqldb> > > specific to each driver, but unfortunately for this problem, not being able > to change how Base works, I can't do anything... > > > Le jeudi 23 juin 2022 à 09:48:38 UTC+2, Noel Grandin a écrit : > >> >> >> 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 driver. >> >> All of the H2 system tables will have METADATA in the first column of the >> result set, and INFORMATION_SCHEMA in the >> second column. >> >> -- 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/07ab04f9-4a5b-4e5f-9f0a-caca2da83609n%40googlegroups.com.
