2. Databases

2. Databases
Prev	Chapter 2. Installation and Setup	Next

Liferay Portal Enterprise was designed to be database agnostic. To make this possible, all business logic had to be concentrated in the middle tier with the database being as dumb as possible. This means the portal does not rely on any database specific stored procedures or on the database to generate unique keys.

To generate scripts that create and populate the database, go to /portal-ejb and run the ant command: ant build-db. This command will generate the scripts for DB2, Firebird, Hypersonic, Interbase, JDataStore, MySQL, Oracle, PostgreSQL, and SQL Server.

The generated scripts reside in /sql/portal and are named: portal-db2.sql, portal-firebird.sql, portal-hypersonic.sql, portal-interbase.sql, portal-jdatastore.sql, portal-mysql.sql, portal-oracle.sql, portal-postgresql.sql, and portal-sql-server.sql.

2.1. DB2

Create a database in DB2 called lportal. Use Command Center to load the script named portal-db2.sql.

2.1.1. BES with DB2

Create a data source bound to jdbc/LiferayPool by editing jndi-definitions and creating liferay.dar. DAR files are custom to BES. You can use the BES Deployment Descriptor Editor to create the DAR file.

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>db2</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>com.liferay.jdbc.LiferayDriver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:db2://localhost:50000/lportal</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.1.2. JBoss with DB2

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:db2://localhost:50000/lportal
     </connection-url>
     <driver-class>com.liferay.jdbc.LiferayDriver</driver-class>
     <user-name>test</user-name>
     <password>test</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.1.3. Jetty with DB2

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">com.liferay.jdbc.LiferayDriver</Set>
                        <Set name="Url">jdbc:db2://localhost:50000/lportal</Set>
                        <Set name="User">test</Set>
                        <Set name="Password">test</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.1.4. JOnAS with DB2

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:db2://localhost:50000/lportal
datasource.classname=com.liferay.jdbc.LiferayDriver
datasource.username=test
datasource.password=test
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.1.5. JRun with DB2

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:db2://localhost:50000/lportal as the URL, com.liferay.jdbc.LiferayDriver as the driver, test as the user name, and test as the password.

2.1.6. OracleAS with DB2

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.liferay.jdbc.LiferayDriver"
    url="jdbc:db2://localhost:50000/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.1.7. Orion with DB2

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.liferay.jdbc.LiferayDriver"
    url="jdbc:db2://localhost:50000/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.1.8. Pramati with DB2

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:db2://localhost:50000/lportal as the URL, com.liferay.jdbc.LiferayDriver as the driver, test as the user name, and test as the password.

2.1.9. Resin with DB2

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="com.liferay.jdbc.LiferayDriver">
        <url>jdbc:db2://localhost:50000/lportal</url>
        <user>test</user>
        <password>test</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.1.10. RexIP with DB2

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="com.liferay.jdbc.LiferayDriver"
    url="jdbc:db2://localhost:50000/lportal"
    username="test"
    password="test"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.1.11. Sun JSAS with DB2

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.liferay.jdbc.LiferayDriver, url=jdbc:db2://localhost:50000/lportal, username=test, and password=test.

Create a data source bound to jdbc/LiferayPool.

2.1.12. Tomcat with DB2

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>com.liferay.jdbc.LiferayDriver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:db2://localhost:50000/lportal</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="com.liferay.jdbc.LiferayDriver"
        url="jdbc:db2://localhost:50000/lportal"
        username="test"
        password="test"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.1.13. WebLogic with DB2

Use the Administration Console to do the following:

Create a connection pool using jdbc:db2://localhost:50000/lportal as the URL, com.liferay.jdbc.LiferayDriver as the driver, test as the user name, and test as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.1.14. WebSphere with DB2

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.liferay.jdbc.LiferayDriver, url=jdbc:db2://localhost:50000/lportal, user=test, and password=test.

2.2. Firebird

Create a database in InterBase located at /opt/data/lportal.gdb. At your UNIX shell or DOS prompt, type isql -U sysdba -P masterkey -d /opt/data/lportal.gdb -i portal-interbase.sql.

