search

telosys-tools-bricks / telosys-cli

Telosys CLI - Command Line Interface
https://www.telosys.org/
GNU Lesser General Public License v3.0
166 stars 23 forks source link

NullPointerException when creating db model #13

Closed RedesignedRobot closed 5 years ago

RedesignedRobot commented 5 years ago

When I try to create a new db model, I get a null pointer exception when using the eclipse plugin and also the CLI. Both throw the same error.

I am able to connect to the db and view the schema, tables, PK, FK with no issues

image

image

l-gu commented 5 years ago

What kind of database are you using ? Could you provide the SQL script used to create the tables and foreign keys ?

RedesignedRobot commented 5 years ago

Thank you for your response.

I have attached an image below containing the db info.

I was able to get the tool to work when I create a model for a table without any FK constraints. However, I get the same NullPointer Exception when I try to create a model with 1 table containing FK constraints.

image

Here is the script used to create one of the tables with FK constraints. https://gist.github.com/RedesignedRobot/e0fdd5d4c99e73dea5abdcc4669d87f2

Appreciate the help.

RedesignedRobot commented 5 years ago

Hello again. Just wanted to ask if there is any update on this issue.

l-gu commented 5 years ago

Hi. It may be due to the constraint "PF_A" referencing another schema : "REFERENCES SCHEMA_B.TABLE_A (ID_C)" The tool doesn't support cross schema references. Could you try to remove this constraint and test again ?