title: Bluemix Liberty server.xml MySQL data source configuration
body: <p>I have an EJB based application that connects to MySQL database and provides web UI for update operations. It works fine when deployed to local WAS Liberty.</p>
  
  <p>Here is the server.xml configuration for data source.</p>
  
  <pre><code>&lt;library id="MySQLDriverLib"&gt;
      &lt;file name="${User-defined_JDBC_DRIVER_PATH}/mysql-connector-java-5.1.38-bin.jar"/&gt;
  &lt;/library&gt;
  &lt;dataSource id="DefaultDataSource" type="javax.sql.ConnectionPoolDataSource" transactional="true"&gt;
      &lt;jdbcDriver libraryRef="MySQLDriverLib"/&gt;
      &lt;properties URL="jdbc:mysql://localhost:3306/ic16_lab2434" connectionUrl="jdbc:mysql://localhost:3306/ic16_lab2434" driver="com.mysql.jdbc.Driver" driverClass="com.mysql.jdbc.Driver" metadata="mySQL" password="object00" user="root" userName="root" /&gt;
  &lt;/dataSource&gt;
  &lt;variable name="User-defined_JDBC_DRIVER_PATH" value="C:\Software\mysql-connector-java-5.1.38"/&gt;
  </code></pre>
  
  <p>As you can see, it uses library for JDBC driver jar, which is specified with path to file. Obviously, this won't work if I try to deploy just EAR to Bluemix Liberty. That's why I am deploying whole server directory to make least number of changes. Yet even in this case I don't know how to properly configure JDBC driver library for data source so server picks it up. Please help.</p>