java.sql.SQLException: No suitable driver

  • 3746245
  • 29-Feb-2008
  • 26-Apr-2012

Environment

Novell Audit 2.0.2

Situation

When trying to run a query in iManager for the Novell Audit transactions, the followint error is received: java.sql.SQLException: No suitable driver

Resolution

The JDBC URL listed in the Database Definition (under Auditing and logging | Query Options in iManager) is incorrect
For mysql it should be "jdbc:mysql://151.155.132.224:3306/naudit"
Also make sure you have the correct mysql jar for iManager to use while querying. See KB 10091351 - Unable to query the MySQL Nsure Audit database from iManager