Configure JDBC connection with Microsoft SQL Server (Integration Server 10.7)

Connection  to MSSQL database is not out of box feature .To apply it first you need to download the JDBC Driver jar from Microsoft site  then you need add it under lib folder and restart the server . 

Lib Path is : C:\yourSAGHome\IntegrationServer\instances\default\lib\jars

After the restart the server will be able to load the new jar and make it available for future use .

Steps in Details

1- Download - JDBC Driver for SQL Server

2-Unzip the file then copy file mssql-jdbc-11.2.3.jre8 to the following paths (in each integration server node) .

        C:\yourSAGHome\IntegrationServer\lib C:\yourSAGHome\IntegrationServer\instances\default\lib\jars

3-Restart the server 4-login to the server and go to Adapters –> webMethods Adapter for JDBC --> 5- click Configure New Connection link then choose webMethods Adapter for JDBC Connection

6-fill configuration details :   

               

                                            
7-Click test connection and enable connect

Enjoy Your SQL Connection !

Fix issue : Unable to locate or start compiler in webmethod integration server 10.7

In some cases when we try to compile java service using save the following error are showing up :

The source was saved, but was not compiled due to the following errors:

com.wm.app.b2b.server.ServiceException: [ISS.0014.9116] Unable to locate or start compiler

 Resolution : 

  Remove the command watt.server.compile=C:\sag107\jvm\jvm\bin\javac -classpath {0} -d {1} {2} from extended settings to enforce use default compiler



  Reference :

watt.server.compile
Specifies the compiler command that Integration Server uses to compile Java services that are developed using
Designer

, For example, javac -classpath {0} -d {1} {2}This compiler command is also used from the jcode utility. If this property is omitted or empty, the server uses the JVM internal Java compile tool to compile Java services.