Examples of java.sql.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

        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

     */
    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

     */
    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


        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


        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


        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

    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

  /* (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

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


        CallableStatement cSt;
        Statement st = createStatement();


        String [][] expRS;

View Full Code Here

    
        
    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 6 7 8 9

TOP

Related Classes of java.sql.SQLWarning

cascading.lingual.jdbc.LingualStatement

com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl

com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl

com.alibaba.druid.proxy.jdbc.StatementProxyImpl

com.caucho.quercus.lib.db.Mysqli

com.caucho.quercus.lib.db.PostgresModule

com.caucho.sql.spy.SpyStatement

com.impossibl.postgres.jdbc.ErrorUtils

com.impossibl.postgres.jdbc.PGSimpleStatement

com.jolbox.bonecp.ConnectionHandle

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.