title: Querying the appropriate database schema
body: <p>This is a follow-on question to my <a href="https://stackoverflow.com/questions/12066043/accessing-h2-database-schema">earlier</a> question about specifying multiple schemata in java using jooq to interact with H2.</p>
  
  <p>My test H2 DB currently has 2 schemata, PUBLIC and INFORMATION_SCHEMA. PUBLIC is specified as the default schema by H2. When running a query that should extract information from eg INFORMATION_SCHEMA.TABLES the query fails with a "table unknown" SQL error. I am only able to execute such queries by executing a <code>factory.use(INFORMATION_SCHEMA)</code>. There are no build errors etc and eclipse properly autocompletes eg TABLES.TABLE_NAME.</p>
  
  <p>If I dont do this, jooq doesnt seem to prepend the appropriate schema even though I create the correct Factory object for the schema eg </p>
  
  <pre><code>InformationSchemaFactory info = new InformationSchemaFactory(conn);
  </code></pre>
  
  <p>I read about <a href="http://www.jooq.org/manual/ADVANCED/SchemaMapping/#N10DD3" rel="nofollow noreferrer" title="mapping">mapping</a> but am a bit confused as to which schema I would use as the input/output.</p>