Change Database

[msr]

Hello,

i tried to change the database from H2 to MySQL 5.5.
Squash TM works fine with the embedded H2 Database. But our whole databases are on MySQL and we want to change.

aditional info:
db-user has got admin-privilegs for the database
environment variable is set for jdbc
jdbc connector: mysql-connector-java-5.1.29-bin.jar
java 1.7
Windows Server 2008


I followed exactly the instructions in the Guideline. Here are the changes I've done:

1. Database created and run: 'mysql-full-install.sql' from the database-scripts/ folder.
2. Changed entries in:


'org.squashtest.csp.core.datasource.jdbc.config.properties'

datasource.db.driverClassName=com.mysql.jdbc.Driver
datasource.db.url=jdbc:mysql://localhost:3306/squash-tm
datasource.db.username=user
datasource.db.password=password


' org.squashtest.csp.tm.hibernate.config.properties'

hibernate.dialect=org.hibernate.dialect.MySQLDialect


3. Restarted Squash TM
At the startup on the commandline still H2 database is loaded.

Attachments: Startup-screenshot with H2
Log File

Any Idea?

[lmasser]

Hi,

Please retry to launch Squash TM, after having empty your felix-cache file.

Does the problem still remains after that ?

Best regards.