Reverse engineering MSSQL issue

[awamser]

1. Created top level package
2. Introspect and installed driver
3. updated database.properties with the correct server info
4. ran the reverse engineering from roo shell

database reverse engineer --schema dbo --package ~.domain --includeTables "MmStockTable"

Received Error:

Exception in thread "Spring Roo JLine Shell" java.lang.NoSuchMethodError: org.springframework.roo.addon.entity.Identifier.<i nit>(Lorg/springframework/roo/model/JavaSymbolName;Lorg/springframework/roo/model/JavaType;Ljava/lang/StringV
at org.springframework.roo.addon.dbre.DbreDatabaseLis tenerImpl.getIdentifiersFromColumns(DbreDatabaseLi stenerImpl.java:338)
at org.springframework.roo.addon.dbre.DbreDatabaseLis tenerImpl.getIdentifiersFromPrimaryKeys(DbreDataba seListenerImpl.java:322)
at org.springframework.roo.addon.dbre.DbreDatabaseLis tenerImpl.manageIdentifier(DbreDatabaseListenerImp l.java:273)
at org.springframework.roo.addon.dbre.DbreDatabaseLis tenerImpl.createNewManagedEntityFromTable(DbreData baseListenerImpl.java:210)
at org.springframework.roo.addon.dbre.DbreDatabaseLis tenerImpl.reverseEngineer(DbreDatabaseListenerImpl .java:121)
at org.springframework.roo.addon.dbre.DbreDatabaseLis tenerImpl.processDatabase(DbreDatabaseListenerImpl .java:81)
at org.springframework.roo.addon.dbre.DbreDatabaseLis tenerImpl.notifyDatabaseRefreshed(DbreDatabaseList enerImpl.java:72)
at org.springframework.roo.addon.dbre.DbreModelServic eImpl.publishToListeners(DbreModelServiceImpl.java :254)
at org.springframework.roo.addon.dbre.DbreModelServic eImpl.getDatabase(DbreModelServiceImpl.java:240)
at org.springframework.roo.addon.dbre.DbreModelServic eImpl.refreshDatabase(DbreModelServiceImpl.java:15 8)
at org.springframework.roo.addon.dbre.DbreOperationsI mpl.reverseEngineerDatabase(DbreOperationsImpl.jav a:77)
at org.springframework.roo.addon.dbre.DbreCommands.se rializeDatabaseMetadata(DbreCommands.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.roo.support.util.ReflectionUti ls.invokeMethod(ReflectionUtils.java:191)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy$1.callback(ProcessMana gerHostedExecutionStrategy.java:49)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.doTransactionally(DefaultProc essManager.java:180)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.execute(DefaultProcessManager .java:143)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy.execute(ProcessManager HostedExecutionStrategy.java:47)
at org.springframework.roo.shell.AbstractShell.execut eCommand(AbstractShell.java:165)
at org.springframework.roo.shell.jline.JLineShell.pro mptLoop(JLineShell.java:358)
at org.springframework.roo.shell.jline.JLineShell.run (JLineShell.java:132)
at java.lang.Thread.run(Thread.java:680)
[Spring Roo Process Manager Background Polling Thread] Created ROOT/.roo-dbre

.roo-dbre contains the following:

<database name="dbo" package="com.xxxxx.srcatalog.domain">
<table name="MmStockTable">
<column name="StockNumber" primaryKey="true" required="false" size="20" type="12,varchar"/>
<column name="Description" primaryKey="false" required="false" size="30" type="12,varchar"/>
<column name="UnitOfIssue" primaryKey="false" required="false" size="10" type="12,varchar"/>
<unique name="PK_MmStockTable">
<unique-column name="StockNumber"/>
</unique>
</table>
</database>

SQL DDL from database is:

CREATE TABLE xxxxx.dbo.MmStockTable (
StockNumber varchar(20) NOT NULL,
Description varchar(30),
UnitOfIssue varchar(10),
PRIMARY KEY (StockNumber)
);

[Alan Stewart]

Please raise a Jira bug ticket to track this, and attach all the information above as well. Thanks