Tomcat with SQL Server 2008
Introduction #
This page provides the configuration settings to set up Apache Tomcat 6 with SQL Server 2008.
Configurations for JDBC Connection #
Set portal-ext.properties #
Location:
webapps\ROOT\WEB-INF\classes\portal-ext.properties
Content in portal-ext.properties:# SQL Server
jdbc.default.jndi.name= jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver jdbc.default.url=jdbc:jtds:sqlserver://<machineName>/lportal jdbc.default.username=<user> jdbc.default.password=<password> }}}
Setting jdbc.properties #
Location:
webapps\wol-portlet\WEB-INF\jdbc.properties
Relevant Content in jdbc.properties://#jira.driverClassName=org.hsqldb.jdbcDriver#jira.url=jdbc:hsqldb:mem:jira#jira.username=sa#jira.password=jira.driverClassName=net.sourceforge.jtds.jdbc.Driverjira.url=jdbc:jtds:sqlserver://<machineName>/lportaljira.username=<user>jira.password=<password> }}}
Configurations for JNDI Connection #
Set portal-ext.properties #
Location:
webapps\ROOT\WEB-INF\classes\portal-ext.properties
Relevant Content in portal-ext.properties:
# SQL Server
jdbc.default.jndi.name=<jndiName> jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver jdbc.default.url=jdbc:jtds:sqlserver://<machineName>/lportal jdbc.default.username=<user> jdbc.default.password=<password> }}}
Set ext-spring.xml #
Location:
webapps\wol-portlet\WEB-INF\src\META-INF\ext-spring.xml
Relevant Content in ext-spring.xml://
<!--<bean id="jiraDataSourceTarget" class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="${jdbc.jira.driverClassName}" /><property name="url" value="${jdbc.jira.url}" /><property name="username" value="${jdbc.jira.username}" /><property name="password" value="${jdbc.jira.password}" /></bean>--><bean id="jiraDataSourceTarget" class="com.liferay.portal.spring.jndi.JndiObjectFactoryBean" lazy-init="true"><property name="jndiName"> <value>jdbc/<your jndiName></value></property> </bean> }}}
Configuration for both Connection Types#
jtds.jar #
In "bundles/common/lib/ext" make sure that the "jtds.jar" is present. If it is not there obtain it and put it there.
Database #
Check for the lportal database. If not such database is present then download "liferay-portal-sql-x.x.x.zip" and run the SQL script.
Troubleshooting #
- Make sure SQL Server has TCP connections enabled
- Try adding the port number to the jdbc.default.url
