Thread: Trying to connect to a sample Java DB database

Please help!
I am following a learning Java book and trying to access the sample Java DB database with NetBeans but getting this error below. Thanks!

run:
Error: Could not find or load main class systablereporter.SysTableReporter
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)

Here is the code:

import java.sql.*;
 
public class SysTableReporter {
    public static void main(String[] arguments) {
       String data = "jdbc:derby://localhost:1527/sample";
       try (
           Connection conn = DriverManager.getConnection(
               data, "app", "APP");
           Statement st = conn.createStatement()) {
 
           Class.forName("org.apache.derby.jdbc.ClientDriver");
 
            ResultSet rec = st.executeQuery(
                "select * " +
                "from SYS.SYSTABLES " +
                "order by TABLENAME");
            while(rec.next()) {
                System.out.println("TABLEID:\t" + rec.getString(1));
                System.out.println("TABLENAME:\t" + rec.getString(2));
                System.out.println("TABLETYPE:\t" + rec.getString(3));
                System.out.println("SCHEMAID:\t" + rec.getString(4));
                System.out.println();
            }
            st.close();
        } catch (SQLException s) {
            System.out.println("SQL Error: " + s.toString() + " "
                + s.getErrorCode() + " " + s.getSQLState());
        } catch (Exception e) {
            System.out.println("Error: " + e.toString()
                + e.getMessage());
        }
    }
}

Error: Could not find or load main class systablereporter.SysTableReporter

It seems your IDE is looking for the class SysTableReporter in the systablereporter package - the class you posted is not defined to be a part of an 'systablereporter' package.