JDBC Driver Setup for PFI on Unix Server/Oracle Database

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Preston Burdwell
Advanced Member Send Private Message
Posts: 33
Advanced Member

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 Send Private Message
Posts: 93
Veteran Member
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
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 33
Advanced Member
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