If we want to be able to offer users intelligent software, we must find
intelligence where it is found.
In this case, you are the one holding it...
Le mercredi 10 avril 2024 à 16:06:22 UTC+2, prrvchr a écrit :
> > 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/108ae991-c028-42c7-a6fc-9e3c07088cc4n%40googlegroups.com.
