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 at http://groups.google.com/group/h2-database?hl=en.
