Hello all:
Last July I requested help to implement a java method that reads from a SQL database in Content Server 6.7 SP1 with JBoss 5.1. I was able to make this work by adding the driver .jar file, sqljdbc4.jar, to the \jboss5.1.0\server\DctmServer_MethodServer\lib folder. Here is the thread:
https://community.emc.com/thread/147342
We are now upgrading to CS 7.1, and I am trying to deploy the same java method to the new environment. However, in JBoss 7.1.1, there is no similar directory. I have recreated the method as a BOF as suggested by Jorg, and included the .jar file in it, but the method server still cannot find the driver. It actually throws an error indicating it's trying to connect using SSL (we do not use SSL).
09:43:52,949 INFO [stdout] (http--0.0.0.0-9080-1) In JDBCProcessing.getJDBCConnectioncom.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Connection reset ClientConnectionId:d380162f-8c24-464e-afb4-ed29c076b6fc".
In searching around, I've found some instructions on how to implement a SQL driver on JBoss 7.1, but have not been able to make it work.
Has anyone done this, or do you have suggestions? This job just has to go out to a database table and read a list of parameters. It's not rocket science.
Thanks.
- Jane
