
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.Driver jira.url=jdbc:jtds:sqlserver://<machineName>/lportal jira.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>
Note: For JNDI configuration you need just one line, the jndi name. The rest is configured through your application server - no need for db-name, driver, username and password in portal-ext.properties
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