Liferay Information for Common Databases

The following article contains relevant information for connecting Liferay to some of the more common databases.

Resolution

  MySQL Oracle
Commands http://dev.mysql.com/doc/refman/5.5/en/index.html http://www.oracle.com/pls/db112/homepage
Query Language SQL SQL
Portal-ext jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lr6120?useUnicode?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=lruser
jdbc.default.password=liferay
jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@172.16.16.203:1521:orcl
jdbc.default.username=liferay
jdbc.default.password=liferay
Known Issues http://dev.mysql.com/doc/refman/5.5/en/bugs.html http://docs.oracle.com/cd/E29407_01/relnotes.111200/e23738/known_issues.htm
Default Encoding Latin1 (UTF-8 can be selected as default when configuring server) AL32UTF8
Documentation http://dev.mysql.com/doc/refman/5.5/en/index.html http://www.oracle.com/pls/db112/homepage
How to Export A Dump mysqldump -u (username) -p(password) (database name) > (dump file name).sql expdp system/password dumpfile=(filename).dmp logfile=log1.log schemas=(schema name)
How to Import A Dump mysqldump -u (username) -p(password) (database name) < (dump file name).sql

impdp system/password dumpfile=(filename).dmp logfile=log1.log full=y

Required .jar files http://dev.mysql.com/downloads/connector/j/3.1.html
mysql.jar
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
ojdbc6.jar
     
  DB2 PostgresSQL
Commands http://www-01.ibm.com/support/docview.wss?uid=swg27009474 http://www.postgresql.org/docs/manuals/
Query Language SQL SQL
Portal-ext

jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver
jdbc.default.url=jdbc:db2://localhost:50000/lportal:deferPrepares=false;

fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;

progresssiveLocators=2;progressiveStreaming=2;
jdbc.default.username=db2admin
jdbc.default.password=lportal
custom.sql.function.isnull=CAST(? AS VARCHAR(32672)) IS NULL
custom.sql.function.isnotnull=CAST(? AS VARCHAR(32672)) IS NOT NULL

jdbc.default.driverClassName=org.postgresql.Driver
jdbc.default.url=jdbc:postgresql://localhost:5432/lportal
jdbc.default.username=sa
jdbc.default.password=
Known Issues http://www-01.ibm.com/support/docview.wss?uid=swg21165448 https://wiki.postgresql.org/wiki/Todo
Default Encoding UTF-8 UTF-8
Documentation http://www-01.ibm.com/support/docview.wss?uid=swg27009474 http://www.postgresql.org/docs/manuals/
How to Export A Dump db2move (DB name) export psql databasename > data_base_dump
How to Import A Dump db2move (DB name) import psql databasename < data_base_dump
Required .jar files http://www-01.ibm.com/support/docview.wss?uid=swg21363866
db2jcc.jar, db2jcc_license_cu.jar
http://jdbc.postgresql.org/
postgresql-9.2-1003.jdbc4.jar
  SQL Server Sybase
Commands http://msdn.microsoft.com/en-us/sqlserver http://help.sap.com/database
Query Language SQL SQL
Portal-ext

jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.default.url=jdbc:jtds:sqlserver://localhost/lportal
jdbc.default.username=sa
jdbc.default.password=password

jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.default.url=jdbc:jtds:sybase://localhost:5000/lportal
jdbc.default.username=sa
jdbc.default.password=password
custom.sql.function.isnull=CONVERT(VARCHAR,?) IS NULL
custom.sql.function.isnotnull=CONVERT(VARCHAR,?) IS NOT NULL

hibernate.dialect=org.hibernate.dialect.SybaseDialect
#Only for Sybase 15.7:
#hibernate.dialect=com.liferay.portal.dao.orm.hibernate.SybaseASE157Dialect

Known Issues https://connect.microsoft.com/SQLServer/Feedback -
Default Encoding - Unicode 3.1 UTF-8 Character Set
Documentation http://msdn.microsoft.com/en-us/sqlserver http://infocenter.sybase.com/help/index.jsp
How to Export A Dump http://msdn.microsoft.com/en-us/library/ms175937.aspx http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36272.1572/html/commands/X68345.htm
How to Import A Dump http://msdn.microsoft.com/en-us/library/ms175937.aspx http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36272.1572/html/commands/X28090.htm
Required .jar files http://jtds.sourceforge.net/ http://jtds.sourceforge.net/
Was this article helpful?
0 out of 0 found this helpful