How do I connect Tomcat to the master MySQL database?

Background Information

You need to know how to connect your Apache Tomcat application to the Master MySQ database.

---

Answer

The RightScripts handle this automatically but to resolve the JNDI link 'java:comp/env/jdbc/MYSQLDB', you must do the following:

• Allow RightScale's server.xml to host primary jdbc connection

• Add ResourceLink element to META-INF/context.xml.  See the following example:

  <?xml version=*"1.0"* encoding=*"UTF-8"*?>
  <Context>
      <ResourceLink name=*"jdbc/MYSQLDB"* global=*"jdbc/MYSQLDB"* type=*"javax.sql.Datasource"* />
  </Context>
  

• In web.xml, add the following resource ref:

  • DB Connection
  • jdbc/MYSQLDB
  • javax.sql.DataSource
  • Container