Announcement Announcement Module
Collapse
No announcement yet.
Reverse engineering MSSQL issue Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reverse engineering MSSQL issue

    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)
    );

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

    Comment

    Working...
    X