2.2.1. BES with Firebird

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>firebird</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>org.firebirdsql.jdbc.FBDriver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:firebirdsql://localhost/opt/data/lportal.gdb</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>sysdba</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>masterkey</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.2.2. JBoss with Firebird

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:firebirdsql://localhost/opt/data/lportal.gdb
     </connection-url>
     <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
     <user-name>sysdba</user-name>
     <password>masterkey</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.2.3. Jetty with Firebird

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">org.firebirdsql.jdbc.FBDriver</Set>
                        <Set name="Url">jdbc:firebirdsql://localhost/opt/data/lportal.gdb</Set>
                        <Set name="User">sysdba</Set>
                        <Set name="Password">masterkey</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.2.4. JOnAS with Firebird

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:firebirdsql://localhost/opt/data/lportal.gdb
datasource.classname=org.firebirdsql.jdbc.FBDriver
datasource.username=sysdba
datasource.password=masterkey
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.2.5. JRun with Firebird

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:firebirdsql://localhost/opt/data/lportal.gdb as the URL, org.firebirdsql.jdbc.FBDriver as the driver, sysdba as the user name, and masterkey as the password.

2.2.6. OracleAS with Firebird

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="org.firebirdsql.jdbc.FBDriver"
    url="jdbc:firebirdsql://localhost/opt/data/lportal.gdb"
    username="sysdba"
    password="masterkey"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.2.7. Orion with Firebird

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="org.firebirdsql.jdbc.FBDriver"
    url="jdbc:firebirdsql://localhost/opt/data/lportal.gdb"
    username="sysdba"
    password="masterkey"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't already another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.2.8. Pramati with Firebird

Use the Management Console to do the following:

2.2.9. Resin with Firebird

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="org.firebirdsql.jdbc.FBDriver">
        <url>jdbc:firebirdsql://localhost/opt/data/lportal.gdb</url>
        <user>sysdba</user>
        <password>masterkey</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.2.10. RexIP with Firebird

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="org.firebirdsql.jdbc.FBDriver"
    url="jdbc:firebirdsql://localhost/opt/data/lportal.gdb"
    username="sysdba"
    password="masterkey"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't already another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.2.11. Sun JSAS with Firebird

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=org.firebirdsql.jdbc.FBDriver, url=jdbc:firebirdsql://localhost/opt/data/lportal.gdb, username=sysdba, and password=masterkey.

Create a data source bound to jdbc/LiferayPool.

2.2.12. Tomcat with Firebird

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>org.firebirdsql.jdbc.FBDriver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:firebirdsql://localhost/opt/data/lportal.gdb</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>sysdba</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>masterkey</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="org.firebirdsql.jdbc.FBDriver"
        url="jdbc:firebirdsql://localhost/opt/data/lportal.gdb"
        username="sysdba"
        password="masterkey"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.2.13. WebLogic with Firebird

Use the Administration Console to do the following:

Create a connection pool using jdbc:firebirdsql://localhost/opt/data/lportal.gdb as the URL, org.firebirdsql.jdbc.FBDriver as the driver, sysdba as the user name, and masterkey as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.2.14. WebSphere with Firebird

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=org.firebirdsql.jdbc.FBDriver, url=jdbc:firebirdsql://localhost/opt/data/lportal.gdb, user=sysdba, and password=masterkey.

2.3. Hypersonic

Run the Hypersonic Database Manager and log into the database instance. Cut and paste the contents of portal-hypersonic.sql into the manager and excecute the SQL statements.

2.3.1. BES with Hypersonic

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>hypersonic</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>org.hsqldb.jdbcDriver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:hsqldb:hsql://localhost</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value></prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value></prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.3.2. JBoss with Hypersonic

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:hsqldb:hsql://localhost
     </connection-url>
     <driver-class>org.hsqldb.jdbcDriver</driver-class>
     <user-name></user-name>
     <password></password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.3.3. Jetty with Hypersonic

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">org.hsqldb.jdbcDriver</Set>
                        <Set name="Url">jdbc:hsqldb:hsql://localhost</Set>
                        <Set name="User"></Set>
                        <Set name="Password"></Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.3.4. JOnAS with Hypersonic

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:hsqldb:hsql://localhost
datasource.classname=org.hsqldb.jdbcDriver
datasource.username=
datasource.password=
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.3.5. JRun with Hypersonic

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:hsqldb:hsql://localhost as the URL, org.hsqldb.jdbcDriver as the driver, as the user name, and as the password.

2.3.6. OracleAS with Hypersonic

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="org.hsqldb.jdbcDriver"
    url="jdbc:hsqldb:hsql://localhost"
    username=""
    password=""
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.3.7. Orion with Hypersonic

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="org.hsqldb.jdbcDriver"
    url="jdbc:hsqldb:hsql://localhost"
    username=""
    password=""
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.3.8. Pramati with Hypersonic

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:hsqldb:hsql://localhost as the URL, org.hsqldb.jdbcDriver as the driver, as the user name, and as the password.

