Java error (No suitable drivers found)

advertisements
public class ReportView extends JFrame {

  Connection con=null;

  void showReport() throws SQLException, ClassNotFoundException, JRException {

    con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/Test");
    JasperReport report=JasperCompileManager.compileReport("Testing.jrxml");
    JasperPrint print=JasperFillManager.fillReport(report,null,con);
    JRViewer viewer=new JRViewer(print);
    viewer.setOpaque(true);
    viewer.setVisible(true);
    this.add(viewer);
    this.setSize(300, 200);
    this.setVisible(true);
    this.setDefaultCloseOperation(EXIT_ON_CLOSE);
}

This is error:

Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/Test
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)

What is the wrong?


  1. You'll need to load the driver somewhere. Class.forName("org.postgresql.Driver");
  2. You'll need the postgresql driver .jar file in the classpath of your program.