Liferay Portal Enterprise was designed to be database agnostic. To make this possible, all business logic had to be concentrated in the middle tier with the database being as dumb as possible. This means the portal does not rely on any database specific stored procedures or on the database to generate unique keys.
To generate scripts that create and populate the database, go to /portal-ejb and run the ant command: ant build-db. This command will generate the scripts for DB2, Firebird, Hypersonic, Interbase, JDataStore, MySQL, Oracle, PostgreSQL, and SQL Server.
The generated scripts reside in /sql/portal and are named: portal-db2.sql, portal-firebird.sql, portal-hypersonic.sql, portal-interbase.sql, portal-jdatastore.sql, portal-mysql.sql, portal-oracle.sql, portal-postgresql.sql, and portal-sql-server.sql.
Create a database in DB2 called lportal. Use Command Center to load the script named portal-db2.sql.
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 database in InterBase located at /opt/data/lportal.gdb. At your UNIX shell or DOS prompt, type isql -U sysdba -P masterkey -d /opt/data/lportal.gdb -i portal-interbase.sql.
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.
Run the Hypersonic Database Manager and log into the database instance. Cut and paste the contents of portal-hypersonic.sql into the manager and excecute the SQL statements.
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 database in InterBase located at /opt/data/lportal.gdb. At your UNIX shell or DOS prompt, type isql -U sysdba -P masterkey -d /opt/data/lportal.gdb -i portal-firebird.sql.
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 database in InterBase located at lportal.jds. At your UNIX shell or DOS prompt, type isql -U sysdba -P masterkey -d lportal.jds -i portal-jdatastore.sql.
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 database in MySQL called lportal. At your UNIX shell or DOS prompt, type mysql lportal < portal-mysql.sql.
Note | |
---|---|
As of version 1.8.0, the old JDBC driver org.gjt.mm.mysql.Driver is replaced with the latest JDBC driver com.mysql.jdbc.Driver. The old driver stored booleans in columns of type enum('t', 'f'), the new driver stores booleans in columns of type tinyint. |
To manually update your column type, execute the SQL command alter table TableName modify column columnName tinyint;. To automatically update all your tables, execute the SQL script update1.7.5-1.8.0-mysql.sql. Follow the additional instructions from this post if you're having character encoding issues.
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&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&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&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&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&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&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&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&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&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 database in Oracle called lportal. The Oracle 9 and 10 dump scripts are available here.
Note: Do not use the default Liferay JDBC driver! The Liferay Driver was required in previous versions to work around a bug in Oracle. This is no longer required.
You must use the Oracle 10g driver located in classes12.jar whether or not you are using Oracle 9 or Oracle 10. The location of classes12.jar is usually at /oracle/product/10.2.0/db_1/jdbc/lib/classes12.jar but may be different depending on the directory where you installed Oracle.
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 database in PostgreSQL called lportal. At your UNIX shell, type psql -d lportal -f portal-postgresql.sql.
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 database in SAP called lportal. Load the script named portal-sap.sql.
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 database in SQL Server called lportal. Use Enterprise Manager to load the script named portal-sql-server.sql.
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.