I guess this option must be a part of database URL. Sergi
2016-10-13 9:20 GMT+03:00 Peter Becker <[email protected]>: > After experimenting with DATABASE_TO_UPPER a bit more I realize it does > what we need, i.e. this all works: > > create table CI_Sessions (id int); > insert into ci_sessions (id) values (1); > select * from "ci_sessions"; > > How do we set that option on a PgServer connection? > > Cheers, > Peter > > > On Thursday, October 13, 2016 at 3:59:01 PM UTC+10, Peter Becker wrote: >> >> Sorry - I just realized there is https://groups.google.com/f >> orum/#!topic/h2-database/bg_dGVT_XbA already. >> >> Given how quiet that has been I assume the feature doesn't exist. Can >> anyone give me an idea of how hard it would be to implement? >> >> Cheers, >> Peter >> >> >> On Thursday, October 13, 2016 at 3:43:21 PM UTC+10, Peter Becker wrote: >>> >>> Hello all, >>> >>> we are trying to do something a bit more unusual: use the PostgreSQL >>> wire protocol to talk to H2 as if it is a SQL Server. The reason behind >>> that is that we are migrating from PHP to Java and want to run integration >>> tests on top of H2. PHP seems to be capable of connecting to H2's PgServer >>> via it's Postgres driver, so this seems a viable approach to manage the >>> database state. >>> >>> The issue we are facing is that the PHP code uses the table names in >>> different capitalizations compared to the database schema. SQL Server is >>> case-preserving, case-insensitive when it comes to table names (no matter >>> if the table name is quoted or not). This way it works in production, but >>> it doesn't work with H2. The queries the PHP code generates look like this: >>> >>> INSERT INTO "ci_sessions" ("session_id", "ip_address", >>> "user_agent", "last_activity", "user_data") VALUES >>> ('e1a0a3cd8e2aa1473aac3c0a8b2c0237', '127.0.0.1', 'Mozilla/5.0 (X11; >>> Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu >>> Chromium/53.0.2785.143 Chrome/53.0.2785.14', 1476334111, '') >>> >>> This table is actually named "CI_Sessions", H2 produces "ERROR: Table >>> "ci_sessions" not found". >>> >>> Is there an option to make H2 case insensitive on the table names? The >>> MSSQLServer mode doesn't seem to trigger a change in this regard. >>> >>> Also: how do we control options on the PgServer connections? The syntax >>> using semicolons to append the options is something at least the psql >>> command line tool doesn't like. >>> >>> Cheers, >>> Peter >>> >>> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
