Announcement Announcement Module
Collapse
No announcement yet.
DBRE Error (Oracle 11g DB) - Schema does not exist Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • DBRE Error (Oracle 11g DB) - Schema does not exist

    I am trying to reverse engineer my tables in Oracle 11g tables. I created OSGI bundle for the Oracle driver and I am able to connect to the database.

    When I execute introspect Roo is writing out all my table information to XML file correctly

    Code:
    roo> database introspect --schema TIBDEV --file db_metadata.xml
    Database metadata written to file C:\.....\db_metadata.xml
    But when I execute the reverse engineer command with same schema name, I get schema does not exist error. Am I missing something? How do I get this to work?

    Code:
    roo> database reverse engineer --schema TIBDEV --package ~.domain --includeTables "<<LIST OF MY TABLES>>" --testAutomatically
    Schema(s) 'TIBDEV' do no exist or does not have any tables. Note that the schema names of some databases are case-sensitive
    Regards

  • #2
    Perhaps, your schema has not the specified include tables ?

    Comment


    • #3
      Schema has the specified tables. I am able to confirm that via Oracle SQL Developer and the metadata XML generated by the introspect command.

      Comment


      • #4
        Issue is resolved. I made a stupid mistake, the table names are in uppercase.

        Comment

        Working...
        X