Spring Roo Using Real Existing Oracle Database

I have this table Candidate (CID, Name, COL3), be noted, I don't have ID and Version there.
  • create new Root project: Project name: wedding4Real; Top Level: com.wedding
  • open roo shell
  • persistence setup --provider HIBERNATE --database ORACLE --databaseName XE --userName practice_db --password secret 
  • change <property name="hibernate.hbm2ddl.auto" value="create"/> to <property name="hibernate.hbm2ddl.auto" value="update"/> in /src/main/resources/META-INF/persistence.xml
  • entity --class ~.domain.Candidate --identifierField cid --identifierColumn CID --table Candidate
  • add versionField ="", like @RooEntity(identifierField = "cid", identifierColumn = "CID", versionField = "", table = "Candidate") in /wedding4Real/src/main/java/com/wedding/domain/Candidate.java
  • field string Name
  • field string COL3
  • controller scaffold ~.web.RsvpController 
  1. NullPointerException at org.springframework.roo.addon.web.mvc.controller.WebScaffoldMetadata.getDatePatterns(WebScaffoldMetadata.java:1231)
  2. This seems a known defect found in 1.1.1 version.
  3. Switch to Spring Roo 1.1.4 version, and retry
  4. Confirmed: this is working after 1.1.1 version
  • add wedding project into server, and start server
  • http://localhost:8080/wedding4Real
Thoughts: look like this will not work in Spring Flex, since the most recent Spring Flex Addon is only compatible up to 1.1.1 version. So we'll have to wait for Spring Flex Addon to work with the real existing table (which means no version\ID columns).