2.3.9. Resin with Hypersonic

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="org.hsqldb.jdbcDriver">
        <url>jdbc:hsqldb:hsql://localhost</url>
        <user></user>
        <password></password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.3.10. RexIP with Hypersonic

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="org.hsqldb.jdbcDriver"
    url="jdbc:hsqldb:hsql://localhost"
    username=""
    password=""
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't already another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.3.11. Sun JSAS with Hypersonic

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=org.hsqldb.jdbcDriver, url=jdbc:hsqldb:hsql://localhost, username=, and password=.

Create a data source bound to jdbc/LiferayPool.

2.3.12. Tomcat with Hypersonic

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>org.hsqldb.jdbcDriver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:hsqldb:hsql://localhost</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value></value>
        </parameter>
        <parameter>
            <name>password</name>
            <value></value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="org.hsqldb.jdbcDriver"
        url="jdbc:hsqldb:hsql://localhost"
        username=""
        password=""
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.3.13. WebLogic with Hypersonic

Use the Administration Console to do the following:

Create a connection pool using jdbc:hsqldb:hsql://localhost as the URL, org.hsqldb.jdbcDriver as the driver, as the user name, and as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.3.14. WebSphere with Hypersonic

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=org.hsqldb.jdbcDriver, url=jdbc:hsqldb:hsql://localhost, user=, and password=.

2.4. InterBase

Create a database in InterBase located at /opt/data/lportal.gdb. At your UNIX shell or DOS prompt, type isql -U sysdba -P masterkey -d /opt/data/lportal.gdb -i portal-firebird.sql.

2.4.1. BES with InterBase

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>interbase</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>interbase.interclient.Driver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:interbase://localhost/opt/data/lportal.gdb</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>sysdba</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>masterkey</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.4.2. JBoss with InterBase

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:interbase://localhost/opt/data/lportal.gdb
     </connection-url>
     <driver-class>interbase.interclient.Driver</driver-class>
     <user-name>sysdba</user-name>
     <password>masterkey</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.4.3. Jetty with InterBase

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">interbase.interclient.Driver</Set>
                        <Set name="Url">jdbc:interbase://localhost/opt/data/lportal.gdb</Set>
                        <Set name="User">sysdba</Set>
                        <Set name="Password">masterkey</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.4.4. JOnAS with InterBase

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:interbase://localhost/opt/data/lportal.gdb
datasource.classname=interbase.interclient.Driver
datasource.username=sysdba
datasource.password=masterkey
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.4.5. JRun with InterBase

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:interbase://localhost/opt/data/lportal.gdb as the URL, interbase.interclient.Driver as the driver, sysdba as the user name, and masterkey as the password.

2.4.6. OracleAS with InterBase

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="interbase.interclient.Driver"
    url="jdbc:interbase://localhost/opt/data/lportal.gdb"
    username="sysdba"
    password="masterkey"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.4.7. Orion with InterBase

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="interbase.interclient.Driver"
    url="jdbc:interbase://localhost/opt/data/lportal.gdb"
    username="sysdba"
    password="masterkey"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.4.8. Pramati with InterBase

Use the Management Console to do the following:

2.4.9. Resin with InterBase

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="interbase.interclient.Driver">
        <url>jdbc:interbase://localhost/opt/data/lportal.gdb</url>
        <user>sysdba</user>
        <password>masterkey</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.4.10. RexIP with InterBase

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="interbase.interclient.Driver"
    url="jdbc:interbase://localhost/opt/data/lportal.gdb"
    username="sysdba"
    password="masterkey"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.4.11. Sun JSAS with InterBase

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=interbase.interclient.Driver, url=jdbc:interbase://localhost/opt/data/lportal.gdb, username=sysdba, and password=masterkey.

Create a data source bound to jdbc/LiferayPool.

2.4.12. Tomcat with InterBase

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>interbase.interclient.Driver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:interbase://localhost/opt/data/lportal.gdb</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>sysdba</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>masterkey</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="interbase.interclient.Driver"
        url="jdbc:interbase://localhost/opt/data/lportal.gdb"
        username="sysdba"
        password="masterkey"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.4.13. WebLogic with InterBase

Use the Administration Console to do the following:

Create a connection pool using jdbc:interbase://localhost/opt/data/lportal.gdb as the URL, interbase.interclient.Driver as the driver, sysdba as the user name, and masterkey as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.4.14. WebSphere with InterBase

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=interbase.interclient.Driver, url=jdbc:interbase://localhost/opt/data/lportal.gdb, user=sysdba, and password=masterkey.

