Results 1 to 4 of 4

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

  1. #1
    Join Date
    Jan 2013
    Posts
    3

    Question 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. #2
    Join Date
    Jan 2010
    Location
    Mislata - Valencia - Spain
    Posts
    162

    Default

    Perhaps, your schema has not the specified include tables ?
    Mario Martínez Sánchez
    Project Manager & Software Architect
    --------------------------
    Disid Technologies S.L.
    http://www.disid.com
    --------------------------
    gvNIX
    http://gvnix.googlecode.com
    http://www.gvnix.org

  3. #3
    Join Date
    Jan 2013
    Posts
    3

    Default

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

  4. #4
    Join Date
    Jan 2013
    Posts
    3

    Default

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •