Issue Details (XML | Word | Printable)

Key: APF-584
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Matt Raible
Reporter: Michael Horwitz
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
AppFuse

Provide DB specific build profiles in the archetypes

Created: 20/Jan/07 11:49 AM   Updated: 16/Feb/07 02:18 AM   Resolved: 16/Feb/07 02:18 AM
Component/s: Installation
Affects Version/s: 2.0-M2
Fix Version/s: 2.0-M4


 Description  « Hide
If a user wants to use a database other than MySql, quite a few properties in the pom.xml need to be changed. In certain cases, e.g. MS SQL, changes also need to be made to other areas of the pom - the dbunit process also needs to change. By including a set of database specific profiles, we could cut down on the number of changes that users need to make to the poms to switch databases.

One disadvantage, of course, is that the pom could become rather lengthy.

Matt Raible added a comment - 22/Jan/07 03:48 PM
There are profiles in the root pom.xml for embedded databases - but none of them work. Feel free to add ones for SQL Server and Oracle. The only problem currently is that iBATIS has MySQL statements hard-coded in its mapping files, so tests fail for other databases.

Matt Raible made changes - 06/Feb/07 02:56 AM
Field Original Value New Value
Fix Version/s 2.0-M4 [ 10130 ]
Matt Raible added a comment - 13/Feb/07 05:20 PM
Mike - if you can post the changes needed for MS SQL, I can try to make this change. Having Oracle and DB2 profiles would probably be good too. We already have one for PostgreSQL.

2489 by  Matt Raible (23 files)
14/Feb/07 04:01 AM (41 months, 25 days ago)
APF-584: Added SQL Server, H2 and HSQLDB as profiles to archetypes. Tested and certified to work against Hibernate implementation. Couldn't get Oracle Express to work (http://www.nabble.com/AppFuse-2.0-with-Oracle-Express-tf3225784s2369.html), nor Derby Embedded (http://www.nabble.com/Issues-trying-to-use-Embedded-Derby-with-hibernate3-and-dbunit-tf3226221.html).
appfuse: trunk/data/ibatis/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/service/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-spring/src/main/resources/archetype-resources/pom.xml 2489 history download (+47 -0) diffs
appfuse: trunk/archetypes/appfuse-basic-struts/src/main/resources/archetype-resources/pom.xml 2489 history download (+49 -1) diffs
appfuse: trunk/web/jsf/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/data/hibernate/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-jsf/src/main/resources/archetype-resources/pom.xml 2489 history download (+47 -0) diffs
appfuse: trunk/archetypes/appfuse-basic-jsf/src/main/resources/archetype-resources/pom.xml 2489 history download (+49 -1) diffs
appfuse: trunk/web/tapestry/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-basic-spring/src/main/resources/archetype-resources/pom.xml 2489 history download (+49 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-tapestry/src/main/resources/archetype-resources/web/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/web/common/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/pom.xml 2489 history download (+41 -8) diffs
appfuse: trunk/archetypes/appfuse-modular-struts/src/main/resources/archetype-resources/pom.xml 2489 history download (+47 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-struts/src/main/resources/archetype-resources/core/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/web/struts/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-jsf/src/main/resources/archetype-resources/web/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-spring/src/main/resources/archetype-resources/web/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-basic-tapestry/src/main/resources/archetype-resources/pom.xml 2489 history download (+49 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-tapestry/src/main/resources/archetype-resources/pom.xml 2489 history download (+47 -0) diffs
appfuse: trunk/data/jpa-hibernate/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/web/spring/pom.xml 2489 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-struts/src/main/resources/archetype-resources/web/pom.xml 2489 history download (+2 -1) diffs


2495 by  Matt Raible (24 files)
16/Feb/07 01:58 AM (41 months, 23 days ago)
APF-584: Fixed issue with Oracle profile and added to archetypes
appfuse: trunk/data/ibatis/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/service/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-spring/src/main/resources/archetype-resources/pom.xml 2495 history download (+15 -0) diffs
appfuse: trunk/archetypes/appfuse-basic-struts/src/main/resources/archetype-resources/pom.xml 2495 history download (+16 -0) diffs
appfuse: trunk/web/jsf/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/data/hibernate/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-jsf/src/main/resources/archetype-resources/pom.xml 2495 history download (+15 -0) diffs
appfuse: trunk/data/hibernate 2495 history download modified
appfuse: trunk/archetypes/appfuse-basic-jsf/src/main/resources/archetype-resources/pom.xml 2495 history download (+16 -0) diffs
appfuse: trunk/web/tapestry/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/archetypes/appfuse-basic-spring/src/main/resources/archetype-resources/pom.xml 2495 history download (+16 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-tapestry/src/main/resources/archetype-resources/web/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/web/common/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/pom.xml 2495 history download (+2 -1) diffs
appfuse: trunk/archetypes/appfuse-modular-struts/src/main/resources/archetype-resources/pom.xml 2495 history download (+15 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-struts/src/main/resources/archetype-resources/core/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/web/struts/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-jsf/src/main/resources/archetype-resources/web/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-spring/src/main/resources/archetype-resources/web/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/archetypes/appfuse-basic-tapestry/src/main/resources/archetype-resources/pom.xml 2495 history download (+16 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-tapestry/src/main/resources/archetype-resources/pom.xml 2495 history download (+15 -0) diffs
appfuse: trunk/data/jpa-hibernate/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/web/spring/pom.xml 2495 history download (+1 -0) diffs
appfuse: trunk/archetypes/appfuse-modular-struts/src/main/resources/archetype-resources/web/pom.xml 2495 history download (+1 -0) diffs

Matt Raible added a comment - 16/Feb/07 02:18 AM
Fixed Oracle Express and Derby (only works in Networked mode). Not worrying about DB2 until there's one JAR for the JDBC Driver.

Matt Raible made changes - 16/Feb/07 02:18 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]