title: How to set-up Hybris 6.7 local with MySQL
body: <p>I am trying to set-up a local Hybris Instant with MySQL instead of HSQLDB.</p>
  
  <p><strong>local.properties</strong></p>
  
  <pre><code> mysql.optional.tabledefs=CHARSET\=utf8 COLLATE\=utf8_bin
   db.url=jdbc\:mysql\://localhost/6showcase?useConfigs\=maxPerformance&amp;characterEncoding\=utf8&amp;useSSL\=false
   db.driver=com.mysql.jdbc.Driver
   db.username=root
   db.password=root
   db.tableprefix=
   mysql.tabletype=InnoDB
   installed.tenants=**
  </code></pre>
  
  <p>Build Successfully(ant clean all).</p>
  
  <p>Getting runti:</p>
  
  <pre><code>**ERROR [localhost-startStop-4] [DataSourceImpl] error connecting to DataSource having url jdbc:mysql://localhost/6showcase?useConfigs=maxPerformance&amp;characterEncoding=utf8&amp;useSSL=false: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long**
  </code></pre>
  
  <p>Using user root with all privileges for the schema etc...<br>
  <a href="https://i.stack.imgur.com/3h0gL.jpg" rel="nofollow noreferrer">Image1</a><br>
  <a href="https://i.stack.imgur.com/kQbkh.jpg" rel="nofollow noreferrer">Image2</a></p>
  
  <p>Any idea what can be wrong?</p>