Thanks Thomas.
That will work for me now. Is there any chance the uppercasing will be
extended to getColumns and similar APIs?
Cheers,
Silvio
On 04/14/2012 07:47 AM, Thomas Mueller wrote:
Hi,
H2 converts identifier names to uppercase, as some other databases
also do. Not PostgreSQL and MySQL, I know.
There is a compatibility feature, but you need to create a new
database, and always append ";database_to_upper=false" to the database
URL:
jdbc:h2:~/temp/test3;database_to_upper=false
This will not work for existing databases.
Regards,
Thomas
On Thursday, April 12, 2012, Silvio wrote:
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.
--
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.
--
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.
