Bug 824391 - The instructions for using MySQL database in Petclinic example are obsolete
Summary: The instructions for using MySQL database in Petclinic example are obsolete
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Enterprise WFK Platform 2
Classification: Retired
Component: Examples
Version: 2.0.0.ER5
Hardware: Unspecified
OS: Unspecified
low
low
Target Milestone: ER2
: 2.1.0
Assignee: Marius Bogoevici
QA Contact: Tomas Repel
URL:
Whiteboard: petclinic
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-05-23 11:45 UTC by Tomas Repel
Modified: 2012-11-30 15:35 UTC (History)
4 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2012-11-30 15:35:19 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Tomas Repel 2012-05-23 11:45:31 UTC
Description of problem:

The guideline how to switch database to MySQL is obsolete in Petclinic example.

Version-Release number of selected component (if applicable):

WFK2 ER5

How reproducible:

Always

Steps to Reproduce:
1. follow the guideline src/main/resources/db/mysql/petclinic_db_setup_mysql.txt
  
Actual results:

Uncommenting the MySQL JDBC Connector in pom.xml causes error:
Missing artifact com.mysql.jdbc:com.springsource.com.mysql.jdbc:jar:5.1.6

Expected results:

Petclinic is deployable and uses MySQL database.

Comment 3 Marius Bogoevici 2012-06-08 01:21:32 UTC
Fixed

Comment 5 Tomas Repel 2012-06-12 16:05:04 UTC
The MySQL JBDC Connector is OK now, but the content of file src/main/resources/db/mysql/petclinic_db_setup_mysql.txt is still obsolete. If the file is not going to be removed, it should be updated.

What I miss:
3) there is no longer the createDB.txt but there are two scripts for DB initialization now, initDB.txt and populate.DB.txt

4) there are more than one jdbc.properties currently, each one for different profile. The files can be found at src/main/environments/<environment>/resources/jbdc.properties

Other
 - the name of datasource has to be changed in persistence.xml and applicationContextDatasource.xml, because the default ExampleDS is not going to be used.
 - note that tests will fail after migration to MySQL
 - maybe link to the page describing how to configure the MySQL datasource for AS7

Comment 7 Marius Bogoevici 2012-10-11 08:18:08 UTC
Fixed

Comment 8 Marius Bogoevici 2012-10-11 08:18:17 UTC
Fixed.

Comment 9 Marius Bogoevici 2012-10-11 08:30:15 UTC
Removed the faulty instruction file.

Comment 10 Tomas Repel 2012-10-18 07:50:13 UTC
Verified in WFK 2.1.0.ER2.

Comment 11 Karel Piwko 2012-11-30 15:35:19 UTC
Distributed as a part of WFK 2.1.0.GA release.


Note You need to log in before you can comment on or make changes to this bug.