/**
  * @param out the place to write to
  * @param warning the SQLWarning
  */
 public static void ShowWarnings(PrintWriter out, SQLWarning warning) {
   while (warning != null) {
     String p1 = mapNull(warning.getSQLState(), LocalizedResource.getMessage("UT_NoSqlst_7"));
     String p2 = mapNull(warning.getMessage(), LocalizedResource.getMessage("UT_NoMessa_8"));
     out.println(LocalizedResource.getMessage("UT_Warni01", p1, p2));
     warning = warning.getNextWarning();
   }
 }
 public static void ShowWarnings(PrintStream out, SQLWarning warning) {
   while (warning != null) {
     out.println(
         "WARNING "
             + mapNull(warning.getSQLState(), "(no SQLState)")
             + ": "
             + mapNull(warning.getMessage(), "(no message)"));
     warning = warning.getNextWarning();
   }
 }
Ejemplo n.º 3
0
  // Format and print any warnings from the connection
  private static void checkForWarning(SQLWarning warn) throws SQLException {

    // If a SQLWarning object was given, display the
    // warning messages.  Note that there could be
    // multiple warnings chained together

    if (warn != null) {
      System.out.println("*** Warning ***\n");
      while (warn != null) {
        System.out.println("SQLState: " + warn.getSQLState());
        System.out.println("Message:  " + warn.getMessage());
        System.out.println("Vendor:   " + warn.getErrorCode());
        System.out.println("");
        warn = warn.getNextWarning();
      }
    }
  }
Ejemplo n.º 4
0
  public void connect() {

    try {
      // Load the database driver
      Class.forName("net.sourceforge.jtds.jdbc.Driver");
      // Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

      // Get a connection to the database
      String url = "jdbc:jtds:sqlserver://147.87.98.131:55783";
      conn = DriverManager.getConnection(url, "se2012_red", "Thanuc57ch");

      // Get a statement from the connection
      stmt = conn.createStatement();

      // Print all warnings
      for (SQLWarning warn = conn.getWarnings(); warn != null; warn = warn.getNextWarning()) {
        System.out.println("SQL Warning:");
        System.out.println("State  : " + warn.getSQLState());
        System.out.println("Message: " + warn.getMessage());
        System.out.println("Error  : " + warn.getErrorCode());
      }
    } catch (SQLException se) {
      System.out.println("SQL Exception:");

      // Loop through the SQL Exceptions
      while (se != null) {
        System.out.println("State  : " + se.getSQLState());
        System.out.println("Message: " + se.getMessage());
        System.out.println("Error  : " + se.getErrorCode());

        se = se.getNextException();
      }
    } catch (Exception e) {
      System.out.println(e);
    }
  }