Hello, I am using H2 and have created a table programmatically using "create table mytest ( id : uuid, name : varchar(150))"
Now when I use getColumns(null,"public","mytest","%") no columns are returned. When I try getColumns(null,"PUBLIC","MYTEST","%") I do get both columns, with names converted to uppercase. I can live with the automatic uppercasing (not very pretty, btw) but I think it should be done consistenly allowing supplying names in the API in lowercase. My problem is that this code is inside a script interpreter and the users scripts are mostly defined in lowercase. On PostgreSQL this was never an issue. I am planning to convert most if not all to H2 but this is a real show-stopper for me. Is there a way to circumvent this? Since I am running on multiple databases doing the uppercasing upfront may break existing stuff and apart from that is far from pretty. Thanks in advance, Silvio -- 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.