2.5. JDataStore

Create a database in InterBase located at lportal.jds. At your UNIX shell or DOS prompt, type isql -U sysdba -P masterkey -d lportal.jds -i portal-jdatastore.sql.

2.5.1. BES with JDataStore

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>jdatastore</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>com.borland.datastore.jdbc.DataStoreDriver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:borland:dslocal:lportal.jds</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>sysdba</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>masterkey</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.5.2. JBoss with JDataStore

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:borland:dslocal:lportal.jds
     </connection-url>
     <driver-class>com.borland.datastore.jdbc.DataStoreDriver</driver-class>
     <user-name>sysdba</user-name>
     <password>masterkey</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.5.3. Jetty with JDataStore

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">com.borland.datastore.jdbc.DataStoreDriver</Set>
                        <Set name="Url">jdbc:borland:dslocal:lportal.jds</Set>
                        <Set name="User">sysdba</Set>
                        <Set name="Password">masterkey</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.5.4. JOnAS with JDataStore

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:borland:dslocal:lportal.jds
datasource.classname=com.borland.datastore.jdbc.DataStoreDriver
datasource.username=sysdba
datasource.password=masterkey
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.5.5. JRun with JDataStore

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:borland:dslocal:lportal.jds as the URL, com.borland.datastore.jdbc.DataStoreDriver as the driver, sysdba as the user name, and masterkey as the password.

2.5.6. OracleAS with JDataStore

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.borland.datastore.jdbc.DataStoreDriver"
    url="jdbc:borland:dslocal:lportal.jds"
    username="sysdba"
    password="masterkey"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.5.7. Orion with JDataStore

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.borland.datastore.jdbc.DataStoreDriver"
    url="jdbc:borland:dslocal:lportal.jds"
    username="sysdba"
    password="masterkey"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.5.8. Pramati with JDataStore

Use the Management Console to do the following:

2.5.9. Resin with JDataStore

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="com.borland.datastore.jdbc.DataStoreDriver">
        <url>jdbc:borland:dslocal:lportal.jds</url>
        <user>sysdba</user>
        <password>masterkey</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.5.10. RexIP with JDataStore

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="com.borland.datastore.jdbc.DataStoreDriver"
    url="jdbc:borland:dslocal:lportal.jds"
    username="sysdba"
    password="masterkey"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.5.11. Sun JSAS with JDataStore

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.borland.datastore.jdbc.DataStoreDriver, url=jdbc:borland:dslocal:lportal.jds, username=sysdba, and password=masterkey.

Create a data source bound to jdbc/LiferayPool.

2.5.12. Tomcat with JDataStore

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>com.borland.datastore.jdbc.DataStoreDriver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:borland:dslocal:lportal.jds</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>sysdba</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>masterkey</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="com.borland.datastore.jdbc.DataStoreDriver"
        url="jdbc:borland:dslocal:lportal.jds"
        username="sysdba"
        password="masterkey"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.5.13. WebLogic with JDataStore

Use the Administration Console to do the following:

Create a connection pool using jdbc:borland:dslocal:lportal.jds as the URL, com.borland.datastore.jdbc.DataStoreDriver as the driver, sysdba as the user name, and masterkey as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.5.14. WebSphere with JDataStore

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.borland.datastore.jdbc.DataStoreDriver, url=jdbc:borland:dslocal:lportal.jds, user=sysdba, and password=masterkey.

2.6. MySQL

Create a database in MySQL called lportal. At your UNIX shell or DOS prompt, type mysql lportal < portal-mysql.sql.

Note

As of version 1.8.0, the old JDBC driver org.gjt.mm.mysql.Driver is replaced with the latest JDBC driver com.mysql.jdbc.Driver. The old driver stored booleans in columns of type enum('t', 'f'), the new driver stores booleans in columns of type tinyint.

To manually update your column type, execute the SQL command alter table TableName modify column columnName tinyint;. To automatically update all your tables, execute the SQL script update1.7.5-1.8.0-mysql.sql. Follow the additional instructions from this post if you're having character encoding issues.

2.6.1. BES with MySQL

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>mysql</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>com.mysql.jdbc.Driver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.6.2. JBoss with MySQL

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8
     </connection-url>
     <driver-class>com.mysql.jdbc.Driver</driver-class>
     <user-name>test</user-name>
     <password>test</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.6.3. Jetty with MySQL

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">com.mysql.jdbc.Driver</Set>
                        <Set name="Url">jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8</Set>
                        <Set name="User">test</Set>
                        <Set name="Password">test</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.6.4. JOnAS with MySQL

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8
datasource.classname=com.mysql.jdbc.Driver
datasource.username=test
datasource.password=test
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.6.5. JRun with MySQL

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8 as the URL, com.mysql.jdbc.Driver as the driver, test as the user name, and test as the password.

