海鷗航際
          
			JAVA站
		          		
	
          

          

          

          

          posts - 11, comments - 53, trackbacks - 1, articles - 102
          


          		
	
          
	
          
		
			
		
		
			
          
				
					
	
          
		
		
          J2EE是個(gè)開(kāi)放的世界，因此各個(gè)應(yīng)用服務(wù)器有自己的配置文件格式。下面摘錄了Liferay Portal Enterprise 的連接字符串的說(shuō)明文檔。 

          基本上針對(duì)各種數(shù)據(jù)庫(kù)有個(gè)完備的說(shuō)明了，以后查閱不用到處去找了。 

          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. 
          
	
          


          
	    
    




          








          

				
			
          
		          		
	
          
	
          
		
			

		
	
          

          


    







          
        
	




主站蜘蛛池模板：
晋州市|
额济纳旗|
郎溪县|
洛南县|
星子县|
涪陵区|
南涧|
北京市|
拜城县|
益阳市|
布拖县|
龙川县|
原阳县|
富锦市|
家居|
山阳县|
龙泉市|
松原市|
贵州省|
松江区|
盐亭县|
江都市|
江达县|
海城市|
乌鲁木齐县|
贡觉县|
潮安县|
彰武县|
鄄城县|
罗甸县|
八宿县|
会宁县|
黎川县|
宜黄县|
淮滨县|
江山市|
宜春市|
博爱县|
繁昌县|
新民市|
彭水|