Checked with ALIAS_COLUMN_NAME option, really works. It is not clear why
everything worked by default until 1.97 and now the behavior has changed.
вторник, 16 апреля 2019 г., 17:34:31 UTC+3 пользователь Aleksey
Konstantinov написал:
>
> Hi Evgenij.
>
> This query is executed on the SQuirreL SQL Client (it uses h2 JDBC driver
> version 199):
>
> [image: sqclient.jpg]
>
>
> четверг, 4 апреля 2019 г., 16:43:10 UTC+3 пользователь Evgenij Ryazanov
> написал:
>>
>> Hello.
>>
>> How exactly do you read names of aliases? I cannot reproduce this issue
>> in 1.4.197 and in other versions.
>>
>> try (Connection c = DriverManager.getConnection("jdbc:h2:mem:1"))
>> {
>> Statement s = c.createStatement();
>> s.execute("CREATE TABLE test (ID int);");
>> s.execute("INSERT INTO test (ID) VALUES (1);");
>> try (ResultSet rs = s.executeQuery("SELECT ID AS VALUE_ID
>> FROM test;")) {
>> System.out.println(rs.getMetaData().getColumnLabel(1));
>> while (rs.next()) {
>> System.out.println(rs.getInt("VALUE_ID"));
>> }
>> }
>> }
>>
>> VALUE_ID
>> 1
>>
>> It looks like you incorrectly use getColumnName(), this method returns ID
>> as expected. JDBC drivers of many databases incorrectly return name of
>> alias from this method too, but you should not expect that all databases
>> will do the same.
>>
>> H2 can emulate such behavior, you need to use a compatibility mode
>> or ALIAS_COLUMN_NAME setting.
>>
>
--
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 post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
