
« Zurück zu Configuring
Sybase Configuration
Table of Contents [-]
After installing Sybase, here are the steps to configuring the database for Liferay.
- Turn on Sybase service
- Login to database ( Sybase Central ) username="sa" password=""
- Select server name
- Open up databases folder
- Right click on "master" database -> properties
Within the "master" database tab click devices
- Highlight the "master" database, and hit the properties button
- Under "Space allocated" increase the size of you database -> hit apply and then OK
- In the "master" database properties hit edit, and increase the "Total space allocation" to 100MB
- Hit "OK" in the "master" database properties
- Click the icon to add a database
- Enter in the database name "lportal"
- Hit next
- Add the "master" database's log and data
- Hit edit on log and increase the log size -> hit ok
- Hit edit on data and increase the log size -> hit ok
- Hit next until the database is added.
Note: may need to select "override" to create the database
- Right click on "lportal" database -> properties
- Select options tab and click on "allow nulls by default" and "select into/bulkcopy/pllsort" -> hit ok
In the command prompt type in the following to run the database create script
isql -Usa -P -Dlportal -i D:\Projects\liferay\portal\trunk\sql\portal\portal-sybase.sql
In your root.xml for tomcat, you'll want to change your database connection to use you Sybase database.
<Resource name="jdbc/LiferayPool" auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:sybase:Tds:IP_Address_Of_Database:5000/lportal" username="USER" password="PASSWORD" maxActive="100" maxIdle="30" maxWait="10000" />
- In your ext environment, set the following properties to use Sybase.
In portal.properties or portal-ext.properties set:
For 4.1.2 add:
hibernate.dialect=org.hibernate.dialect.SybaseDialect custom.sql.function.isnull=ISNULL
For 4.2.1 add:
hibernate.dialect=org.hibernate.dialect.Sybase11Dialect hibernate.jdbc.batch_size=0 custom.sql.function.isnull=ISNULL(CONVERT(VARCHAR,?), '1') = '1' custom.sql.function.isnotnull=ISNULL(CONVERT(VARCHAR,?), '1') = '0'
For 5.1
jdbc.default.jndi.name= jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver jdbc.default.url=jdbc:jtds:sybase://[ip address]:5000/lportal jdbc.default.username=sa jdbc.default.password= hibernate.dialect=org.hibernate.dialect.SybaseDialect custom.sql.function.isnull=ISNULL
For 5.2
jdbc.default.jndi.name= jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver jdbc.default.url=jdbc:jtds:sybase://[ip address]:5000/lportal jdbc.default.username=sa jdbc.default.password=
- Copy your sybase drives to Tomcat.
Example: Copy lib/development/jtds.jar to <TOMCAT_HOME>/common/lib/jtds.jar You may need to copy one or more jars into the <TOMCAT_HOME>/common/lib folder - jtds.jar, jconn3.jar , jconn2.jar
63898 Angesehen