Sorry - I just realized there
is https://groups.google.com/forum/#!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.
