vurjo.blogg.se - Maven microsoft sql server jdbc driver

An instance of an SQL Server 2017 database.įor the installation and updating of Blade CLI you could refer to this official Liferay documentation: Installing Blade CLI and Updating Blade CLI.

Installation or upgrade to the latest version of Blade.

What are the requirementsīefore proceeding with the construction of the Docker image, the following requirements must be met. The source code of the Liferay Workspace it’s available on this GitHub repository liferay-72-sqlserver-docker-images. The Liferay Digital Experience Platform 7.2 Compatibility Matrix indicated SQL Server 2017 among the certified databases. In this article we will see how to achieve the same goal (from the previous article) but adding support for Microsoft SQL Server 2017. In the recently published article How to build Docker Liferay 7.2 image with the Oracle Database support, I explained how to create the Liferay 7.2 Docker image by adding support to the Oracle database and in particular I explained how to do it using Blade CLI and Liferay Workspace. Puoi cliccare sul link per cambiare la lingua attiva. Per ragioni di convenienza del visitatore, il contenuto è mostrato sotto nella lingua alternativa. Specify the JDBC_URL in the application filter.Ci spiace, ma questo articolo è disponibile soltanto in Inglese Americano. Jdbc:sqlserver://server:port DatabaseName=dbname Specify the JDBC_URL in the Data Source application filter. Specify the location of the mssql-jdbc-6.4.0.jre8.jar in the EPM Integration Agent by setting the CUSTOM_CLASS_PATH parameter in the agentparams.ini file.įor example, specify: CUSTOM_CLASS_PATH=C:\EPMAgent\lib\mssql-jdbc-6.4.0.jre8.jarįor more information about setting parameters in the agentparams.ini file, see Configuring the EPM Integration Agent Startup Parameters. The driver must be a JRE8 compatible driver.Ĭopy the jar file mssql-jdbc-6.4.0.jre8.jar to the EPM_AGENT_HOME/lib directory.įor example, copy the jar file to the C:\EPMAgent\lib directory.

To configure the Microsoft JDBC Driver for SQL Server:ĭownload the SQL server jar from the following website and unzip it: Download Microsoft JDBC Driver for SQL Server If you plan to use the Microsoft Java Database Connectivity (JDBC) driver to connect to the SQL Server in the EPM Integration Agent, this section describes how to download and configure the driver.