2.6.6. OracleAS with MySQL

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.6.7. Orion with MySQL

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.6.8. Pramati with MySQL

Use the Management Console to do the following:

2.6.9. Resin with MySQL

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="com.mysql.jdbc.Driver">
        <url>jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8</url>
        <user>test</user>
        <password>test</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.6.10. RexIP with MySQL

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8"
    username="test"
    password="test"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.6.11. Sun JSAS with MySQL

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.mysql.jdbc.Driver, url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8, username=test, and password=test.

Create a data source bound to jdbc/LiferayPool.

2.6.12. Tomcat with MySQL

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>com.mysql.jdbc.Driver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost/lportal?useUnicode=true&amp;characterEncoding=UTF-8"
        username="test"
        password="test"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.6.13. WebLogic with MySQL

Use the Administration Console to do the following:

Create a connection pool using jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8 as the URL, com.mysql.jdbc.Driver as the driver, test as the user name, and test as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.6.14. WebSphere with MySQL

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.mysql.jdbc.Driver, url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8, user=test, and password=test.

2.7. Oracle

Create a database in Oracle called lportal. The Oracle 9 and 10 dump scripts are available here.

Note: Do not use the default Liferay JDBC driver! The Liferay Driver was required in previous versions to work around a bug in Oracle. This is no longer required.

You must use the Oracle 10g driver located in classes12.jar whether or not you are using Oracle 9 or Oracle 10. The location of classes12.jar is usually at /oracle/product/10.2.0/db_1/jdbc/lib/classes12.jar but may be different depending on the directory where you installed Oracle.

2.7.1. BES with Oracle

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>oracle</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>com.liferay.jdbc.LiferayDriver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:oracle:thin:@localhost:1521:orcl</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.7.2. JBoss with Oracle

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:oracle:thin:@localhost:1521:orcl
     </connection-url>
     <driver-class>com.liferay.jdbc.LiferayDriver</driver-class>
     <user-name>test</user-name>
     <password>test</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.7.3. Jetty with Oracle

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">com.liferay.jdbc.LiferayDriver</Set>
                        <Set name="Url">jdbc:oracle:thin:@localhost:1521:orcl</Set>
                        <Set name="User">test</Set>
                        <Set name="Password">test</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.7.4. JOnAS with Oracle

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:oracle:thin:@localhost:1521:orcl
datasource.classname=com.liferay.jdbc.LiferayDriver
datasource.username=test
datasource.password=test
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.7.5. JRun with Oracle

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:oracle:thin:@localhost:1521:orcl as the URL, com.liferay.jdbc.LiferayDriver as the driver, test as the user name, and test as the password.

2.7.6. OracleAS with Oracle

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.liferay.jdbc.LiferayDriver"
    url="jdbc:oracle:thin:@localhost:1521:orcl"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.7.7. Orion with Oracle

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.liferay.jdbc.LiferayDriver"
    url="jdbc:oracle:thin:@localhost:1521:orcl"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.7.8. Pramati with Oracle

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:oracle:thin:@localhost:1521:orcl as the URL, com.liferay.jdbc.LiferayDriver as the driver, test as the user name, and test as the password.

2.7.9. Resin with Oracle

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="com.liferay.jdbc.LiferayDriver">
        <url>jdbc:oracle:thin:@localhost:1521:orcl</url>
        <user>test</user>
        <password>test</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.7.10. RexIP with Oracle

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="com.liferay.jdbc.LiferayDriver"
    url="jdbc:oracle:thin:@localhost:1521:orcl"
    username="test"
    password="test"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.7.11. Sun JSAS with Oracle

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.liferay.jdbc.LiferayDriver, url=jdbc:oracle:thin:@localhost:1521:orcl, username=test, and password=test.

Create a data source bound to jdbc/LiferayPool.

2.7.12. Tomcat with Oracle

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>com.liferay.jdbc.LiferayDriver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:oracle:thin:@localhost:1521:orcl</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="com.liferay.jdbc.LiferayDriver"
        url="jdbc:oracle:thin:@localhost:1521:orcl"
        username="test"
        password="test"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.7.13. WebLogic with Oracle

