title: Wildfly 9.0.2 + H2 database (jdbc:h2:file not showing tables)
body: <p>So, my first example using Wildfly 9.0.2 and I have deployed one webapp with the settings:</p>
  
  <p>context: <strong>app-estoque-ws-server-wildfly</strong></p>
  
  <pre><code>src/main/resources/META-INF
  -&gt; import.sql
  -&gt; persistence.xml
  
  WebContent/WEB-INF
  -&gt; knight-estoque-ds.xml
  </code></pre>
  
  <p><strong>persistence.xml:</strong></p>
  
  <pre><code>&lt;persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="        http://java.sun.com/xml/ns/persistence         http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"&gt;
       &lt;persistence-unit name="primario"&gt;
            &lt;jta-data-source&gt;java:jboss/datasources/KnightDS&lt;/jta-data-source&gt;
            &lt;properties&gt;
                 &lt;property name="hibernate.hbm2ddl.auto" value="create-drop" /&gt;
                 &lt;property name="hibernate.show_sql" value="true" /&gt;
            &lt;/properties&gt;
       &lt;/persistence-unit&gt;
  &lt;/persistence&gt;
  </code></pre>
  
  <p><strong>knight-estoque-ds.xml:</strong></p>
  
  <pre><code>&lt;datasources xmlns="http://www.jboss.org/ironjacamar/schema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.jboss.org/ironjacamar/schema http://docs.jboss.org/ironjacamar/schema/datasources_1_0.xsd"&gt;
       &lt;datasource jndi-name="java:jboss/datasources/KnightDS"
        pool-name="knight-datasource" enabled="true"
        use-java-context="true"&gt;
            &lt;connection-url&gt;jdbc:h2:file:knight-estoque;DB_CLOSE_ON_EXIT=FALSE&lt;/connection-url&gt;
            &lt;driver&gt;h2&lt;/driver&gt;
            &lt;security&gt;
                 &lt;user-name&gt;sa&lt;/user-name&gt;
                 &lt;password&gt;sa&lt;/password&gt;
            &lt;/security&gt;
       &lt;/datasource&gt;
  &lt;/datasources&gt;
  </code></pre>
  
  <p>This is what I get on startup log:</p>
  
  <pre><code>21:52:31,043 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) WFLYJCA0001: Bound data source [java:jboss/datasources/KnightDS]
  </code></pre>
  
  <p>But how can I accomplish:</p>
  
  <p><strong>1- Accessing H2 knight-estoque on H2 web console, I can't see the any created  or previously imported tables.</strong></p>
  
  <p><a href="https://i.stack.imgur.com/mDKLS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mDKLS.png" alt="enter image description here"></a></p>
  
  <p><strong>2- Also, I can't see in the Wildfly log the execution of import.sql that was previously added on META-INF folder.</strong></p>
  
  <p><strong>3- And finally, how to locate the knight-estoque DS on Wildfly web console?
  Tried the following paths and didn't find the DS setup:</strong></p>
  
  <p>[RUNTIME] -> Standalone Server -> Subsystems -> Datasources (only shows ExampleDS)</p>
  
  <p>[CONFIGURATION] -> Subsystems -> Datasources -> Non-XA -> (only shows ExampleDS)</p>
  
  <p>[CONFIGURATION] -> Subsystems -> Datasources -> XA -> nothing here</p>
  
  <p>The knight-estoque DS setup only shows on the structure bellow:</p>
  
  <p><a href="https://i.stack.imgur.com/SJqhm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SJqhm.png" alt="enter image description here"></a></p>
  
  <p>What I'm missing? I just want to execute the import.sql on DS so I can start using the application and also navigate through tables using H2 web console.</p>
  
  <p>Thanks.</p>