82 lines
3.1 KiB
INI
82 lines
3.1 KiB
INI
############################ JDBC Persistence Service ##################################
|
|
# I N S T A L L J D B C P E R S I S T E N C E S E R V I C E
|
|
#
|
|
# https://github.com/openhab/openhab/wiki/JDBC-Persistence
|
|
#
|
|
# Tested databases/url-prefix: jdbc:derby, jdbc:h2, jdbc:hsqldb, jdbc:mariadb, jdbc:mysql, jdbc:postgresql, jdbc:sqlite
|
|
#
|
|
# derby, h2, hsqldb, sqlite can be embedded,
|
|
# If no database is available it will be created, for example the url 'jdbc:h2:./testH2' creates a new DB in OpenHab Folder.
|
|
#
|
|
# Create new database, for example on a MySQL-Server use:
|
|
# CREATE DATABASE 'yourDB' CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
|
|
# D A T A B A S E C O N F I G
|
|
# Some URL-Examples, 'service' identifies and activates internally the correct jdbc driver.
|
|
# required database url like 'jdbc:<service>:<host>[:<port>;<attributes>]'
|
|
# url=jdbc:derby:./testDerby;create=true
|
|
# url=jdbc:h2:./testH2
|
|
# url=jdbc:hsqldb:./testHsqlDb
|
|
# url=jdbc:mariadb://192.168.0.1:3306/testMariadb
|
|
url=jdbc:mysql://10.112.30.17:3306/openhab_ffr?serverTimezone=Europe/Berlin
|
|
# url=jdbc:postgresql://192.168.0.1:5432/testPostgresql
|
|
# url=jdbc:sqlite:./testSqlite.db
|
|
# url=
|
|
|
|
# required database user
|
|
user=openhab_ffr
|
|
|
|
# required database password
|
|
password=112PAlokasAwu2013
|
|
|
|
# E R R O R H A N D L I N G
|
|
# optional when Service is deactivated (optional, default: 0 -> ignore)
|
|
#errReconnectThreshold=
|
|
|
|
# I T E M O P E R A T I O N S
|
|
# optional tweaking SQL datatypes
|
|
# see: https://mybatis.github.io/mybatis-3/apidocs/reference/org/apache/ibatis/type/JdbcType.html
|
|
# see: http://www.h2database.com/html/datatypes.html
|
|
# see: http://www.postgresql.org/docs/9.3/static/datatype.html
|
|
# defaults:
|
|
#sqltype.CALL = VARCHAR(200)
|
|
#sqltype.COLOR = VARCHAR(70)
|
|
#sqltype.CONTACT = VARCHAR(6)
|
|
#sqltype.DATETIME = DATETIME
|
|
#sqltype.DIMMER = TINYINT
|
|
#sqltype.LOCATION = VARCHAR(30)
|
|
#sqltype.NUMBER = DOUBLE
|
|
#sqltype.ROLLERSHUTTER = TINYINT
|
|
#sqltype.STRING = VARCHAR(65500)
|
|
#sqltype.SWITCH = VARCHAR(6)
|
|
|
|
# For Itemtype "Number" default decimal digit count (optional, default: 3)
|
|
#numberDecimalcount=
|
|
|
|
# T A B L E O P E R A T I O N S
|
|
# Tablename Prefix String (optional, default: "item")
|
|
# for Migration from MYSQL-Bundle set to 'Item'.
|
|
#tableNamePrefix=Item
|
|
|
|
# Tablename Prefix generation, using Item real names or "item" (optional, default: false -> "item")
|
|
# If true, 'tableNamePrefix' is ignored.
|
|
tableUseRealItemNames=true
|
|
|
|
# Tablename Suffix length (optional, default: 4 -> 0001-9999)
|
|
# for Migration from MYSQL-Bundle set to 0.
|
|
#tableIdDigitCount=
|
|
|
|
# Rename existing Tables using tableUseRealItemNames and tableIdDigitCount (optional, default: false)
|
|
# USE WITH CARE! Deactivate after Renaming is done!
|
|
#rebuildTableNames=true
|
|
|
|
# D A T A B A S E C O N N E C T I O N S
|
|
# Some embeded Databases can handle only one Connection (optional, default: configured per database in packet org.openhab.persistence.jdbc.db.* )
|
|
# see: https://github.com/brettwooldridge/HikariCP/issues/256
|
|
# jdbc.maximumPoolSize = 1
|
|
# jdbc.minimumIdle = 1
|
|
|
|
# T I M E K E E P I N G
|
|
# (optional, default: false)
|
|
enableLogTime=true
|