Java Spring Roo

Create application from Database

• Assuming Roo is installed

1. Create project

project --topLevelPackage com.objclt.roo.sample

1. Create Database Connection

persistence setup --provider HIBERNATE --database MYSQL --databaseName databaseName --hostName hostname --userName username --password password

1. Update database.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/Database_Name
jdbc.usernameDatabase_User
jdbc.password=User_Password

1. Replace create by validate inside persistence.xml to disable the auto database creation

"Before"
property name="hibernate.hbm2ddl.auto" value="create"
"After"
property name="hibernate.hbm2ddl.auto" value="validate"

1. Install Mysql Driver

addon search mysql

 addon install id 01

1. Test Database Connection

database introspect --schema DatabaseSchema