Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Process Flow Integrator JDBC SSL issue

 1 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Wayne Popp
New Member
Posts: 1
New Member
9/6/2013 12:44 PM
    We are having an issue connecting to a SQL Server 2008 Database that now requires connecting via an SSL connection.  We are using the SQL Server Query node and in the past we connected fine using the sqljdbc4.jar file to our SQL Server 2008 databases but now when they turn on "Force Encryption" on the SQL server we get the error "SQLException: Connection reset".  We did add the URL parameter "trustServerCertificate=true" and the flow runs ok locally but we get this error when it runs on the Server.   Does anyone have any experience in setting up the process flows using an SSL JDBC connection?  thanks, wrp.
    Rob Conrad
    Veteran Member
    Posts: 73
    Veteran Member
    9/6/2013 7:29 PM
      Wayne -

      You likely need to setup the Lawson Process Flow server to use SSL. This can be done in the 'pfserv config' and you must also install the certificates on the server etc. The fact that it works ok locally, but throws an error on the server points to this as a fix.

      RC