pgjdbc/pgjdbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: prrvchr (@prrvchr) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #538: Why getSchemaName return empty string or exists getBaseSchemaName and getColumnName return getColumnLabel?
Date: Tue, 05 Aug 2025 11:33:49 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
Well, I have exactly the same problem with the Oracle JDBC driver ojdbc17.jar. Their ResultSets don't provide the table name or schema name in the metadata. Well done, Oracle...
But if I take the trouble to find the table name in the SQL query and make sure it is a `SELECT` query that only looks at one table, then I can find the missing data and make this ResultSet editable in LibreOffice Base.
I'm not going to claim anything from Oracle, that would be a waste of time, and neither here, but I would like to point out that analyzing the query in order to extract the name of the table should be part of the JDBC driver (if it is supposed to be called that).
view thread (31+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: github://pgjdbc/pgjdbc
Cc: [email protected], [email protected]
Subject: Re: [pgjdbc/pgjdbc] issue #538: Why getSchemaName return empty string or exists getBaseSchemaName and getColumnName return getColumnLabel?
In-Reply-To: <<[email protected]>>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox