|
|
Posted on 2005-01-21 15:47 海天一鸥 阅读(1314) 评论(0) 编辑 收藏 所属分类: Java数据库技术
J2EE是个开放的世界，因此各个应用服务器有自己的配置文件格式。下面摘录了Liferay Portal Enterprise 的连接字符串的说明文档。 基本上针对各种数据库有个完备的说明了，以后查阅不用到处去找了。 Databases
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, 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-mysql.sql, portal-oracle.sql, portal-postgresql.sql, and portal-sql-server.sql. |
| I. |
|
DB2 |
| II. |
|
Firebird |
| III. |
|
Hypersonic |
| IV. |
|
InterBase |
| V. |
|
MySQL |
| VI. |
|
Oracle |
| VII. |
|
PostgreSQL |
| VIII. |
|
SAP |
| IX. |
|
SQL Server |
|
| I. |
|
DB2 |
|
| |
| a. |
|
Create a database in DB2 called lportal. Use Command Center to load the script named portal-db2.sql. |
|
| b. |
|
JBoss with DB2
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:db2://localhost/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 DB2 to /server/default/lib. JDBC Drivers can be found from the database vendor's web site.
Note: On startup, JBoss will throw a org.jboss.util.NestedSQLException with the message "Apparently wrong driver class specified for URL." That message comes up because we are using a wrapper for the DB2 driver. The Liferay driver will continue to work and the message can be ignored.
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. |
|
| c. |
|
Jetty with DB2
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">com.liferay.jdbc.LiferayDriver</Set>
<Set name="Url">jdbc:db2://localhost/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 DB2 to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with DB2
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:db2://localhost/lportal
datasource.classname=com.liferay.jdbc.LiferayDriver
datasource.username=test
datasource.password=test
datasource.mapper=rdb.db2
Copy the JDBC driver for DB2 to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with DB2
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:db2://localhost/lportal as the URL, com.liferay.jdbc.LiferayDriver as the driver, "test" as the user name, and "test" as the password. |
|
| f. |
|
Oracle9iAS with DB2
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.liferay.jdbc.LiferayDriver"
url="jdbc:db2://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/db2.xml"
/>
Copy the JDBC driver for DB2 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. |
|
| g. |
|
Orion with DB2
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.liferay.jdbc.LiferayDriver"
url="jdbc:db2://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/db2.xml"
/>
Copy the JDBC driver for DB2 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. |
|
| h. |
|
Pramati with DB2
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:db2://localhost/lportal as the URL, com.liferay.jdbc.LiferayDriver as the driver, "test" as the user name, and "test" as the password. |
|
| i. |
|
RexIP with DB2
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="com.liferay.jdbc.LiferayDriver"
url="jdbc:db2://localhost/lportal"
username="test"
password="test"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for DB2 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. |
|
| j. |
|
Sun JSAS with DB2
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.liferay.jdbc.LiferayDriver, url=jdbc:db2://localhost/lportal, username=test, and password=test.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with DB2
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/lportal</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>password</name>
<value>test</value>
</parameter>
</ResourceParams>
</Context>
Copy the JDBC driver for DB2 to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with DB2
Use the Administration Console to do the following:
Create a connection pool using jdbc:db2://localhost/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. |
|
| m. |
|
WebSphere with DB2
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.liferay.jdbc.LiferayDriver, url=jdbc:db2://localhost/lportal, username=test, and password=test. | |
|
| II. |
|
Firebird |
|
| |
| a. |
|
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. |
|
| b. |
|
JBoss with Firebird
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:firebirdsql://localhost/opt/data/lportal.gdb
</connection-url>
<driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
<user-name>sysdba</user-name>
<password>masterkey</password>
<min-pool-size>0</min-pool-size>
</local-tx-datasource>
</datasources>
Copy the JDBC driver for Firebird to /server/default/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. |
|
| c. |
|
Jetty with Firebird
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">org.firebirdsql.jdbc.FBDriver</Set>
<Set name="Url">jdbc:firebirdsql://localhost/opt/data/lportal.gdb</Set>
<Set name="User">sysdba</Set>
<Set name="Password">masterkey</Set>
</New>
</Arg>
<Arg>
<New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
<Arg type="Integer">4</Arg>
<Set name="MinSize">4</Set>
<Set name="MaxSize">15</Set>
</New>
</Arg>
</Call>
</New>
</Arg>
</Call>
Copy the JDBC driver for Firebird to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with Firebird
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:firebirdsql://localhost/opt/data/lportal.gdb
datasource.classname=org.firebirdsql.jdbc.FBDriver
datasource.username=sysdba
datasource.password=masterkey
datasource.mapper=rdb.firebird
Copy the JDBC driver for Firebird to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with Firebird
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:firebirdsql://localhost/opt/data/lportal.gdb as the URL, org.firebirdsql.jdbc.FBDriver as the driver, "sysdba" as the user name, and "masterkey" as the password. |
|
| f. |
|
Oracle9iAS with Firebird
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="org.firebirdsql.jdbc.FBDriver"
url="jdbc:firebirdsql://localhost/opt/data/lportal.gdb"
username="sysdba"
password="masterkey"
inactivity-timeout="30"
/>
Copy the JDBC driver for Firebird 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. |
|
| g. |
|
Orion with Firebird
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="org.firebirdsql.jdbc.FBDriver"
url="jdbc:firebirdsql://localhost/opt/data/lportal.gdb"
username="sysdba"
password="masterkey"
inactivity-timeout="30"
/>
Copy the JDBC driver for Firebird 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. |
|
| h. |
|
Pramati with Firebird
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:firebirdsql://localhost/opt/data/lportal.gdb as the URL, org.firebirdsql.jdbc.FBDriver as the driver, "sysdba" as the user name, and "masterkey" as the password. |
|
| i. |
|
RexIP with Firebird
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="org.firebirdsql.jdbc.FBDriver"
url="jdbc:firebirdsql://localhost/opt/data/lportal.gdb"
username="sysdba"
password="masterkey"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for Firebird 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. |
|
| j. |
|
Sun JSAS with Firebird
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=org.firebirdsql.jdbc.FBDriver, url=jdbc:firebirdsql://localhost/opt/data/lportal.gdb, username=sysdba, and password=masterkey.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with Firebird
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>
</ResourceParams>
</Context>
Copy the JDBC driver for Firebird to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with Firebird
Use the Administration Console to do the following:
Create a connection pool using jdbc:firebirdsql://localhost/opt/data/lportal.gdb as the URL, org.firebirdsql.jdbc.FBDriver as the driver, "sysdba" as the user name, and "masterkey" as the password.
Create a data source bound to jdbc/LiferayPool.
Create a Tx data source bound to jdbc/LiferayEJB. |
|
| m. |
|
WebSphere with Firebird
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=org.firebirdsql.jdbc.FBDriver, url=jdbc:firebirdsql://localhost/opt/data/lportal.gdb, username=sysdba, and password=masterkey. | |
|
| III. |
|
Hypersonic |
|
| |
| a. |
|
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. |
|
| b. |
|
JBoss with Hypersonic
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:hsqldb:hsql://localhost
</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name></user-name>
<password></password>
<min-pool-size>0</min-pool-size>
</local-tx-datasource>
</datasources>
Copy the JDBC driver for Hypersonic to /server/default/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. |
|
| c. |
|
Jetty with Hypersonic
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">org.hsqldb.jdbcDriver</Set>
<Set name="Url">jdbc:hsqldb:hsql://localhost</Set>
<Set name="User"></Set>
<Set name="Password"></Set>
</New>
</Arg>
<Arg>
<New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
<Arg type="Integer">4</Arg>
<Set name="MinSize">4</Set>
<Set name="MaxSize">15</Set>
</New>
</Arg>
</Call>
</New>
</Arg>
</Call>
Copy the JDBC driver for Hypersonic to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with Hypersonic
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:hsqldb:hsql://localhost
datasource.classname=org.hsqldb.jdbcDriver
datasource.username=
datasource.password=
datasource.mapper=rdb.hsql
Copy the JDBC driver for Hypersonic to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with Hypersonic
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:hsqldb:hsql://localhost as the URL, org.hsqldb.jdbcDriver as the driver, "" as the user name, and "" as the password. |
|
| f. |
|
Oracle9iAS with Hypersonic
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost"
username=""
password=""
inactivity-timeout="30"
schema="database-schemas/hypersonic.xml"
/>
Copy the JDBC driver for Hypersonic 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. |
|
| g. |
|
Orion with Hypersonic
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost"
username=""
password=""
inactivity-timeout="30"
schema="database-schemas/hypersonic.xml"
/>
Copy the JDBC driver for Hypersonic 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. |
|
| h. |
|
Pramati with Hypersonic
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:hsqldb:hsql://localhost as the URL, org.hsqldb.jdbcDriver as the driver, "" as the user name, and "" as the password. |
|
| i. |
|
RexIP with Hypersonic
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost"
username=""
password=""
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for Hypersonic 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. |
|
| j. |
|
Sun JSAS with Hypersonic
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=org.hsqldb.jdbcDriver, url=jdbc:hsqldb:hsql://localhost, username=, and password=.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with Hypersonic
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>
</ResourceParams>
</Context>
Copy the JDBC driver for Hypersonic to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with Hypersonic
Use the Administration Console to do the following:
Create a connection pool using jdbc:hsqldb:hsql://localhost as the URL, org.hsqldb.jdbcDriver as the driver, "" as the user name, and "" as the password.
Create a data source bound to jdbc/LiferayPool.
Create a Tx data source bound to jdbc/LiferayEJB. |
|
| m. |
|
WebSphere with Hypersonic
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=org.hsqldb.jdbcDriver, url=jdbc:hsqldb:hsql://localhost, username=, and password=. | |
|
| IV. |
|
InterBase |
|
| |
| a. |
|
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. |
|
| b. |
|
JBoss with InterBase
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:interbase://localhost/opt/data/lportal.gdb
</connection-url>
<driver-class>interbase.interclient.Driver</driver-class>
<user-name>sysdba</user-name>
<password>masterkey</password>
<min-pool-size>0</min-pool-size>
</local-tx-datasource>
</datasources>
Copy the JDBC driver for InterBase to /server/default/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. |
|
| c. |
|
Jetty with InterBase
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">interbase.interclient.Driver</Set>
<Set name="Url">jdbc:interbase://localhost/opt/data/lportal.gdb</Set>
<Set name="User">sysdba</Set>
<Set name="Password">masterkey</Set>
</New>
</Arg>
<Arg>
<New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
<Arg type="Integer">4</Arg>
<Set name="MinSize">4</Set>
<Set name="MaxSize">15</Set>
</New>
</Arg>
</Call>
</New>
</Arg>
</Call>
Copy the JDBC driver for InterBase to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with InterBase
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:interbase://localhost/opt/data/lportal.gdb
datasource.classname=interbase.interclient.Driver
datasource.username=sysdba
datasource.password=masterkey
datasource.mapper=rdb.firebird
Copy the JDBC driver for InterBase to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with InterBase
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:interbase://localhost/opt/data/lportal.gdb as the URL, interbase.interclient.Driver as the driver, "sysdba" as the user name, and "masterkey" as the password. |
|
| f. |
|
Oracle9iAS with InterBase
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="interbase.interclient.Driver"
url="jdbc:interbase://localhost/opt/data/lportal.gdb"
username="sysdba"
password="masterkey"
inactivity-timeout="30"
/>
Copy the JDBC driver for InterBase 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. |
|
| g. |
|
Orion with InterBase
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="interbase.interclient.Driver"
url="jdbc:interbase://localhost/opt/data/lportal.gdb"
username="sysdba"
password="masterkey"
inactivity-timeout="30"
/>
Copy the JDBC driver for InterBase 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. |
|
| h. |
|
Pramati with InterBase
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:interbase://localhost/opt/data/lportal.gdb as the URL, interbase.interclient.Driver as the driver, "sysdba" as the user name, and "masterkey" as the password. |
|
| i. |
|
RexIP with InterBase
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="interbase.interclient.Driver"
url="jdbc:interbase://localhost/opt/data/lportal.gdb"
username="sysdba"
password="masterkey"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for InterBase 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. |
|
| j. |
|
Sun JSAS with InterBase
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=interbase.interclient.Driver, url=jdbc:interbase://localhost/opt/data/lportal.gdb, username=sysdba, and password=masterkey.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with InterBase
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>
</ResourceParams>
</Context>
Copy the JDBC driver for InterBase to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with InterBase
Use the Administration Console to do the following:
Create a connection pool using jdbc:interbase://localhost/opt/data/lportal.gdb as the URL, interbase.interclient.Driver as the driver, "sysdba" as the user name, and "masterkey" as the password.
Create a data source bound to jdbc/LiferayPool.
Create a Tx data source bound to jdbc/LiferayEJB. |
|
| m. |
|
WebSphere with InterBase
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=interbase.interclient.Driver, url=jdbc:interbase://localhost/opt/data/lportal.gdb, username=sysdba, and password=masterkey. | |
|
| V. |
|
MySQL |
|
| |
| a. |
|
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. |
|
| b. |
|
JBoss with MySQL
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:mysql://localhost/lportal
</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 MySQL to /server/default/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. |
|
| c. |
|
Jetty with MySQL
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">com.mysql.jdbc.Driver</Set>
<Set name="Url">jdbc:mysql://localhost/lportal</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 MySQL to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with MySQL
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:mysql://localhost/lportal
datasource.classname=com.mysql.jdbc.Driver
datasource.username=test
datasource.password=test
datasource.mapper=rdb.mysql
Copy the JDBC driver for MySQL to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with MySQL
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:mysql://localhost/lportal as the URL, com.mysql.jdbc.Driver as the driver, "test" as the user name, and "test" as the password. |
|
| f. |
|
Oracle9iAS with MySQL
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/mysql.xml"
/>
Copy the JDBC driver for MySQL 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. |
|
| g. |
|
Orion with MySQL
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/mysql.xml"
/>
Copy the JDBC driver for MySQL 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. |
|
| h. |
|
Pramati with MySQL
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:mysql://localhost/lportal as the URL, com.mysql.jdbc.Driver as the driver, "test" as the user name, and "test" as the password. |
|
| i. |
|
RexIP with MySQL
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/lportal"
username="test"
password="test"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for MySQL 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. |
|
| j. |
|
Sun JSAS with MySQL
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.mysql.jdbc.Driver, url=jdbc:mysql://localhost/lportal, username=test, and password=test.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with MySQL
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</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>password</name>
<value>test</value>
</parameter>
</ResourceParams>
</Context>
Copy the JDBC driver for MySQL to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with MySQL
Use the Administration Console to do the following:
Create a connection pool using jdbc:mysql://localhost/lportal 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. |
|
| m. |
|
WebSphere with MySQL
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.mysql.jdbc.Driver, url=jdbc:mysql://localhost/lportal, username=test, and password=test. | |
|
| VI. |
|
Oracle |
|
| |
| a. |
|
Create a database in Oracle called lportal. Go to SQL Plus and type @/portal-ejb/src/portal-oracle.sql;.
Note: There is a bug with with the Oracle JDBC driver which will not allow O/R tools to access columns over 4 kb. This affects some of the functionality of the portal. A workaround is to use the Liferay JDBC driver that acts as a wrapper to ensure that columns over 4 kb read and persist properly. The Liferay JDBC driver determines which actual driver to load based on the connection URL. If you pass in a URL that contains the string jdbc:oracle:thin, it will know to load oracle.jdbc.driver.OracleDriver. |
|
| b. |
|
JBoss with Oracle
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:oracle:thin:@localhost:1521: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 Oracle to /server/default/lib. JDBC Drivers can be found from the database vendor's web site.
Note: On startup, JBoss will throw a org.jboss.util.NestedSQLException with the message "Apparently wrong driver class specified for URL." That message comes up because we are using a wrapper for the Oracle driver. The Liferay driver will continue to work and the message can be ignored.
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. |
|
| c. |
|
Jetty with Oracle
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">com.liferay.jdbc.LiferayDriver</Set>
<Set name="Url">jdbc:oracle:thin:@localhost:1521: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 Oracle to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with Oracle
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:oracle:thin:@localhost:1521:lportal
datasource.classname=com.liferay.jdbc.LiferayDriver
datasource.username=test
datasource.password=test
datasource.mapper=rdb.oracle
Copy the JDBC driver for Oracle to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with Oracle
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:oracle:thin:@localhost:1521:lportal as the URL, com.liferay.jdbc.LiferayDriver as the driver, "test" as the user name, and "test" as the password. |
|
| f. |
|
Oracle9iAS with Oracle
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.liferay.jdbc.LiferayDriver"
url="jdbc:oracle:thin:@localhost:1521:lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/oracle.xml"
/>
Copy the JDBC driver for Oracle 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. |
|
| g. |
|
Orion with Oracle
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.liferay.jdbc.LiferayDriver"
url="jdbc:oracle:thin:@localhost:1521:lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/oracle.xml"
/>
Copy the JDBC driver for Oracle 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. |
|
| h. |
|
Pramati with Oracle
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:oracle:thin:@localhost:1521:lportal as the URL, com.liferay.jdbc.LiferayDriver as the driver, "test" as the user name, and "test" as the password. |
|
| i. |
|
RexIP with Oracle
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="com.liferay.jdbc.LiferayDriver"
url="jdbc:oracle:thin:@localhost:1521:lportal"
username="test"
password="test"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for Oracle 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. |
|
| j. |
|
Sun JSAS with Oracle
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.liferay.jdbc.LiferayDriver, url=jdbc:oracle:thin:@localhost:1521:lportal, username=test, and password=test.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with Oracle
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:lportal</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>password</name>
<value>test</value>
</parameter>
</ResourceParams>
</Context>
Copy the JDBC driver for Oracle to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with Oracle
Use the Administration Console to do the following:
Create a connection pool using jdbc:oracle:thin:@localhost:1521: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. |
|
| m. |
|
WebSphere with Oracle
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.liferay.jdbc.LiferayDriver, url=jdbc:oracle:thin:@localhost:1521:lportal, username=test, and password=test. | |
|
| VII. |
|
PostgreSQL |
|
| |
| a. |
|
Create a database in PostgreSQL called lportal. At your UNIX shell, type psql -d lportal -f portal-postgresql.sql. |
|
| b. |
|
JBoss with PostgreSQL
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:postgresql://localhost/lportal
</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>test</user-name>
<password>test</password>
<min-pool-size>0</min-pool-size>
</local-tx-datasource>
</datasources>
Copy the JDBC driver for PostgreSQL to /server/default/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. |
|
| c. |
|
Jetty with PostgreSQL
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">org.postgresql.Driver</Set>
<Set name="Url">jdbc:postgresql://localhost/lportal</Set>
<Set name="User">test</Set>
<Set name="Password">test</Set>
</New>
</Arg>
<Arg>
<New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
<Arg type="Integer">4</Arg>
<Set name="MinSize">4</Set>
<Set name="MaxSize">15</Set>
</New>
</Arg>
</Call>
</New>
</Arg>
</Call>
Copy the JDBC driver for PostgreSQL to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with PostgreSQL
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:postgresql://localhost/lportal
datasource.classname=org.postgresql.Driver
datasource.username=test
datasource.password=test
datasource.mapper=rdb.postgres
Copy the JDBC driver for PostgreSQL to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with PostgreSQL
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:postgresql://localhost/lportal as the URL, org.postgresql.Driver as the driver, "test" as the user name, and "test" as the password. |
|
| f. |
|
Oracle9iAS with PostgreSQL
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/postgresql.xml"
/>
Copy the JDBC driver for PostgreSQL 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. |
|
| g. |
|
Orion with PostgreSQL
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/postgresql.xml"
/>
Copy the JDBC driver for PostgreSQL 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. |
|
| h. |
|
Pramati with PostgreSQL
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:postgresql://localhost/lportal as the URL, org.postgresql.Driver as the driver, "test" as the user name, and "test" as the password. |
|
| i. |
|
RexIP with PostgreSQL
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost/lportal"
username="test"
password="test"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for PostgreSQL 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. |
|
| j. |
|
Sun JSAS with PostgreSQL
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=org.postgresql.Driver, url=jdbc:postgresql://localhost/lportal, username=test, and password=test.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with PostgreSQL
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>
</ResourceParams>
</Context>
Copy the JDBC driver for PostgreSQL to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with PostgreSQL
Use the Administration Console to do the following:
Create a connection pool using jdbc:postgresql://localhost/lportal as the URL, org.postgresql.Driver as the driver, "test" as the user name, and "test" as the password.
Create a data source bound to jdbc/LiferayPool.
Create a Tx data source bound to jdbc/LiferayEJB. |
|
| m. |
|
WebSphere with PostgreSQL
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=org.postgresql.Driver, url=jdbc:postgresql://localhost/lportal, username=test, and password=test. | |
|
| VIII. |
|
SAP |
|
| |
| a. |
|
Create a database in SAP called lportal. Load the script named portal-sap.sql. |
|
| b. |
|
JBoss with SAP
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:sapdb://localhost/lportal
</connection-url>
<driver-class>com.sap.dbtech.jdbc.DriverSapDB</driver-class>
<user-name>test</user-name>
<password>test</password>
<min-pool-size>0</min-pool-size>
</local-tx-datasource>
</datasources>
Copy the JDBC driver for SAP to /server/default/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. |
|
| c. |
|
Jetty with SAP
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">com.sap.dbtech.jdbc.DriverSapDB</Set>
<Set name="Url">jdbc:sapdb://localhost/lportal</Set>
<Set name="User">test</Set>
<Set name="Password">test</Set>
</New>
</Arg>
<Arg>
<New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
<Arg type="Integer">4</Arg>
<Set name="MinSize">4</Set>
<Set name="MaxSize">15</Set>
</New>
</Arg>
</Call>
</New>
</Arg>
</Call>
Copy the JDBC driver for SAP to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with SAP
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:sapdb://localhost/lportal
datasource.classname=com.sap.dbtech.jdbc.DriverSapDB
datasource.username=test
datasource.password=test
datasource.mapper=rdb.sapdb
Copy the JDBC driver for SAP to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with SAP
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:sapdb://localhost/lportal as the URL, com.sap.dbtech.jdbc.DriverSapDB as the driver, "test" as the user name, and "test" as the password. |
|
| f. |
|
Oracle9iAS with SAP
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.sap.dbtech.jdbc.DriverSapDB"
url="jdbc:sapdb://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
/>
Copy the JDBC driver for SAP 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. |
|
| g. |
|
Orion with SAP
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="com.sap.dbtech.jdbc.DriverSapDB"
url="jdbc:sapdb://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
/>
Copy the JDBC driver for SAP 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. |
|
| h. |
|
Pramati with SAP
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:sapdb://localhost/lportal as the URL, com.sap.dbtech.jdbc.DriverSapDB as the driver, "test" as the user name, and "test" as the password. |
|
| i. |
|
RexIP with SAP
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="com.sap.dbtech.jdbc.DriverSapDB"
url="jdbc:sapdb://localhost/lportal"
username="test"
password="test"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for SAP 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. |
|
| j. |
|
Sun JSAS with SAP
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=com.sap.dbtech.jdbc.DriverSapDB, url=jdbc:sapdb://localhost/lportal, username=test, and password=test.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with SAP
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>
</ResourceParams>
</Context>
Copy the JDBC driver for SAP to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with SAP
Use the Administration Console to do the following:
Create a connection pool using jdbc:sapdb://localhost/lportal as the URL, com.sap.dbtech.jdbc.DriverSapDB as the driver, "test" as the user name, and "test" as the password.
Create a data source bound to jdbc/LiferayPool.
Create a Tx data source bound to jdbc/LiferayEJB. |
|
| m. |
|
WebSphere with SAP
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=com.sap.dbtech.jdbc.DriverSapDB, url=jdbc:sapdb://localhost/lportal, username=test, and password=test. | |
|
| IX. |
|
SQL Server |
|
| |
| a. |
|
Create a database in SQL Server called lportal. Use Enterprise Manager to load the script named portal-sql-server.sql. |
|
| b. |
|
JBoss with SQL Server
Create a data source bound to jdbc/LiferayPool by editing liferay-ds.xml.
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/LiferayPool</jndi-name>
<connection-url>
jdbc:jtds:sqlserver://localhost/lportal
</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name>test</user-name>
<password>test</password>
<min-pool-size>0</min-pool-size>
</local-tx-datasource>
</datasources>
Copy the JDBC driver for SQL Server to /server/default/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. |
|
| c. |
|
Jetty with SQL Server
Create a data source bound to jdbc/LiferayPool by editing /etc/jetty.xml.
<Call name="addService">
<Arg>
<New class="org.mortbay.jetty.plus.JotmService">
<Set name="Name">TransactionMgr</Set>
<Call name="addDataSource">
<Arg>jdbc/LiferayPool</Arg>
<Arg>
<New class="org.enhydra.jdbc.standard.StandardXADataSource">
<Set name="DriverName">net.sourceforge.jtds.jdbc.Driver</Set>
<Set name="Url">jdbc:jtds:sqlserver://localhost/lportal</Set>
<Set name="User">test</Set>
<Set name="Password">test</Set>
</New>
</Arg>
<Arg>
<New class="org.enhydra.jdbc.pool.StandardXAPoolDataSource">
<Arg type="Integer">4</Arg>
<Set name="MinSize">4</Set>
<Set name="MaxSize">15</Set>
</New>
</Arg>
</Call>
</New>
</Arg>
</Call>
Copy the JDBC driver for SQL Server to /lib. JDBC Drivers can be found from the database vendor's web site. |
|
| d. |
|
JOnAS with SQL Server
Create a data source bound to jdbc/LiferayPool by editing /conf/jonas/liferay-ds.properties.
datasource.name=jdbc/LiferayPool
datasource.url=jdbc:jtds:sqlserver://localhost/lportal
datasource.classname=net.sourceforge.jtds.jdbc.Driver
datasource.username=test
datasource.password=test
datasource.mapper=rdb.sybase
Copy the JDBC driver for SQL Server to /lib/ext. JDBC Drivers can be found from the database vendor's web site. |
|
| e. |
|
JRun with SQL Server
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:jtds:sqlserver://localhost/lportal as the URL, net.sourceforge.jtds.jdbc.Driver as the driver, "test" as the user name, and "test" as the password. |
|
| f. |
|
Oracle9iAS with SQL Server
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/ms-sql.xml"
/>
Copy the JDBC driver for SQL Server 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. |
|
| g. |
|
Orion with SQL Server
Create a data source bound to jdbc/LiferayPool, create a Tx data source bound to jdbc/LiferayEJB, and set the proper JDBC properties by editing /config/data-sources.xml.
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Liferay"
location="jdbc/LiferayCore"
pooled-location="jdbc/LiferayPool"
xa-location="jdbc/xa/LiferayXA"
ejb-location="jdbc/LiferayEJB"
connection-driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://localhost/lportal"
username="test"
password="test"
inactivity-timeout="30"
schema="database-schemas/ms-sql.xml"
/>
Copy the JDBC driver for SQL Server 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. |
|
| h. |
|
Pramati with SQL Server
Use the Management Console to do the following:
Create a data source bound to jdbc/LiferayPool using jdbc:jtds:sqlserver://localhost/lportal as the URL, net.sourceforge.jtds.jdbc.Driver as the driver, "test" as the user name, and "test" as the password. |
|
| i. |
|
RexIP with SQL Server
Create a data source bound to jdbc/LiferayPool and set the proper JDBC properties by editing /server.xml.
<datasource
name="LiferayPool"
jndi-name="jdbc/LiferayPool"
driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://localhost/lportal"
username="test"
password="test"
max-pool="100"
transactional="false"
/>
Copy the JDBC driver for SQL Server 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. |
|
| j. |
|
Sun JSAS with SQL Server
Use the Administration Console to do the following:
Create a connection pool org.apache.commons.dbcp.BasicDataSource as the data source class. The pool properties are driverClassName=net.sourceforge.jtds.jdbc.Driver, url=jdbc:jtds:sqlserver://localhost/lportal, username=test, and password=test.
Create a data source bound to jdbc/LiferayPool. |
|
| k. |
|
Tomcat with SQL Server
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>
</ResourceParams>
</Context>
Copy the JDBC driver for SQL Server to /common/lib. JDBC Drivers can be found from the database vendor's web site. |
|
| l. |
|
WebLogic with SQL Server
Use the Administration Console to do the following:
Create a connection pool using jdbc:jtds:sqlserver://localhost/lportal as the URL, net.sourceforge.jtds.jdbc.Driver as the driver, "test" as the user name, and "test" as the password.
Create a data source bound to jdbc/LiferayPool.
Create a Tx data source bound to jdbc/LiferayEJB. |
|
| m. |
|
WebSphere with SQL Server
Use the Administrative Console: Resources -> JDBC Providers.
Create a new user-defined JDBC provider. Remove any references in the class path. Set org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS as the implementation class name.
Copy commons-dbcp.jar, commons-pool.jar, and your JDBC driver to /AppServer/lib/ext.
Create a data source bound to jdbc/LiferayPool. The custom properties are driver=net.sourceforge.jtds.jdbc.Driver, url=jdbc:jtds:sqlserver://localhost/lportal, username=test, and password=test. | |
|