import java.sql.*;

class FilemakerJDBCTest {
	public static void main(String[ ] args) {

		// EDIT FOR YOUR SYSTEM
		// --------------------------------------
		String fmsHostname = "192.168.1.1";
		String fmFilename = "FMServer_Sample";
		String fmUser = "Admin";
		String fmPassword = "";
		// -------------------------------------
		// END OF EDITABLE SECTION

		// register the JDBC client driver
		try {
			Driver d = (Driver)Class.forName("com.filemaker.jdbc.Driver").newInstance();
		} catch(Exception e) {
			System.out.println(e);
		}
		
		// establish a connection to FileMaker
		Connection con = null;
		
		try {
			con = DriverManager.getConnection("jdbc:filemaker://" + fmsHostname + "/" + fmFilename, fmUser, fmPassword);
		} catch(Exception e) {
			System.out.println(e);
		}
			
		// get connection warnings
		SQLWarning warning = null;
		
		try {
			warning = con.getWarnings();
			if (warning == null) {
				System.out.println("No warnings");
				return;
			}
			while (warning != null) {
				System.out.println("Warning: "+warning);
				warning = warning.getNextWarning();
			}
		} catch (Exception e) {
			System.out.println(e);
		}
	}
}

