By Sean | September 3, 2017
i-lign 8.2 introduces the Microsoft JDBC connection driver to replace the venerable JTDS JDBC connector.
For in-house customers, the only change required is to the context.xml file. A template file will be available with the new version download. Below is an example of the new database connection string.
<Resource name="jdbc/ilign"
auth="Container"
type="javax.sql.DataSource"
factory="com.zaxxer.hikari.HikariJNDIFactory"
dataSource.user="ilign-v82"
dataSource.password="xxxxxxxxxxxx"
dataSourceClassName="com.microsoft.sqlserver.jdbc.SQLServerDataSource"
dataSource.url="jdbc:sqlserver://<DATABASE-SERVER>:<database-port>;databaseName=ilign-v82" />
And a current example for comparison
<Resource name="jdbc/ilign"
auth="Container"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
factory="org.apache.naming.factory.BeanFactory"
user="ilign-oldversion"
password="xxxxxxxxxxxx"
driverClass="net.sourceforge.jtds.jdbc.Driver"
jdbcUrl="jdbc:jtds:sqlserver://<DATABASE-SERVER>:<DATABASE-PORT>/ilign-oldversion" />