REPOSITORY_PROPERTIES

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

REPOSITORY_PROPERTIES

Previous pageReturn to chapter overviewNext page

Returns properties for repository, but not for streams.

Syntax

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

 

Returns table

property_name

property_value

5_3_indicator

Version 5.3 Feature

As of version 5.3, you no longer need to use the preface SYS_BOOT.MGMT.

Example

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

'PROPERTY_NAME'        'PROPERTY_VALUE'

'org.netbeans.mdr.storagemodel.StorageFactoryClassName'        'org.netbeans.mdr.persistence.jdbcimpl.JdbcStorageFactory'

'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.driverClassName'        'org.hsqldb.jdbcDriver'

'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.url'        'jdbc:hsqldb:/opt/sqlstream/5.2.0.15589/s-Server/catalog/FarragoCatalog;shutdown=true'

'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.userName'        'SA'

'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.password'        ''

'MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.schemaName'        'MD R'