title: Hippo cms and mysql on Glassfish
body: <p>I have a big problem with the addition of a mysql database to Glassfish. I did all the steps located here <a href="http://www.onehippo.org/library/deployment/configuring/configuring-hippo-7-for-mysql.html" rel="nofollow">http://www.onehippo.org/library/deployment/configuring/configuring-hippo-7-for-mysql.html</a> .</p>
  
  <p>When I use</p>
  
  <pre><code>$ mvn clean install
  $ mvn -P cargo.run
  </code></pre>
  
  <p>It's looks fine, because in my workspace.xml I have :</p>
  
  <pre><code>&lt;FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem"&gt;
    &lt;param name="url" value="java:comp/env/jdbc/repositoryDS"/&gt;
    &lt;param name="driver" value="javax.naming.InitialContext"/&gt;
    &lt;param name="schemaObjectPrefix" value="${wsp.name}_"/&gt;
    &lt;param name="schema" value="mysql"/&gt;
  &lt;/FileSystem&gt;
  </code></pre>
  
  <p>next I use </p>
  
  <pre><code>$ mvn clean install
  $ mvn -P dist
  </code></pre>
  
  <p>and deploy created cms.war and site.war to glassfish server (Previously, I copied all the libraries and everything works. Inspired by <a href="https://blogs.oracle.com/geertjan/entry/hippo_tip_deploying_hippo_to" rel="nofollow">https://blogs.oracle.com/geertjan/entry/hippo_tip_deploying_hippo_to</a> ). All of project works fine.</p>
  
  <p>The problem is the database. In new workspace.xml in glassfish (/opt/glassfish4/glassfish/domains/domain1/applications/cms/WEB-INF/storage/workspaces/default/workspace.xml) I have:</p>
  
  <pre><code>&lt;FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"&gt;
    &lt;param name="path" value="${wsp.home}"/&gt;
  &lt;/FileSystem&gt;
  
  &lt;PersistenceManager   class="org.apache.jackrabbit.core.persistence.pool.H2PersistenceManager"&gt;
    &lt;param name="url" value="jdbc:h2:file:${wsp.home}/db"/&gt;
    &lt;param name="schemaObjectPrefix" value="${wsp.name}_"/&gt;
    &lt;param name="minBlobSize" value="4194304"/&gt;
  &lt;/PersistenceManager&gt;
  </code></pre>
  
  <p>and server created db.h2.db file in storage/workspace/default, but I need a base in mysql. What can I do wrong?</p>
  
  <p>Additional question. How to check what is in the database? In mysql hippo created something like this: </p>
  
  <pre><code>+--------------------+
  | Tables_in_hippo    |
  +--------------------+
  | DATASTORE          |
  | DEFAULT_BINVAL     |
  | DEFAULT_BUNDLE     |
  | DEFAULT_FSENTRY    |
  | DEFAULT_NAMES      |
  | DEFAULT_REFS       |
  | REPOSITORY_FSENTRY |
  | VERSION_BINVAL     |
  | VERSION_BUNDLE     |    
  | VERSION_FSENTRY    |
  | VERSION_NAMES      |
  | VERSION_REFS       |
  +--------------------+
  </code></pre>
  
  <p>There are no tables like "Book" "Author" "Shop". But in server Hippo have all this data which I can edit.</p>
  
  <p>Thanks for reading. </p>