Relation ui_rel_db1_table_to_db2_table cannot be used in a f

Classic Servoy
1

Does any one know in which situations a relation cannot be used in a find? -Understanding that the relation in question is between to tables of two separate databases. The two columns have exactly the same data type. Interesting.

Thanks.
JC

2

Inter database relationships cannot be used in a find.

3

ptalbot:
Inter database relationships cannot be used in a find.

I understand, but this is unexpected. It complicates things a bit for me too.

Thanks!
JC

4

Hi Juan-Carlos,

Like Patrick said you can’t use find over a relationship that spans 2 different databases.
When you use such a relationship to show data Servoy actually queries both connections and then joins them at the application server level. Searching however is not supported.

Having said that you could move this inter-database connectivity to the database level using database links or SQL/MED. Then you can use 1 single JDBC connection and treat the foreign objects (tables/views/etc) as local objects and search and join against it.
Sybase, SQLServer and Oracle for instance can link to themselves. With SQL/MED however you could also link against real foreign databases (depending on the implementation of the database vendor). For instance PostgreSQL can link against MongoDB/MySQL/Oracle/etc. (or even some web services) and treat is as a PostgreSQL table.

So depending on your use case these database links might be a better solution for you.

Hope this helps.

5

ROCLASI:
Having said that you could move this inter-database connectivity to the database level using database links or SQL/MED. Then you can use 1 single JDBC connection and treat the foreign objects (tables/views/etc) as local objects and search and join against it.
Sybase, SQLServer and Oracle for instance can link to themselves. With SQL/MED however you could also link against real foreign databases (depending on the implementation of the database vendor). For instance PostgreSQL can link against MongoDB/MySQL/Oracle/etc. (or even some web services) and treat is as a PostgreSQL table.

So depending on your use case these database links might be a better solution for you.

Hope this helps.

Wow, Robert. I just learned something new. I’ll look into it. Really helpful. Thanks! JC