Oracle

Server configuration

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!

Synonyms

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.

Last updated