CODEWITHSUNDEEP
telosys
gene b.
gene b.

Reputation: 12034

Telosys says "0 tables found"

I'm using Telosys to generate Java entities from an Oracle DB. The initial cdb dbname command is successful.

telosys#(mymodel)>cdb crisdev
Checking database 'crisdev'...
OK, connection test is successful.

When I connect exactly like that in Sql Developer, with those exact credentials, I see the listing of all my tables.

enter image description here

But in Telosys, on doing nm I see this: 0 tables found:

telosys#(mymodel)>nm devmodel crisdev
 Getting database metadata
 Getting tables metadata
 0 table(s) found
 End of metadata process

What's going on? There are no additional schemas in this case. The DB YAML is

  - id: crisdev
    name: CRIS DEV
    type: ORACLE 
    # JDBC connection
    url: <some url>
    driver: oracle.jdbc.OracleDriver
    user: <some user>
    password: <some password>
    # Metadata parameters
    catalog: !
    schema: !
    tableNamePattern:
    tableNameInclude:
    tableNameExclude:
    tableTypes:
    # DB model creation
    dbModelName:
    # Telosys DSL model creation 
    linksManyToOne: true
    linksOneToMany: false

Upvotes: 0

Views: 170

Answers (1)

lgu
lgu

Reputation: 2460

According to the messages the connection is going well, but when Telosys tries to get the tables, it can't find anything.

In your database definition (yaml file) you should specify the schema and the tableNamePattern ('%' for all tables).

schema: SCHEMA_NAME
tableNamePattern: '%'

With Oracle "schema" = "user" (so this should be the username)

Upvotes: 0

Related Questions