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

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

    Databases 

    

    


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

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

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

    

    


    
I. 
  
DB2 
    

    
II. 
  
Firebird 
    

    
III. 
  
Hypersonic 
    

    
IV. 
  
InterBase 
    

    
V. 
  
MySQL 
    

    
VI. 
  
Oracle 
    

    
VII. 
  
PostgreSQL 
    

    
VIII. 
  
SAP 
    

    
IX. 
  
SQL Server 
    

    

    

    
I. 
  
DB2 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with DB2 

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

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

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

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

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

    

    

    
c. 
  
Jetty with DB2 

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

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

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

    

    

    
d. 
  
JOnAS with DB2 

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

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

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

    

    

    
e. 
  
JRun with DB2 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with DB2 

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

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

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

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

    

    

    
g. 
  
Orion with DB2 

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

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

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

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

    

    

    
h. 
  
Pramati with DB2 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with DB2 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with DB2 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with DB2 

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

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

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

    

    

    
l. 
  
WebLogic with DB2 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with DB2 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
II. 
  
Firebird 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with Firebird 

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

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

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

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

    

    

    
c. 
  
Jetty with Firebird 

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

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

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

    

    

    
d. 
  
JOnAS with Firebird 

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

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

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

    

    

    
e. 
  
JRun with Firebird 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with Firebird 

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

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

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

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

    

    

    
g. 
  
Orion with Firebird 

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

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

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

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

    

    

    
h. 
  
Pramati with Firebird 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with Firebird 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with Firebird 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with Firebird 

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

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

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

    

    

    
l. 
  
WebLogic with Firebird 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with Firebird 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
III. 
  
Hypersonic 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with Hypersonic 

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

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

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

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

    

    

    
c. 
  
Jetty with Hypersonic 

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

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

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

    

    

    
d. 
  
JOnAS with Hypersonic 

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

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

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

    

    

    
e. 
  
JRun with Hypersonic 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with Hypersonic 

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

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

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

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

    

    

    
g. 
  
Orion with Hypersonic 

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

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

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

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

    

    

    
h. 
  
Pramati with Hypersonic 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with Hypersonic 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with Hypersonic 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with Hypersonic 

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

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

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

    

    

    
l. 
  
WebLogic with Hypersonic 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with Hypersonic 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
IV. 
  
InterBase 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with InterBase 

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

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

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

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

    

    

    
c. 
  
Jetty with InterBase 

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

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

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

    

    

    
d. 
  
JOnAS with InterBase 

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

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

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

    

    

    
e. 
  
JRun with InterBase 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with InterBase 

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

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

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

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

    

    

    
g. 
  
Orion with InterBase 

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

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

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

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

    

    

    
h. 
  
Pramati with InterBase 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with InterBase 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with InterBase 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with InterBase 

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

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

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

    

    

    
l. 
  
WebLogic with InterBase 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with InterBase 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
V. 
  
MySQL 
    

    

    

    
  


    


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

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

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

    

    

    
b. 
  
JBoss with MySQL 

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

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

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

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

    

    

    
c. 
  
Jetty with MySQL 

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

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

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

    

    

    
d. 
  
JOnAS with MySQL 

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

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

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

    

    

    
e. 
  
JRun with MySQL 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with MySQL 

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

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

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

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

    

    

    
g. 
  
Orion with MySQL 

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

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

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

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

    

    

    
h. 
  
Pramati with MySQL 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with MySQL 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with MySQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with MySQL 

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

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

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

    

    

    
l. 
  
WebLogic with MySQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with MySQL 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
VI. 
  
Oracle 
    

    

    

    
  


    


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

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

    

    

    
b. 
  
JBoss with Oracle 

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

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

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

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

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

    

    

    
c. 
  
Jetty with Oracle 

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

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

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

    

    

    
d. 
  
JOnAS with Oracle 

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

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

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

    

    

    
e. 
  
JRun with Oracle 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with Oracle 

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

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

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

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

    

    

    
g. 
  
Orion with Oracle 

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

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

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

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

    

    

    
h. 
  
Pramati with Oracle 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with Oracle 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with Oracle 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with Oracle 

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

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

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

    

    

    
l. 
  
WebLogic with Oracle 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with Oracle 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
VII. 
  
