Configure jdbc for spring on openshift

<beans:bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
   <beans:property name="driverClassName" value="com.mysql.jdbc.Driver" />
   <beans:property name="url" value="jdbc:mysql://#{systemEnvironment[OPENSHIFT_MYSQL_DB_HOST]}}:#{systemEnvironment[OPENSHIFT_MYSQL_DB_PORT]}/#{systemEnvironment[OPENSHIFT_APP_NAME]}" />
 
   <beans:property name="username" value="#{systemEnvironment[OPENSHIFT_MYSQL_DB_USERNAME]}" />
   <beans:property name="password" value="#{systemEnvironment[OPENSHIFT_MYSQL_DB_PASSWORD]}" />
</beans:bean>

Database

• Case
• Caseid
• Subject
• Description
• startdate
• Endate
• stepid
• Userid
• Categoryid
• tag

• Step
• Caseid
• stepid
• Stepnote
• Description
• Startdate
• endate
• tag

• Item
• caseid
• Stepid
• Doitem
• dodate

• Comment
• Referid
• Comment
• Type - case/step/comment/item
• Createdate
• userid

• Tag
• Tag
• rate

• Category
• Categoryid
• Categoryname
• Description
• parent