Hi, > The method ResultSetMetaData.getTableName () always returns the table > and not the alias of the query. > EJ. select * from Tabla as T1 left join Tabla as T2 on T1.id = > T2.idparent > > Can I change this behavior? > In the consultations that appears twice in the same table can not be > distinguished fields one and other.
No, it's not possible to change the behavior. I believe it's the correct behavior according to the JDBC spec. Also, none of the database I have tested (MySQL, PostgreSQL, Apache Derby, HSQLDB) returns the table alias. Therefore, I don't plan to change it. This issue is related to http://www.h2database.com/html/faq.html#column_names_incorrect 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.
