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


    
	    
    




    








    

				
			
    
		    		
	
    
	
    
		
			

		
	
    

    


    







    
        
	



主站蜘蛛池模板：
亚洲第一黄片大全|
性色av极品无码专区亚洲|
免费在线观看你懂的|
国产高清免费视频|
三级黄色免费观看|
国产精品亚洲天堂|
亚洲AV无码乱码在线观看代蜜桃
|
亚洲色av性色在线观无码|
亚洲精品无码久久久|
在线观看免费为成年视频|
2021国内精品久久久久精免费|
国产男女爽爽爽免费视频|
久久水蜜桃亚洲AV无码精品|
亚洲同性男gay网站在线观看|
久久精品国产69国产精品亚洲|
亚洲高清无码专区视频|
日本a级片免费看|
野花高清在线电影观看免费视频
|
激情内射亚洲一区二区三区|
亚洲国产精品无码专区|
久久久久国产成人精品亚洲午夜|
国产在线a不卡免费视频|
午夜免费福利在线观看|
毛片免费视频播放|
黄页网站免费观看|
黄色片在线免费观看|
在线v片免费观看视频|
久草视频在线免费|
免费观看的毛片大全|
日本成年免费网站|
九九精品免费视频|
成年女人18级毛片毛片免费|
日本精品人妻无码免费大全|
免费人成在线视频|
免费a级毛片无码a∨蜜芽试看|
成全影视免费观看大全二|
午夜电影免费观看|
国产区卡一卡二卡三乱码免费
|
亚洲a∨国产av综合av下载|
久久亚洲精品无码网站|
特级毛片全部免费播放|