Liferay DXP 7.1 Database Portal Properties

この記事は、Liferayのインストールをして、データベースに接続する時に必要な Liferay DXP 7.1の全データベースプロパティを記載しています。これらを使用する時はportal-ext.propertiesの内容を削除して指定のコードをペーストします。MySQLを有効にするには、以下をコピー＆ペーストします。 :

 #
 # MySQL
 #
 #jdbc.default.driverClassName=com.mysql.jdbc.Driver
 #jdbc.default.url=jdbc:mysql://localhost/lportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true
 #jdbc.default.username=
 #jdbc.default.password=

jdbc.default.url内の lportalをデータベース名に置き換えて、4つのプロパティー内容を削除し、該当するプロパティー内にある使用予定のデータベースのユーザーのユーザー名とパスワードを入力します。

詳細

ポータルプロパティ

##
## JDBC
##

    #
    # Set the JNDI name to lookup the JDBC data source. If none is set,
    # then the portal will attempt to create the JDBC data source based on the
    # properties prefixed with "jdbc.default.".
    #
    #jdbc.default.jndi.name=jdbc/LiferayPool

    #
    # Set the properties used to create the JDBC data source. These properties
    # will only be read if the property "jdbc.default.jndi.name" is not set.
    #
    # The default settings are configured for an in-memory database called
    # Hypersonic that is not recommended for production use. Please change the
    # properties to use another database.
    #
    # To configure the portal to use one data source for read calls and another
    # data source for read-write calls, follow these steps:
    #
    # 1. Similar to the settings prefixed with "jdbc.default.", create a set of
    # properties prefixed with "jdbc.read." to handle read calls and another
    # set of properties prefixed with "jdbc.write." to handle read-write calls.
    #
    # 2. Add "jdbc.read.jndi.name" and "jdbc.write.jndi.name" properties that
    # specify the data source JNDI names.
    #
    # 3. Add dynamic-data-source-spring.xml to the property
    # "spring.configs" and dynamic-data-source-infrastructure-spring.xml to the
    # property "spring.infrastructure.configs"
    #

DB2

    #
    # DB2
    #
    #jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver
    #jdbc.default.url=jdbc:db2://localhost:50000/lportal:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2;
    #jdbc.default.username=db2admin
    #jdbc.default.password=lportal

Hypersonic

    #
    # Hypersonic
    #
    jdbc.default.driverClassName=org.hsqldb.jdbc.JDBCDriver
    jdbc.default.url=jdbc:hsqldb:${liferay.home}/data/hypersonic/lportal;hsqldb.write_delay=false
    jdbc.default.username=sa
    jdbc.default.password=

MariaDB

    #
    # MariaDB
    #
    #jdbc.default.driverClassName=org.mariadb.jdbc.Driver
    #jdbc.default.url=jdbc:mariadb://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
    #jdbc.default.username=
    #jdbc.default.password=

MySQL

     #
    # MySQL
    #
    #jdbc.default.driverClassName=com.mysql.jdbc.Driver
    #jdbc.default.url=jdbc:mysql://localhost/lportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true
    #jdbc.default.username=
    #jdbc.default.password=

Oracle

     #
    # Oracle
    #
    #jdbc.default.driverClassName=oracle.jdbc.OracleDriver
    #jdbc.default.url=jdbc:oracle:thin:@localhost:1521:xe
    #jdbc.default.username=lportal
    #jdbc.default.password=lportal

P6Spy

     #
    # P6Spy
    #
    #jdbc.default.driverClassName=com.p6spy.engine.spy.P6SpyDriver
    #jdbc.default.url=jdbc:mysql://localhost/lportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true
    #jdbc.default.username=
    #jdbc.default.password=

PostgreSQL

     #
    # PostgreSQL
    #
    #jdbc.default.driverClassName=org.postgresql.Driver
    #jdbc.default.url=jdbc:postgresql://localhost:5432/lportal
    #jdbc.default.username=sa
    #jdbc.default.password=

SQL Server

     #
    # SQL Server
    #
    #jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
    #jdbc.default.url=jdbc:sqlserver://localhost;databaseName=lportal
    #jdbc.default.username=sa
    #jdbc.default.password=

Sybase

     #
    # Sybase
    #
    #jdbc.default.driverClassName=com.sybase.jdbc4.jdbc.SybDriver
    #jdbc.default.url=jdbc:sybase:Tds:localhost:5000/lportal
    #jdbc.default.username=sa
    #jdbc.default.password=

Liferay DXP 7.1 データベースポータルプロパティ

詳細