Hi, whoops, sorry for not reading the FAQ :)
Anyway, I use SquirrelSQL to work with the database. I am using sql script to transform data loaded from another database (using linked table); then the final transformed data is loaded into a java application (using spring connector). I ran into problems by calling something like "SELECT bar FROM SOMETHING" somewhere in the middle of the transforming sql script (where "SOMETHING" is a copy of the original table with a renamed column), which resulted in a "column 'bar' not found" error). The reason I did the above is that I wanted to rename the column (in a copy of the original table, because I also added some additional data). Anyway, if the behavior is right according to JDBC, i will add the ;ALIAS_COLUMN_NAME=TRUE connection string and that will solve the problem. Thanks for the explanation. David On 1 dub, 17:15, Thomas Mueller <[email protected]> wrote: > Hi, > > Yes, I think you ran into this > issue:http://h2database.com/html/faq.html#column_names_incorrect > > > I am not using it in java function, just in SQL > > Well... what tool or application do you use to display the data? > > 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 at http://groups.google.com/group/h2-database?hl=en.
