petcliic.txt

yum install mysql

mysql -h <rds end point url > -u <dbusername> -p 
create database petclinic;

show databases;
use petclinic;
show tables;



5)Create a petclinic db in mysql. ( CREATE DATABASE petclinic;)
 

6) Download the war file from your s3 url and upload into tomcat webapps.(tomcat has to be running status and access petclinic once)

7)stop tomcat and from webapps folder delete/move the petclinic.war( now you have petclinic expldoed directory in webapps folder)

8)in webapps/petclinic/WEB-INF/classes/db/mysql/initDB.sql ( update the db username and password 2 lines)
for ex: GRANT ALL PRIVILEGES ON petclinic.* TO root@localhost IDENTIFIED BY 'Login@123';


9)update data-access.prop with mysql entries.
petclinic/WEB-INF/classes/spring

remove all HQL and MS-SQL. ( keep only mysql lines and remove #(comments))
for ex:
jpa.showSql=true

#-------------------------------------------------------------------------------
# MySQL Settings

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/petclinic
jdbc.username=root
jdbc.password=Login@123

# Properties that control the population of schema and data for a new data source
jdbc.initLocation=classpath:db/mysql/initDB.sql
jdbc.dataLocation=classpath:db/mysql/populateDB.sql

# Property that determines which Hibernate dialect to use
# (only applied with "applicationContext-hibernate.xml")
hibernate.dialect=org.hibernate.dialect.MySQLDialect

# Property that determines which database to use with an AbstractJpaVendorAdapter
jpa.database=MYSQL


10)next download the mysql connector jar and place it in tomcat/lib.
mysql-connector-java-5.1.5-bin.jar

11) start the tomcat and find if any errors are comming related to mysql(SQLSEver exceptions ignore)