Prev
Next
Forums Integration / Customization IPA/ProcessFlow

JDBC with Process Flow Integrator 9.01

 1 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Sara
New Member
Posts: 1
New Member
7/29/2014 8:24 PM
    We are trying to connect to a non-Lawson sql 2008 database using process flow.  I need to be able to query and write to this database.  I unable to get either the sql query or update node to connect.  I keep getting the error "unable to load JDBC database driver class.  JDBC settings and driver jars need to be defined in Windows, Preferences, ProcessFlow."

    I put a copy of sqljdbc4.jar into the Process Flow lib directory, and put a link to it under external jars in the preferences.  It still won't recognize it.

    Is there something else I need to do to get this to work?
    Tags: processflow jdbc
    David Britton
    Veteran Member
    Posts: 53
    Veteran Member
    8/15/2014 2:04 PM
      Sara

      Don't know if you still need information on this, but I will describe my setup.

      First, are you encountering this error when you "run locally" or as "run on server"? Are you running Lawson on Windows or Unix?

      I am on Windows XP for the Designer and our production server for Lawson/Process Flow is Sun Solaris (Unix).

      Looking at the configuration on my PC I have the location of my jdbc jar files defined in PFCLASSPATH which I set up through Environment Variables for MyComputer. Similar structure exists for Windows 7.

      On my PC I do not have anything set up under Process Flow Designer: Windows-Preferences-ProcessFlow->External Jars or Windows-Preferences-ProcessFlow->JDBC

      On a few flows I do have Override JDBC checked for the SQL Query node and a full definition of the JDBC driver, Database URL, User and Password fields.

      I have the jdbc jar files on the Unix server under $GENDIR/bpm.
      Tags: processflow jdbc