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

この記事は、Liferayのインストールをして、データベースに接続する時に必要な Liferay DXP データベースプロパティを記載しています。 これらを使用する時は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.
    #
    # Add dynamic-data-source-spring.xml to the property "spring.configs" to
    # configure the portal to use one database cluster for read calls and
    # another database cluster for write calls. The convention is to create a
    # set of properties prefixed with "jdbc.read." to handle read calls and
    # another set of properties prefixed with "jdbc.write." to handle write
    # calls. These data sources can also be created via JNDI by setting the
    # properties "jdbc.read.jndi.name" and "jdbc.write.jndi.name". Note that
    # these settings, though separate, are a copy of the default settings with
    # the newly overridden values.
    #

 

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=