Use the Administration Console to do the following:

Create a connection pool using jdbc:oracle:thin:@localhost:1521:orcl as the URL, com.liferay.jdbc.LiferayDriver as the driver, test as the user name, and test as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.7.14. WebSphere with Oracle

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.liferay.jdbc.LiferayDriver, url=jdbc:oracle:thin:@localhost:1521:orcl, user=test, and password=test.

2.8. PostgreSQL

Create a database in PostgreSQL called lportal. At your UNIX shell, type psql -d lportal -f portal-postgresql.sql.

2.8.1. BES with PostgreSQL

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>postgresql</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>org.postgresql.Driver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:postgresql://localhost/lportal</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.8.2. JBoss with PostgreSQL

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:postgresql://localhost/lportal
     </connection-url>
     <driver-class>org.postgresql.Driver</driver-class>
     <user-name>test</user-name>
     <password>test</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.8.3. Jetty with PostgreSQL

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">org.postgresql.Driver</Set>
                        <Set name="Url">jdbc:postgresql://localhost/lportal</Set>
                        <Set name="User">test</Set>
                        <Set name="Password">test</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.8.4. JOnAS with PostgreSQL

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:postgresql://localhost/lportal
datasource.classname=org.postgresql.Driver
datasource.username=test
datasource.password=test
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.8.5. JRun with PostgreSQL

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:postgresql://localhost/lportal as the URL, org.postgresql.Driver as the driver, test as the user name, and test as the password.

2.8.6. OracleAS with PostgreSQL

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="org.postgresql.Driver"
    url="jdbc:postgresql://localhost/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.8.7. Orion with PostgreSQL

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="org.postgresql.Driver"
    url="jdbc:postgresql://localhost/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.8.8. Pramati with PostgreSQL

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:postgresql://localhost/lportal as the URL, org.postgresql.Driver as the driver, test as the user name, and test as the password.

2.8.9. Resin with PostgreSQL

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="org.postgresql.Driver">
        <url>jdbc:postgresql://localhost/lportal</url>
        <user>test</user>
        <password>test</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.8.10. RexIP with PostgreSQL

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="org.postgresql.Driver"
    url="jdbc:postgresql://localhost/lportal"
    username="test"
    password="test"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.8.11. Sun JSAS with PostgreSQL

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=org.postgresql.Driver, url=jdbc:postgresql://localhost/lportal, username=test, and password=test.

Create a data source bound to jdbc/LiferayPool.

2.8.12. Tomcat with PostgreSQL

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>org.postgresql.Driver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:postgresql://localhost/lportal</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://localhost/lportal"
        username="test"
        password="test"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.8.13. WebLogic with PostgreSQL

Use the Administration Console to do the following:

Create a connection pool using jdbc:postgresql://localhost/lportal as the URL, org.postgresql.Driver as the driver, test as the user name, and test as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.8.14. WebSphere with PostgreSQL

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=org.postgresql.Driver, url=jdbc:postgresql://localhost/lportal, user=test, and password=test.

2.9. SAP

Create a database in SAP called lportal. Load the script named portal-sap.sql.

2.9.1. BES with SAP

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>sapdb</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>com.sap.dbtech.jdbc.DriverSapDB</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:sapdb://localhost/lportal</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.9.2. JBoss with SAP

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:sapdb://localhost/lportal
     </connection-url>
     <driver-class>com.sap.dbtech.jdbc.DriverSapDB</driver-class>
     <user-name>test</user-name>
     <password>test</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.9.3. Jetty with SAP

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">com.sap.dbtech.jdbc.DriverSapDB</Set>
                        <Set name="Url">jdbc:sapdb://localhost/lportal</Set>
                        <Set name="User">test</Set>
                        <Set name="Password">test</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.9.4. JOnAS with SAP

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:sapdb://localhost/lportal
datasource.classname=com.sap.dbtech.jdbc.DriverSapDB
datasource.username=test
datasource.password=test
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.9.5. JRun with SAP

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:sapdb://localhost/lportal as the URL, com.sap.dbtech.jdbc.DriverSapDB as the driver, test as the user name, and test as the password.

2.9.6. OracleAS with SAP

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.sap.dbtech.jdbc.DriverSapDB"
    url="jdbc:sapdb://localhost/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.9.7. Orion with SAP

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="com.sap.dbtech.jdbc.DriverSapDB"
    url="jdbc:sapdb://localhost/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.9.8. Pramati with SAP

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:sapdb://localhost/lportal as the URL, com.sap.dbtech.jdbc.DriverSapDB as the driver, test as the user name, and test as the password.

