title: How do i create a dbo schema in the h2 sqlserver emulator?
body: <p>I'm getting a </p>
  
  <pre><code>JdbcSQLException: Schema "dbo" not found; 
  SQL statement: create table "dbo"."TableName"
  </code></pre>
  
  <p>when running some boilerplate sql against the h2 sqlserver emulator (ie, with config settings:</p>
  
  <pre><code>db.default.slickdriver=com.typesafe.slick.driver.ms.SQLServerDriver
  db.default.driver=net.sourceforge.jtds.jdbc.Driver
  db.default.url="jdbc:h2:file:~/data/test1;MODE=MSSQLServer"
  </code></pre>
  
  <p>running the following:</p>
  
  <pre><code>Database.forDataSource(DB.getDataSource()) 
     withSession {
  </code></pre>
  
  <p>I've tried creating the schema:</p>
  
  <pre><code>  Database.forDataSource(DB.getDataSource())     
      withSession {
      implicit session =&gt; 
         Q.updateNA("CREATE SCHEMA \"dbo\" AUTHORIZATION sa;")
    }
  </code></pre>
  
  <p>but that doesn't seem to do the trick (or report an error message). Am I missing something?</p>
  
  <hr>
  
  <p>still unable to create the schema programatically. was able to easily create it via the h2 console, using the exact same query as above.</p>
  
  <hr>
  
  <pre><code>play.api.UnexpectedException: Unexpected exception[JdbcSQLException: Schema "dbo" not found; SQL statement:
  create table "dbo"."TestTable" ("TestTableId" CHAR(36))
  at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1$$anonfun$1.apply(ApplicationProvider.scala:148) ~[play_2.10-2.2.3.jar:2.2.3]
      at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1$$anonfun$1.apply(ApplicationProvider.scala:112) ~[play_2.10-2.2.3.jar:2.2.3]
      at scala.Option.map(Option.scala:145) ~[scala-library-2.10.4.jar:na]
      at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1.apply(ApplicationProvider.scala:112) ~[play_2.10-2.2.3.jar:2.2.3]
      at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1.apply(ApplicationProvider.scala:110) ~[play_2.10-2.2.3.jar:2.2.3]
      at scala.util.Success.flatMap(Try.scala:200) ~[scala-library-2.10.4.jar:na]
  Caused by: org.h2.jdbc.JdbcSQLException: Schema "dbo" not found; SQL statement:
  create table "dbo"."TestTable" ("TestTableId" CHAR(36))
  at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[h2-1.3.172.jar:1.3.172]
      at org.h2.message.DbException.get(DbException.java:169) ~[h2-1.3.172.jar:1.3.172]
      at org.h2.message.DbException.get(DbException.java:146) ~[h2-1.3.172.jar:1.3.172]
      at org.h2.command.Parser.getSchema(Parser.java:613) ~[h2-1.3.172.jar:1.3.172]
      at org.h2.command.Parser.getSchema(Parser.java:620) ~[h2-1.3.172.jar:1.3.172]
      at org.h2.command.Parser.parseCreateTable(Parser.java:5254) ~[h2-1.3.172.jar:1.3.172]
  </code></pre>