Portofino 5.2.1 -- Problem with database schema to import

[Marat Aitymbetov]

Hello everyone!

I just started using Portofino 5.2.1 and encountered problem while importing database schema objects. It`s the second step when running Wizard.

I found some errors like below in catalina.out  

"ERROR c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/MY_DB_NAME/schemas

 The foreign key MY_DB_NAME.TEST_USER.TABLE_2$FK_ID does not refer to the exact primary key of table MY_DB_NAME.TEST_USER.TABLE_1, this is not supported."

I`ve checked it from database side and found out that foreign key has defined to reference the column of a UNIQUE constraint in table1.

So, as i know FOREIGN KEY constraint does not have to be linked only to a PRIMARY KEY constraint in another table; it can also be defined to reference the columns of a UNIQUE constraint in another table.

I`m new to portofino. So, need help to fix the problem. 

Thanks.

[Marat Aitymbetov]

Any suggeestions?

вторник, 18 мая 2021 г. в 15:04:08 UTC+6, Marat Aitymbetov:

[Alessio Stalla]

This is not supported at the moment. The foreign key must be mapped to the primary key.

Could you open an issue on GitHub so we can track this?

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.
To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/manydesigns-portofino/c2b14d48-7cea-4f6f-90b6-2802a00b0dc4n%40googlegroups.com.

[Marat Aitymbetov]

hi Alessio,

Thanks for your reply. I`ve just created new issue on GitHub #456.

So, will be waiting for solution on this issue.

thx

пятница, 21 мая 2021 г. в 18:50:32 UTC+6, alessi...@gmail.com: