• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

JDBC with Process Flow Integrator 9.01

 1 Replies
 0 Subscribed to this topic
 51 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
New Poster
New Poster
Congrats on posting!
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.