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.
