<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        


    
	
    
		
			

    

    
	
    
		
			
    海鷗航際
    
			JAVA站
		    		
	
    

    

    

    

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


    		
	
    
	
    
		
			
		
		
			
    
				
					
	
    
		
		
    J2EE是個開放的世界，因此各個應用服務器有自己的配置文件格式。下面摘錄了Liferay Portal Enterprise 的連接字符串的說明文檔。 

    基本上針對各種數據庫有個完備的說明了，以后查閱不用到處去找了。 

    Databases 

    

    


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

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

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

    

    


    
I. 
  
DB2 
    

    
II. 
  
Firebird 
    

    
III. 
  
Hypersonic 
    

    
IV. 
  
InterBase 
    

    
V. 
  
MySQL 
    

    
VI. 
  
Oracle 
    

    
VII. 
  
PostgreSQL 
    

    
VIII. 
  
SAP 
    

    
IX. 
  
SQL Server 
    

    

    

    
I. 
  
DB2 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with DB2 

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

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

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

    Note: On startup, JBoss will throw a org.jboss.util.NestedSQLException with the message "Apparently wrong driver class specified for URL." That message comes up because we are using a wrapper for the DB2 driver. The Liferay driver will continue to work and the message can be ignored. 

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

    

    

    
c. 
  
Jetty with DB2 

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

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

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

    

    

    
d. 
  
JOnAS with DB2 

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

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

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

    

    

    
e. 
  
JRun with DB2 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with DB2 

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

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

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

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

    

    

    
g. 
  
Orion with DB2 

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

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

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

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

    

    

    
h. 
  
Pramati with DB2 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with DB2 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with DB2 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with DB2 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with DB2 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with DB2 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
II. 
  
Firebird 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with Firebird 

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

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

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

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

    

    

    
c. 
  
Jetty with Firebird 

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

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

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

    

    

    
d. 
  
JOnAS with Firebird 

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

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

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

    

    

    
e. 
  
JRun with Firebird 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with Firebird 

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

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

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

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

    

    

    
g. 
  
Orion with Firebird 

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

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

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

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

    

    

    
h. 
  
Pramati with Firebird 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with Firebird 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with Firebird 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with Firebird 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with Firebird 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with Firebird 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
III. 
  
Hypersonic 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with Hypersonic 

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

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

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

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

    

    

    
c. 
  
Jetty with Hypersonic 

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

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

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

    

    

    
d. 
  
JOnAS with Hypersonic 

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

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

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

    

    

    
e. 
  
JRun with Hypersonic 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with Hypersonic 

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

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

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

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

    

    

    
g. 
  
Orion with Hypersonic 

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

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

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

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

    

    

    
h. 
  
Pramati with Hypersonic 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with Hypersonic 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with Hypersonic 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with Hypersonic 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with Hypersonic 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with Hypersonic 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
IV. 
  
InterBase 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with InterBase 

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

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

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

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

    

    

    
c. 
  
Jetty with InterBase 

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

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

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

    

    

    
d. 
  
JOnAS with InterBase 

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

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

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

    

    

    
e. 
  
JRun with InterBase 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with InterBase 

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

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

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

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

    

    

    
g. 
  
Orion with InterBase 

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

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

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

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

    

    

    
h. 
  
Pramati with InterBase 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with InterBase 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with InterBase 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with InterBase 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with InterBase 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with InterBase 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
V. 
  
MySQL 
    

    

    

    
  


    


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

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

    To manually update your column type, execute the SQL command alter table TableName modify column columnName tinyint;. To automatically update all your tables, execute the SQL script update1.7.5-1.8.0-mysql.sql. 
    

    

    

    
b. 
  
JBoss with MySQL 

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

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

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

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

    

    

    
c. 
  
Jetty with MySQL 

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

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

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

    

    

    
d. 
  
JOnAS with MySQL 

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

    datasource.name=jdbc/LiferayPool 
    datasource.url=jdbc:mysql://localhost/lportal 
    datasource.classname=com.mysql.jdbc.Driver 
    datasource.username=test 
    datasource.password=test 
    datasource.mapper=rdb.mysql 

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

    

    

    
e. 
  
JRun with MySQL 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with MySQL 

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

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

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

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

    

    

    
g. 
  
Orion with MySQL 

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

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

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

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

    

    

    
h. 
  
Pramati with MySQL 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with MySQL 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with MySQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with MySQL 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with MySQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with MySQL 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
VI. 
  
Oracle 
    

    

    

    
  


    


    
a. 
  
Create a database in Oracle called lportal. Go to SQL Plus and type @/portal-ejb/src/portal-oracle.sql;. 

    Note: There is a bug with with the Oracle JDBC driver which will not allow O/R tools to access columns over 4 kb. This affects some of the functionality of the portal. A workaround is to use the Liferay JDBC driver that acts as a wrapper to ensure that columns over 4 kb read and persist properly. The Liferay JDBC driver determines which actual driver to load based on the connection URL. If you pass in a URL that contains the string jdbc:oracle:thin, it will know to load oracle.jdbc.driver.OracleDriver. 
    

    

    

    
