This wiki does not contain official documentation and is currently deprecated and read only. Please try reading the documentation on the Liferay Developer Network, the new site dedicated to Liferay documentation. DISCOVER Build your web site, collaborate with your colleagues, manage your content, and more. DEVELOP Build applications that run inside Liferay, extend the features provided out of the box with Liferay's APIs. DISTRIBUTE Let the world know about your app by publishing it in Liferay's marketplace. PARTICIPATE Become a part of Liferay's community, meet other Liferay users, and get involved in the open source project. « Volver a 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
64304 Accesos