2.9.9. Resin with SAP

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="com.sap.dbtech.jdbc.DriverSapDB">
        <url>jdbc:sapdb://localhost/lportal</url>
        <user>test</user>
        <password>test</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.9.10. RexIP with SAP

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="com.sap.dbtech.jdbc.DriverSapDB"
    url="jdbc:sapdb://localhost/lportal"
    username="test"
    password="test"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.9.11. Sun JSAS with SAP

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.sap.dbtech.jdbc.DriverSapDB, url=jdbc:sapdb://localhost/lportal, username=test, and password=test.

Create a data source bound to jdbc/LiferayPool.

2.9.12. Tomcat with SAP

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>com.sap.dbtech.jdbc.DriverSapDB</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:sapdb://localhost/lportal</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="com.sap.dbtech.jdbc.DriverSapDB"
        url="jdbc:sapdb://localhost/lportal"
        username="test"
        password="test"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.9.13. WebLogic with SAP

Use the Administration Console to do the following:

Create a connection pool using jdbc:sapdb://localhost/lportal as the URL, com.sap.dbtech.jdbc.DriverSapDB as the driver, test as the user name, and test as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.9.14. WebSphere with SAP

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.sap.dbtech.jdbc.DriverSapDB, url=jdbc:sapdb://localhost/lportal, user=test, and password=test.

2.10. SQL Server

Create a database in SQL Server called lportal. Use Enterprise Manager to load the script named portal-sql-server.sql.

2.10.1. BES with SQL Server

<jndi-definitions>
    <visitransact-datasource>
        <jndi-name>jdbc/LiferayPool</jndi-name>
        <driver-datasource-jndiname>datasources/JdsLiferayDriver</driver-datasource-jndiname>
        <property>
            <prop-name>connectionType</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>Direct</prop-value>
        </property>
        <property>
            <prop-name>dialect</prop-name>
            <prop-type>Enumerated</prop-type>
            <prop-value>sqlserver</prop-value>
        </property>
    </visitransact-datasource>
    <driver-datasource>
        <jndi-name>datasources/JdsLiferayDriver</jndi-name>
        <datasource-class-name>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</datasource-class-name>
        <log-writer>False</log-writer>
        <property>
            <prop-name>driver</prop-name>
            <prop-type>String</prop-type>
            <prop-value>net.sourceforge.jtds.jdbc.Driver</prop-value>
        </property>
        <property>
            <prop-name>url</prop-name>
            <prop-type>String</prop-type>
            <prop-value>jdbc:jtds:sqlserver://localhost/lportal</prop-value>
        </property>
        <property>
            <prop-name>username</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
        <property>
            <prop-name>password</prop-name>
            <prop-type>String</prop-type>
            <prop-value>test</prop-value>
        </property>
    </driver-datasource>
</jndi-definitions>

Copy the JDBC driver to a path that can be picked up by BES. JDBC drivers can be found from the database vendor's web site.

2.10.2. JBoss with SQL Server

Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.

<datasources>
   <local-tx-datasource>
     <jndi-name>jdbc/LiferayPool</jndi-name>
     <connection-url>
         jdbc:jtds:sqlserver://localhost/lportal
     </connection-url>
     <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
     <user-name>test</user-name>
     <password>test</password>
     <min-pool-size>0</min-pool-size>
   </local-tx-datasource>
</datasources>

Copy the JDBC driver for to /server/default/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.10.3. Jetty with SQL Server

Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.

<Call name="addService">
    <Arg>
        <New class="org.mortbay.jetty.plus.JotmService">
            <Set name="Name">TransactionMgr</Set>
            <Call name="addDataSource">
                <Arg>jdbc/LiferayPool</Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.standard.StandardXADataSource">
                        <Set name="DriverName">net.sourceforge.jtds.jdbc.Driver</Set>
                        <Set name="Url">jdbc:jtds:sqlserver://localhost/lportal</Set>
                        <Set name="User">test</Set>
                        <Set name="Password">test</Set>
                    </New>
                </Arg>
                <Arg>
                    <New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
                        <Arg type="Integer">4</Arg>
                        <Set name="MinSize">4</Set>
                        <Set name="MaxSize">15</Set>
                    </New>
                </Arg>
            </Call>
        </New>
    </Arg>
</Call>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

2.10.4. JOnAS with SQL Server

Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.

datasource.name=jdbc/LiferayPool
datasource.url=jdbc:jtds:sqlserver://localhost/lportal
datasource.classname=net.sourceforge.jtds.jdbc.Driver
datasource.username=test
datasource.password=test
datasource.mapper=