b. 
  
JBoss with Oracle 

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

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

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

    Note: On startup, JBoss will throw a org.jboss.util.NestedSQLException with the message "Apparently wrong driver class specified for URL." That message comes up because we are using a wrapper for the Oracle driver. The Liferay driver will continue to work and the message can be ignored. 

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

    

    

    
c. 
  
Jetty with Oracle 

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

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

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

    

    

    
d. 
  
JOnAS with Oracle 

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

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

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

    

    

    
e. 
  
JRun with Oracle 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with Oracle 

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

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

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

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

    

    

    
g. 
  
Orion with Oracle 

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

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

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

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

    

    

    
h. 
  
Pramati with Oracle 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with Oracle 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with Oracle 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with Oracle 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with Oracle 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with Oracle 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
VII. 
  
PostgreSQL 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with PostgreSQL 

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

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

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

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

    

    

    
c. 
  
Jetty with PostgreSQL 

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

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

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

    

    

    
d. 
  
JOnAS with PostgreSQL 

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

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

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

    

    

    
e. 
  
JRun with PostgreSQL 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with PostgreSQL 

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

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

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

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

    

    

    
g. 
  
Orion with PostgreSQL 

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

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

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

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

    

    

    
h. 
  
Pramati with PostgreSQL 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with PostgreSQL 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with PostgreSQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with PostgreSQL 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with PostgreSQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with PostgreSQL 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
VIII. 
  
SAP 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with SAP 

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

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

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

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

    

    

    
c. 
  
Jetty with SAP 

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

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

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

    

    

    
d. 
  
JOnAS with SAP 

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

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

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

    

    

    
e. 
  
JRun with SAP 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with SAP 

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

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

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

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

    

    

    
g. 
  
Orion with SAP 

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

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

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

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

    

    

    
h. 
  
Pramati with SAP 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with SAP 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with SAP 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with SAP 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

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

    

    

    
l. 
  
WebLogic with SAP 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with SAP 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
IX. 
  
SQL Server 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with SQL Server 

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

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

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

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

    

    

    
c. 
  
Jetty with SQL Server 

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

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

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

    

    

    
d. 
  
JOnAS with SQL Server 

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

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

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

    

    

    
e. 
  
JRun with SQL Server 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with SQL Server 

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

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

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

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

    

    

    
g. 
  
Orion with SQL Server 

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

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

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

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

    

    

    
h. 
  
Pramati with SQL Server 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with SQL Server 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with SQL Server 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with SQL Server 

    Create a data source bound to jdbc/LiferayPool by editing /conf/Catalina/localhost/liferay.xml. 

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

    Copy the JDBC driver for SQL Server to /common/lib. JDBC Drivers can be found from the database vendor's web site. 
    

    

    

    
l. 
  
WebLogic with SQL Server 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with SQL Server 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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


    
	    
    




    








    

				
			
    
		    		
	
    
	
    
		
			

		
	
    

    


    







    
        
	



主站蜘蛛池模板：
成人黄软件网18免费下载成人黄18免费视频
|
美女羞羞视频免费网站|
亚洲成人激情小说|
亚洲一级片在线播放|
亚洲狠狠ady亚洲精品大秀|
亚洲精彩视频在线观看|
亚洲国产精品久久丫|
亚洲理论片中文字幕电影|
亚洲天堂一区二区三区四区|
亚洲美女视频网站|
亚洲大尺码专区影院|
亚洲一卡2卡3卡4卡国产网站|
亚洲一级毛片免费在线观看|
亚洲人成电影青青在线播放|
亚洲AV无码久久久久网站蜜桃|
最新国产成人亚洲精品影院|
亚洲欧洲免费无码|
无套内谢孕妇毛片免费看看|
有色视频在线观看免费高清在线直播|
一日本道a高清免费播放|
久久精品无码免费不卡|
免费A级毛片无码A∨|
青青在线久青草免费观看|
午夜高清免费在线观看|
一区国严二区亚洲三区|
亚洲午夜日韩高清一区|
亚洲av日韩av无码|
亚洲av一本岛在线播放|
色窝窝亚洲av网|
中文字幕不卡免费视频|
99热这里只有精品6免费|
黄瓜视频影院在线观看免费|
四虎影视永久免费视频观看|
在线亚洲精品福利网址导航|
亚洲大片在线观看|
亚洲日韩亚洲另类激情文学|
一级毛片在线播放免费|
51在线视频免费观看视频|
全免费a级毛片免费**视频|
在线亚洲午夜理论AV大片|
久久亚洲精品成人AV|