Examples of java.sql.SQLException

java.sql.SQLException
An Exception class that is used in conjunction with JDBC operations. It provides information about problems encountered with Database access and other problems related to JDBC
The SQLException class provides the following information:
- A standard Java exception message, as a String
- An SQLState string. This is an error description string which follows either the SQL 99 conventions or the XOPEN SQLstate conventions. The potential values of the SQLState string are described in each of the specifications. Which of the conventions is being used by the SQLState string can be discovered by using the getSQLStateType method of the DatabaseMetaData interface.
- An Error Code, an an integer. The error code is specific to each database vendor and is typically the error code returned by the database itself.
- A chain to a next Exception, if relevant, which can give access to additional error information.

      out.println(sql);
      
      Throwable answer = t;
      if (t instanceof TeiidSQLException) {
        TeiidSQLException sqle = (TeiidSQLException) t;
        SQLException se = sqle.getNextException();
        if (se != null) {
          SQLException s = null;
          while( (s = se.getNextException()) != null) {
            se = s;
          }
          
          answer = se;

View Full Code Here

    }
    
    public Batch requestBatch(int beginRow) throws SQLException {
      batchCalls.add(beginRow);
      if (throwException) {
        throw new SQLException();
      }
          boolean isLast = false;
          int endRow = beginRow + 9;
          if (beginRow%10==0) {
            endRow = beginRow - 9;

View Full Code Here

    TeiidSQLException e = new TeiidSQLException();
    String sqlState = e.getSQLState();
    Throwable cause = e.getCause();
    int errorCode = e.getErrorCode();
    Throwable nestedException = e.getCause();
    SQLException nextException = e.getNextException();


    assertTrue(
        "Expected MMSQLException.getSQLState() to return <null> but got \"" //$NON-NLS-1$
            + sqlState + "\" instead.", sqlState == null); //$NON-NLS-1$
    assertTrue(
        "Expected MMSQLException.getCause() to return <null> but got [" //$NON-NLS-1$
            + (cause != null ? cause.getClass().getName()
                : "<unknown>") + "] instead.", cause == null); //$NON-NLS-1$ //$NON-NLS-2$
    assertTrue(
        "Expected MMSQLException.getErrorCode() to return [0] but got [" //$NON-NLS-1$
            + errorCode + "] instead.", errorCode == 0); //$NON-NLS-1$
    assertTrue(
        "Expected MMSQLException.getNestedException() to return <null> but got [" //$NON-NLS-1$
            + (nestedException != null ? nestedException.getClass()
                .getName() : "<unknown>") + "] instead.", //$NON-NLS-1$ //$NON-NLS-2$
        nestedException == null);
    assertTrue(
        "Expected MMSQLException.getNextException() to return <null> but got a SQLException with message \"" //$NON-NLS-1$
            + (nextException != null ? nextException.getMessage()
                : "") + "\" instead.", nextException == null); //$NON-NLS-1$ //$NON-NLS-2$
  }

View Full Code Here

    }
    String sqlState = e.getSQLState();
    Throwable cause = e.getCause();
    int errorCode = e.getErrorCode();
    Throwable nestedException = e.getCause();
    SQLException nextException = e.getNextException();


    assertTrue("Expected MMSQLException.getSQLState() to return \"" //$NON-NLS-1$
        + esqlState + "\" but got \"" + sqlState + "\" instead.", //$NON-NLS-1$ //$NON-NLS-2$
        sqlState.compareTo(esqlState) == 0);
    assertTrue("Expected MMSQLException.getCause() to return [" //$NON-NLS-1$
        + (ecause != null ? ecause.getClass().getName() : "<null>") //$NON-NLS-1$
        + "] but got [" //$NON-NLS-1$
        + (cause != null ? cause.getClass().getName() : "<unknown>") //$NON-NLS-1$
        + "] instead.", cause == ecause); //$NON-NLS-1$
    assertTrue(
        "Expected MMSQLException.getErrorCode() to return [0] but got [" //$NON-NLS-1$
            + errorCode + "] instead.", errorCode == 0); //$NON-NLS-1$
    assertTrue("Expected MMSQLException.getNestedException() to return [" //$NON-NLS-1$
        + (ecause != null ? ecause.getClass().getName() : "<null>") //$NON-NLS-1$
        + "] but got [" //$NON-NLS-1$
        + (nestedException != null ? nestedException.getClass()
            .getName() : "<unknown>") + "] instead.", //$NON-NLS-1$ //$NON-NLS-2$
        nestedException == ecause);
    assertTrue(
        "Expected MMSQLException.getNextException() to return <null> but got a SQLException with message \"" //$NON-NLS-1$
            + (nextException != null ? nextException.getMessage()
                : "") + "\" instead.", nextException == null); //$NON-NLS-1$ //$NON-NLS-2$
    return e;
    }