Copy the JDBC driver for to /lib/ext. JDBC drivers can be found from the database vendor's web site.

2.10.5. JRun with SQL Server

Use the Management Console to do the following:

Create a data source bound to jdbc/LiferayPool using jdbc:jtds:sqlserver://localhost/lportal as the URL, net.sourceforge.jtds.jdbc.Driver as the driver, test as the user name, and test as the password.

2.10.6. OracleAS with SQL Server

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="net.sourceforge.jtds.jdbc.Driver"
    url="jdbc:jtds:sqlserver://localhost/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver to /j2ee/home/lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't already another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.10.7. Orion with SQL Server

Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.

<data-source
    class="com.evermind.sql.DriverManagerDataSource"
    name="Liferay"
    location="jdbc/LiferayCore"
    pooled-location="jdbc/LiferayPool"
    xa-location="jdbc/xa/LiferayXA"
    ejb-location="jdbc/LiferayEJB"
    connection-driver="net.sourceforge.jtds.jdbc.Driver"
    url="jdbc:jtds:sqlserver://localhost/lportal"
    username="test"
    password="test"
    inactivity-timeout="30"
    schema="database-schemas/"
/>

Copy the JDBC driver for to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.10.8. Pramati with SQL Server

Use the Management Console to do the following:

2.10.9. Resin with SQL Server

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /conf/resin.conf.

<database>
    <jndi-name>jdbc/LiferayPool</jndi-name>
    <driver type="net.sourceforge.jtds.jdbc.Driver">
        <url>jdbc:jtds:sqlserver://localhost/lportal</url>
        <user>test</user>
        <password>test</password>
    </driver>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.10.10. RexIP with SQL Server

Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.

<datasource
    name="LiferayPool"
    jndi-name="jdbc/LiferayPool"
    driver="net.sourceforge.jtds.jdbc.Driver"
    url="jdbc:jtds:sqlserver://localhost/lportal"
    username="test"
    password="test"
    max-pool="100"
    transactional="false"
/>

Copy the JDBC driver to /lib. JDBC drivers can be found from the database vendor's web site.

Make sure there isn't another data source bound to jdbc/LiferayPool. If there is a duplicate service, undeploy it by removing its xml configuration.

2.10.11. Sun JSAS with SQL Server

Use the Administration Console to do the following:

Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=net.sourceforge.jtds.jdbc.Driver, url=jdbc:jtds:sqlserver://localhost/lportal, username=test, and password=test.

Create a data source bound to jdbc/LiferayPool.

2.10.12. Tomcat with SQL Server

For Tomcat 5.0.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml.

<Context...>
    ...
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
    />
    <ResourceParams name="jdbc/LiferayPool">
        <parameter>
            <name>driverClassName</name>
            <value>net.sourceforge.jtds.jdbc.Driver</value>
        </parameter>
        <parameter>
            <name>url</name>
            <value>jdbc:jtds:sqlserver://localhost/lportal</value>
        </parameter>
        <parameter>
            <name>username</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>test</value>
        </parameter>
        <parameter>
            <name>maxActive</name>
            <value>20</value>
        </parameter>
    </ResourceParams>
</Context>

For Tomcat 5.5.x, create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/ROOT.xml.

<Context...>
    <Resource
        name="jdbc/LiferayPool"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="net.sourceforge.jtds.jdbc.Driver"
        url="jdbc:jtds:sqlserver://localhost/lportal"
        username="test"
        password="test"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />
</Context>

For Tomcat 5.0.x and 5.5.x, copy the JDBC driver to /common/lib. JDBC drivers can be found from the database vendor's web site.

2.10.13. WebLogic with SQL Server

Use the Administration Console to do the following:

Create a connection pool using jdbc:jtds:sqlserver://localhost/lportal as the URL, net.sourceforge.jtds.jdbc.Driver as the driver, test as the user name, and test as the password.

Create a data source bound to jdbc/LiferayPool.

Create a Tx data source bound to jdbc/LiferayEJB.

2.10.14. WebSphere with SQL Server

Use the Administrative Console: Resources -> JDBC Providers.

Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.

Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.

Create a data source bound to jdbc/LiferayPool. The custom properties are driver=net.sourceforge.jtds.jdbc.Driver, url=jdbc:jtds:sqlserver://localhost/lportal, user=test, and password=test.

Prev	Up	Next
1. Application Servers	Home	3. Upgrade to new versions of Liferay