PostgreSQL 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with PostgreSQL 

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

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

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

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

    

    

    
c. 
  
Jetty with PostgreSQL 

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

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

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

    

    

    
d. 
  
JOnAS with PostgreSQL 

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

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

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

    

    

    
e. 
  
JRun with PostgreSQL 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with PostgreSQL 

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

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

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

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

    

    

    
g. 
  
Orion with PostgreSQL 

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

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

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

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

    

    

    
h. 
  
Pramati with PostgreSQL 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with PostgreSQL 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with PostgreSQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with PostgreSQL 

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

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

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

    

    

    
l. 
  
WebLogic with PostgreSQL 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with PostgreSQL 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
VIII. 
  
SAP 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with SAP 

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

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

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

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

    

    

    
c. 
  
Jetty with SAP 

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

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

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

    

    

    
d. 
  
JOnAS with SAP 

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

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

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

    

    

    
e. 
  
JRun with SAP 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with SAP 

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

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

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

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

    

    

    
g. 
  
Orion with SAP 

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

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

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

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

    

    

    
h. 
  
Pramati with SAP 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with SAP 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with SAP 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with SAP 

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

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

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

    

    

    
l. 
  
WebLogic with SAP 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with SAP 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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

    

    

    
IX. 
  
SQL Server 
    

    

    

    
  


    


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

    

    

    
b. 
  
JBoss with SQL Server 

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

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

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

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

    

    

    
c. 
  
Jetty with SQL Server 

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

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

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

    

    

    
d. 
  
JOnAS with SQL Server 

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

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

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

    

    

    
e. 
  
JRun with SQL Server 

    Use the Management Console to do the following: 

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

    

    

    
f. 
  
Oracle9iAS with SQL Server 

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

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

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

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

    

    

    
g. 
  
Orion with SQL Server 

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

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

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

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

    

    

    
h. 
  
Pramati with SQL Server 

    Use the Management Console to do the following: 

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

    

    

    
i. 
  
RexIP with SQL Server 

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

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

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

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

    

    

    
j. 
  
Sun JSAS with SQL Server 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 
    

    

    

    
k. 
  
Tomcat with SQL Server 

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

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

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

    

    

    
l. 
  
WebLogic with SQL Server 

    Use the Administration Console to do the following: 

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

    Create a data source bound to jdbc/LiferayPool. 

    Create a Tx data source bound to jdbc/LiferayEJB. 
    

    

    

    
m. 
  
WebSphere with SQL Server 

    Use the Administrative Console: Resources -> JDBC Providers. 

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

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

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


    
	    
    




    








    

				
			
    
		    		
	
    
	
    
		
			

		
	
    

    


    







    
        
	



主站蜘蛛池模板：
亚洲人AV在线无码影院观看|
亚洲精品视频观看|
久久免费公开视频|
久久天天躁狠狠躁夜夜免费观看|
久久精品国产亚洲αv忘忧草|
中文字幕免费在线看电影大全|
午夜男人一级毛片免费|
久久亚洲国产伦理|
一级毛片**不卡免费播|
99热亚洲色精品国产88|
亚洲一区二区三区四区在线观看|
99热在线精品免费播放6|
亚洲嫩草影院久久精品|
成人人免费夜夜视频观看|
久久久久久影院久久久久免费精品国产小说|
亚洲国产精品无码久久久秋霞2|
老外毛片免费视频播放|
亚洲美女视频网址|
亚洲一区二区观看播放|
亚洲视频精品在线|
亚洲美女aⅴ久久久91|
亚洲丝袜美腿视频|
亚洲高清视频在线播放|
色婷五月综激情亚洲综合|
亚洲伊人色一综合网|
亚洲日韩国产二区无码|
亚洲精品V天堂中文字幕|
福利片免费一区二区三区|
亚洲精品无码MV在线观看|
亚洲一区二区三区四区在线观看|
亚洲综合激情另类小说区|
亚洲日韩国产二区无码|
成人国产精品免费视频|
中文字幕免费在线观看|
麻豆国产人免费人成免费视频|
国产成人高清精品免费鸭子|
国产亚洲精品无码专区
|
日产亚洲一区二区三区|
亚洲人成图片网站|
亚洲一区二区三区在线|
一本到卡二卡三卡免费高|