Liferay Portal 4 - Installation Guide

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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=.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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&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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.