Examples of SQLWarning

java.sql.SQLWarning

An exception that provides information on database access warnings. Warnings are silently chained to the object whose method caused it to be reported.
Warnings may be retrieved from Connection, Statement, and ResultSet objects. Trying to retrieve a warning on a connection after it has been closed will cause an exception to be thrown. Similarly, trying to retrieve a warning on a statement after it has been closed or on a result set after it has been closed will cause an exception to be thrown. Note that closing a statement also closes a result set that it might have produced. @see Connection#getWarnings @see Statement#getWarnings @see ResultSet#getWarnings
org.apache.derby.client.am.SqlWarning
This represents a warning versus a full exception. As with SqlException, this is an internal representation of java.sql.SQLWarning. Public JDBC methods need to convert an internal SqlWarning to a SQLWarning using getSQLWarning()

Examples of java.sql.SQLWarning

        Assert.assertTrue(formatterUnderTest.formatsException(new SQLExecutionException(new SQLException(), "")));
        Assert.assertTrue(formatterUnderTest.formatsException(new SQLExecutionException(new SQLException(), "some error")));
        Assert.assertTrue(formatterUnderTest.formatsException(new SQLExecutionException(new SQLException(), null)));
        Assert.assertTrue(formatterUnderTest.formatsException(new IOException()));
        Assert.assertTrue(formatterUnderTest.formatsException(new DataTruncation(0, true, true, 0, 0)));
        Assert.assertTrue(formatterUnderTest.formatsException(new SQLWarning()));
    }

View Full Code Here

Examples of java.sql.SQLWarning

     */
    public static Statement execDMLWithResults(Connection conn, String dml) throws SQLException {
        // System.out.println(dml); // remove
        Statement stmnt = conn.createStatement();
        stmnt.executeQuery(dml);
        SQLWarning warn = stmnt.getWarnings();
        if (warn!=null) {
            //TODO handle SQL warnings
            System.out.println(warn.toString());
            System.out.println("("+dml+")");
        }
        return stmnt;
    }

View Full Code Here

Examples of java.sql.SQLWarning

     */
    public static void execDML(Connection conn, String dml) throws SQLException {
        // System.out.println(dml); // remove
        Statement stmnt = conn.createStatement();
        stmnt.execute(dml);
        SQLWarning warn = stmnt.getWarnings();
        if (warn!=null) {
            //TODO handle SQL warnings
            System.out.println(warn.toString());
            System.out.println("("+dml+")");
        }
        stmnt.close();
    }

View Full Code Here

Examples of java.sql.SQLWarning


        while (current.getChainedResult() != null) {
            current = current.getUnlinkChainedResult();


            if (current.getType() == ResultConstants.WARNING) {
                SQLWarning w = Util.sqlWarning(current);


                if (rootWarning == null) {
                    rootWarning = w;
                } else {
                    rootWarning.setNextWarning(w);

View Full Code Here

Examples of java.sql.SQLWarning


        while (current.getChainedResult() != null) {
            current = current.getUnlinkChainedResult();


            if (current.isWarning()) {
                SQLWarning w = Util.sqlWarning(current);


                if (rootWarning == null) {
                    rootWarning = w;
                } else {
                    rootWarning.setNextWarning(w);

View Full Code Here

Examples of java.sql.SQLWarning


        Result current = resultIn.getUnlinkChainedResult();


        while (current != null) {
            if (current.getType() == ResultConstants.WARNING) {
                SQLWarning w = Util.sqlWarning(current);


                if (rootWarning == null) {
                    rootWarning = w;
                } else {
                    rootWarning.setNextWarning(w);

View Full Code Here

Examples of java.sql.SQLWarning

    public static SQLException connectionClosedException() {
        return sqlException(ErrorCode.X_08003);
    }


    public static SQLWarning sqlWarning(Result r) {
        return new SQLWarning(r.getMainString(), r.getSubString(),
                              r.getErrorCode());
    }

View Full Code Here

Examples of java.sql.SQLWarning

  /* (non-Javadoc)
   * @see sos.connection.SOSConnection#getOutput()
   */
  public Vector getOutput() throws Exception {
    Vector out = new Vector();
    SQLWarning warning = getConnection().getWarnings();
    while (warning!=null){
      out.add(warning.getMessage());
      warning = warning.getNextWarning();
    }
    return out;
  }

View Full Code Here

Examples of java.sql.SQLWarning

    }
    
    public void testGrantRevokeDDL() throws Exception
    {
        ResultSet rs = null;
        SQLWarning sqlWarn = null;


        CallableStatement cSt;
        Statement st = createStatement();


        String [][] expRS;

View Full Code Here

Examples of java.sql.SQLWarning

    
        
    public void testGrantRevokeDDL2() throws SQLException {


      ResultSet rs = null;
        SQLWarning sqlWarn = null;


        Statement st = createStatement();


        String [][] expRS;
        String [] expColNames;

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.