JpaMetaService

JpaMetaService type database is deprecated but still supported. For new projects, databasev2 is recommended, switching from the old version to v2 requires a migration using a custom sql script.

Configurationsparameter in repository.cfg

<repoName>.metaservice.type=databasev2
<repoName>.metaservice.databasev2.driver=
<repoName>.metaservice.databasev2.url=
<repoName>.metaservice.databasev2.user=
<repoName>.metaservice.databasev2.password=
#<repoName>.metaservice.databasev2.read-connections.max= #default: 32
#<repoName>.metaservice.databasev2.read-connections.min= #default: 32
#<repoName>.metaservice.databasev2.read-connections.shared= #default: false
#<repoName>.metaservice.databasev2.write-connections.max= #default: 32
#<repoName>.metaservice.databasev2.write-connections.min= #default: 32
#<repoName>.metaservice.databasev2.cache-statements= #default: false
#<repoName>.metaservice.databasev2.cache-statements.size= #default: 50

H2

<repoName>.metaservice.databasev2.driver=org.h2.Driver
<repoName>.metaservice.databasev2.url=jdbc:h2:C:/h2db.db;FILE_LOCK=FS;TRACE_LEVEL_SYSTEM_OUT=0

Driver is included.

Oracle

<repoName>.metaservice.databasev2.driver=oracle.jdbc.OracleDriver
<repoName>.metaservice.databasev2.url=jdbc:oracle:thin:@localhost:49161:xe

Driver is not in the delivery (ab 2.3.0), download with:

https://www.oracle.com/de/database/technologies/appdev/jdbc-downloads.html

MSSQL

<repoName>.metaservice.databasev2.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
<repoName>.metaservice.databasev2.url=jdbc:sqlserver://localhost:1433;databaseName=CONTENTSERVER;

Driver is not in the delivery, download with:
https://docs.microsoft.com/de-de/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

Objectstorage in databasesystem:

Overy object produces this number of lines, space requirement depends on database system, configuration and content:

1 line in ITEMS
5 lines in ITEMFIELDS