We have a scheduled agent that tries to connect to a MySql database using the mysql-connector-5.1.5.jar. The agent runs fine when it is run manually. When it is run from the server console, it throws the following error:
04/09/2009 01:01:36 PM AMgr: Agent (xxxxxxxx) error message: java.lang.NullPointerException
The code that it is throwing the error on is when it is trying to access the DriverManager:
DriverManager.registerDriver( (Driver) Class.forName(“com.mysql.jdbc.Driver”).newInstance() );
con = DriverManager.getConnection( “jdbc:mysql://xxxx/xxx”,“xxx”,“xxxx”);
The agent is set to Level 3 Security Access.
The jar file is located in the jvm\lib\ext directory and also inside of the project of the agent.
Is there other security settings that need to be changed inorder to run an agent to connect to MySql?