Prev
Next
Forums IPA/ProcessFlow

JDBC Driver Setup for PFI on Unix Server/Oracle Database

Sort:
You are not authorized to post a reply.
Author
Messages
Preston Burdwell
Advanced Member
Posts: 33
Advanced Member
10/22/2009 7:09 PM

    Hello everyone, I was wondering if anyone can help with a JDBC driver setup for ProcessFlow Integrator on a Unix Server, Oracle Database. I have the ProcessFlow Designer working when run locally, (thanks to suggestions from this forum!), but I have yet to successfully run the same flow on the server. I have placed the ojdbc14.jar file within the $GENDIR/bpm/jars directory, as suggested by Lawson Documentation, and restarted ProcessFlow servers. I still receive the following errors:
    SQLException: JDBC Driver not found: oracle.jdbc.driver.OracleDriver
    Please add jdbc driver to ProcessFlow Server classpath.
    Any suggestions?

    Preston Burdwell Systems Analyst CHRISTUS St. Vincent Med CTR
    wintergreen
    Veteran Member
    Posts: 93
    Veteran Member
    10/26/2009 2:20 PM
      Hello, I don't know if this will help ... I'm using windows server. Have you checked your bpm properties file? Can you run pfserv config command in UNIX? Stop and restart the pfserv?
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
      10/26/2009 2:35 PM
        In addition to running the pfserv config, you might also want to echo the $CLASSPATH and see if the jdbc14.jar is in there...if not, try adding it to your lawson.env and stopping/restarting the environment.
        Thanks for using the LawsonGuru.com forums!
        John
        Preston Burdwell
        Advanced Member
        Posts: 33
        Advanced Member
        10/27/2009 6:14 PM
          Thanks for your suggestions. I tried adding $CLASSPATH to the environment and putting the driver in the path but PFI did not recognize it still. I opened a case with Lawson and here is what they said:

          There is a typo in the documentation. The actual location where the JDBC dr
          iver needs to go is $GENDIR/bpm/jar (not jars). Please create this direct
          ory (it likely doesn't exist by default), copy everything over, and then re
          move the incorrect directory. You will need to restart bpm (pfserv stop bp
          m, pfserv start bpm) after making this change, but you will not need to res
          tart any of the other PF servers.

          Once I put the odbc14.jar file in the above directory, everything worked fine! I did have to use the classes111.zip for Designer to work on my local machine. But the above fix worked for the Unix Server. Thanks again for your help.
          Preston Burdwell Systems Analyst CHRISTUS St. Vincent Med CTR
          You are not authorized to post a reply.