> But for you, that would require waiting for a new version to become
available, which might take some months.
To be honest, the deadline is not very important, what matters is that
ultimately we can offer users a tool (LibreOffice Base) that is easy to use
for databases. This is necessary if we want to be able to offer intelligent
and communicative functionalities.
> Why is it hard to use the workaround? ie. doing
I already have specific code for H2 because of the type of table named
TABLE BASE. If you use H2 in LibreOffice Base with the native JDBC driver
you will only see the views, the tables are invisible...
So I have mock java.sql.ResultSet in place allowing me to patch the content
in order to satisfy Base.
But in this specific case, it is more complicated for me to be able to
overcome this limitation than it is for you. I don't think I can write this
in less than 10 lines...
Furthermore I think that any good database management software will be
happy to take advantage of such functionality.
Le mercredi 10 avril 2024 à 14:59:05 UTC+2, Noel Grandin a écrit :
> On Wed, 10 Apr 2024 at 13:01, prrvchr <prr...@gmail.com> wrote:
>
>> > if we _did_ improve it, we would break some downstream libraries (like
>> JOOQ and Hibernate), who rely on the values we currently return from that
>> method
>>
>> Not if you only change the input handling: support the SYSTEM TABLE and
>> TABLE types in addition to TABLE BASE in the type given as input to the
>> DatabaseMetaData.getTables() method.
>> I think less than 10 lines of code are necessary....
>>
>
> Possibly I am missing something.
>
> I am sure we could do that, and possibly it would have no negative side
> effects.
> But for you, that would require waiting for a new version to become
> available, which might take some months.
>
> Why is it hard to use the workaround? ie. doing
>
> SELECT *, DB_OBJECT_ID('TABLE', TABLE_SCHEMA, TABLE_NAME) < 0 IS_SYSTEM
> FROM INFORMATION_SCHEMA.TABLES;
>
>
>
--
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 discussion on the web visit
https://groups.google.com/d/msgid/h2-database/55b3a0fb-aa38-4036-9d6e-13c47fd3e721n%40googlegroups.com.