View Full Code Here

        
        assertEquals(exception, TeiidSQLException.create(exception));
    }
    
    public void testCreateFromSQLException() {
        SQLException sqlexception = new SQLException("foo", "21"); //$NON-NLS-1$ //$NON-NLS-2$
        
        SQLException nested = new SQLException("bar"); //$NON-NLS-1$
        
        sqlexception.setNextException(nested);
        
        String message = "top level message"; //$NON-NLS-1$
        
        TeiidSQLException exception = TeiidSQLException.create(sqlexception, message);
        
        assertEquals(exception.getMessage(), message);
        assertEquals(exception.getSQLState(), sqlexception.getSQLState());        
        assertEquals(exception.getNextException().getMessage(), sqlexception.getMessage());
        assertEquals(exception.getNextException().getNextException().getMessage(), nested.getMessage());
    }

View Full Code Here

  }
  
  @Test public void testDeserializationUnknownChildException() throws Exception {
    ClassLoader cl = new URLClassLoader(new URL[] {UnitTestUtil.getTestDataFile("test.jar").toURI().toURL()}); //$NON-NLS-1$
    Exception obj = (Exception)ReflectionHelper.create("test.UnknownException", null, cl); //$NON-NLS-1$
    obj.initCause(new SQLException("something bad happended")); //$NON-NLS-1$
    
    ByteArrayOutputStream baos = new ByteArrayOutputStream();
        ObjectOutputStream oos = new ObjectOutputStream(baos);
        oos.writeObject(new ExceptionHolder(new BadException2(obj, "I have foreign exception embedded in me"))); //$NON-NLS-1$
        oos.flush();

View Full Code Here

        buff.append(")");
    }


    private void execute(String sql) throws SQLException {
        String expected = null;
        SQLException e = null;
        for (Statement s : dbs) {
            try {
                boolean result = s.execute(sql);
                if (result) {
                    String data = getResult(s.getResultSet());

View Full Code Here

            if (running) {
                println("stopping (force)...");
                for (StackTraceElement e : mainThread.getStackTrace()) {
                    System.out.println(e.toString());
                }
                mainThread.stop(new SQLException("stop"));
            }
        }
    }

View Full Code Here

        if (t instanceof BatchUpdateException) {
            // do nothing
        } else if (t.getClass().getName().indexOf("SQLClientInfoException") >= 0) {
            // do nothing
        } else if (t instanceof SQLException) {
            SQLException s = (SQLException) t;
            int errorCode = s.getErrorCode();
            if (errorCode == 0) {
                printError(seed, id, s);
            } else if (errorCode == ErrorCode.OBJECT_CLOSED) {
                if (objectId >= 0 && objects.size() > 0) {
                    // TODO at least call a few more times after close - maybe

View Full Code Here

            session.prepare("shutdown immediately").update();
            database.removeSession(null);
            // everything OK - return
            return;
        } catch (DbException e) {
            SQLException e2 = DbException.toSQLException(e);
            int errorCode = e2.getErrorCode();
            if (errorCode == ErrorCode.WRONG_USER_OR_PASSWORD) {
                return;
            } else if (errorCode == ErrorCode.FILE_ENCRYPTION_ERROR_1) {
                return;
            }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of java.sql.SQLException

at.fhj.itm.business.ServiceTripTest

at.fhj.itm.business.ServiceUserLoginTest

com.alibaba.druid.mock.MockStatement

com.alibaba.druid.pool.DruidAbstractDataSource$DruidPoolConnectionFactory

com.alibaba.druid.pool.DruidDataSource

com.alibaba.druid.pool.ha.MultiDataSource

com.alimama.mdrill.jdbc.JdbcColumn

com.alimama.mdrill.jdbc.MdrillBaseResultSet

com.alimama.mdrill.jdbc.MdrillConnection

com.alimama.mdrill.jdbc.MdrillDatabaseMetaData

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.