Prev
Next
Forums Integration / Customization IPA/ProcessFlow

IPA SQLQRY Node

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
brainet
Basic Member
Posts: 18
Basic Member
10/8/2013 5:29 PM
    I am trying to set up a simple flow that reads an SQL table and send an email. I have set up my jdbc drive in the designer and have placed the sqljdbc4.jar file on my PC as well as in the /system/LPA/jar directory on the Landmark Process Server. When I run the flow I am still getting the error "

    "JDBC Driver sqljdbc4.jar not found in classpath. Please add jdbc driver to Lawson Process Server classpath."
    If anyone has been able to configure their system for this node, I would appreciate any help.

    Lynne
    Veteran Member
    Posts: 122
    Veteran Member
    10/9/2013 12:14 PM
      I am having the same problem. I found the following documentation but have not yet been able to get it configured here. I do see by reading this that our jar files are not configured. Maybe this will help you.

      Configuring JDBC .jar files for an instance of Infor Process Designer
      1 Verify that the appropriate .jar files are on the classpath.
      From the Designer toolbar, click Window / Preferences / Lawson Process Designer / External Jars.
      2 If the jars are listed in the Designer, click Cancel.
      You are ready to work with the JDBC-connecting activity nodes.
      3 If the .jars are not listed, they are not on the classpath. Click New and browse to the location where
      the .jars are located.
      If you cannot locate the .jars, contact your system administrator.
      4 Copy and paste (or type) the full path to the .jar file onto the External JARs space in the Designer
      and then click OK.
      When you are ready to upload and run a process that includes a JDBC-connecting node, the external
      .jar files specified here must also be listed on the classpath for the server. This configuration is
      performed by your system administrator.
      Dave Lis
      Advanced Member
      Posts: 24
      Advanced Member
      10/9/2013 1:11 PM
        What I did was I went into Process Server Administrator / System Configuration and created a new Configuration Name called: SQLServer. Then on the SQL Query node, for the Configuration name I used this connection called SQLServer. 

        Please see attachment for my settings.


        Hope this helps. 
        Attachments