Why would jdbc api have two different methods for the same thing?
I think it's great if you can get both the alias and the actual column name.
- rami
On 8.5.2010 22:47, Bear wrote:
SQL Server 2008 (Express) and Oracle 10g also use the same values for
column labels and names on the database metadata result sets.
On May 4, 5:35 am, Bear<[email protected]> wrote:
Postgresql, mysql, derby, hsqldb, sqlite. I'm in the process of
standing up oracle and sqlserver instances so I'll know about them in
a few days.
Please note that my question is different than the FAQ. I know the
difference between column names and labels and in fact that's why my
tool uses labels for the report's column headers. E.g., maybe the
user wrote
select foo.x as foo, bar.x as bar from foo, bar
and column name would be ambiguous.
I'm looking specifically at the results of DatabaseMetaData queries,
e.g., getting a list of schemas or table types available in the
database. The javadoc refers to 'columns' but doesn't appear to
explicitly state that column names and labels must be identical.
BTW the tool is a class that dumps jdbc result sets into properly
formatted excel files. E.g., it uses the correct formatting for
number of significant digits, understands whether a column is a
datetime, date or time, etc. The database metadata often comes up
(e.g. what types are there?) so there's wrappers for all of the
database metadata queries. The unit tests for those are tripping
since the report uses the column label but the unit test uses the
column name. It's easy to change but having seen 5 other databases
use the same values for both name and label so I wanted to point out
the inconsistency to you.
Bear
On May 3, 12:46 pm, Thomas Mueller<[email protected]>
wrote:
Hi,
This is a surprisingly common question.
Seehttp://www.h2database.com/html/faq.html#column_names_incorrect
all of the other databases I've tested
Which ones did you test?
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group
athttp://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group
athttp://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
