Announcement Announcement Module
No announcement yet.
Reverse Engineer SQL Server error message Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reverse Engineer SQL Server error message


    In a new Roo project, using JTDS to access a MS SQL Server Schema and I am receiving a error message. I searched through the forums, and did not find any other ideas.

    I can access this schema with the same database properties I told Roo using SQL Server studio and IDEA.

    roo> database reverse engineer --schema ViewerLogging
    Schema 'ViewerLogging' does not exist or does not have any tables. Note that the schema names of some databases are case-sensitive
    Since Roo is accessing the database, I am thinking there is something Roo needs to find the schema there. I have tried adding "dbo." in front of it, but it did not change the message.

    How have others made it past this message?

  • #2
    I found a post on StackOverflow which mentioned the way to understand the termonology. The database name is in the JDBC URL, and the schema in this case is dbo, so "database reverse engineer --schema dbo" ended up working for me.