title: Set IGNORECASE and other options for H2 in a Play! Framework test
body: <p>I've setup my Play! (with Slick) application to use H2 when running tests, and it has worked great so far. I'm getting an error now, because of a plain-SQL query that uses lower-case column and table names, and H2 complains that the TABLE (all uppercase) could not be found.</p>
  
  <p>Now I need to set a <a href="http://www.h2database.com/html/features.html#compatibility" rel="nofollow">few options</a>, <code>IGNORECASE</code> for sure, and possibly the <code>MODE</code>. </p>
  
  <p>When I setup my database for tests, I use</p>
  
  <pre><code>def fakeAppWithMemoryDatabase = FakeApplication(additionalConfiguration = inMemoryDatabase())
  </code></pre>
  
  <p>For development, I use PSQL, so in my <code>application.conf</code> file, I have:</p>
  
  <pre><code>slick.db.driver=scala.slick.driver.H2Driver
  
  db.default.driver=org.postgresql.Driver
  db.default.url="jdbc:postgresql://localhost:5432/mydb"
  </code></pre>
  
  <p><a href="http://www.playframework.com/documentation/2.1-RC2/Developing-with-the-H2-Database" rel="nofollow">From the documentation</a>, I see I can pass settings to the <code>db.default.url</code> string, like </p>
  
  <pre><code>db.default.url="jdbc:h2:mem:play;MODE=PostgreSQL;"
  </code></pre>
  
  <p>but my <code>default.url</code> setting is for my Postgres DB. Is there a way to pass in <code>MODE</code> and <code>IGNORECASE</code> settings to H2 in this scenario?</p>
  
  <p>I have tried to append <code>SET IGNORECASE TRUE;</code> to my SQL query but I still receive the same error.</p>