Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 360
	Members: 0
	Total: 360

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

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

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?

wintergreen

Veteran Member Send Private Message

Posts: 93

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

Posts: 3351

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.

Preston Burdwell

Advanced Member Send Private Message

Posts: 33

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.