crontab problem

[kaancho12]

I have a problem with setting the classpath for the crontab.
I needed to download and install the java-mysql driver for tron so that I could test a Java program that interacted with mysql database. When I run the program manually it works correctly but when I run the program in crontab it seems to have problem, it doesnt find the driver ..is there a fix for that.
This is the error I get :
SQLException: No suitable driver
SQLState: 08001
VendorError: 0

 

[BIS]

environment, environment, environment...
Try to include your entire env in your script. I'll bet it will work.
For example, try to

# env > env.txt

as the user for whom the script works.

Then copy the contents of env.txt and insert that at the top of your script.