To filter out all system tables when connecting to Oracle, supply the proper schema name to connect to. Note: supply the schema name in all upper case letters, or else it won't work!
Starting from release 8.0.3, Servoy supports Oracle Synonyms.
A special property (includeSynonyms=true) needs to be set for the server to configure the Oracle driver to retrieve column information for synonyms.
This cannot be set in the server editor, it has to be configured directly in servoy.properties, see the example.
server.11.serverName=my_oracle_server server.11.driver=oracle.jdbc.driver.OracleDriver server.11.enabled=true server.11.property.includeSynonyms=true ... |
Note that Servoy will overwrite servoy.properties on shutdown (both Developer and ApplicationServer).
The driver will return the column information, but not primary keys, so the primary key has to be set manually (row_ident) in the table editor.