REPOSITORY_PROPERTIES

Returns properties for repository, but not for streams.

Syntax

SELECT * FROM TABLE(SYS_BOOT.MGMT.REPOSITORY_PROPERTIES());

Returns table

property_name

property_value

Example

SELECT * FROM TABLE(SYS_BOOT.MGMT.REPOSITORY_PROPERTIES());
'PROPERTY_NAME'<tab />
'PROPERTY_VALUE'
'org.netbeans.mdr.storagemodel.StorageFactoryClassName'<tab />
'org.netbeans.mdr.persistence.jdbcimpl.JdbcStorageFactory'
'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.driverClassName'<tab />
'org.hsqldb.jdbcDriver'
'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.url'<tab />
'jdbc:hsqldb:/opt/sqlstream/5.2.0.15589/s-Server/catalog/FarragoCatalog;shutdown=true'
'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.userName'<tab />
'SA'
'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.password'<tab />
''
'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.schemaName'<tab />
'MD R'