List of checkTableExists() Examples

Examples of checkTableExists()

org.rhq.core.db.DatabaseType.checkTableExists()

Determines if the given table exists in the database. Note that if the table does not exist a call to this method will cause an underlying SQLException, which will invalidate the current transaction. @param conn connection to the database where the table to check is @param table the table to check for existence @return true if the table exists in the database, false if the table does not exist ANDthe implementation determined the information WITHOUT generating an SQLException (meaning the transaction has not been invalidated. Otherwise, throws an exception which should be handled. @throws IllegalStateException if the check generated an expected "table does not exist SQLException (note, theexception invalidates the transaction). @throws Exception if the table check failed for a reason other than a "table does not exist" error.


        Connection conn = getDatabaseConnection(connectionUrl, username, password);
        DatabaseType db = DatabaseTypeFactory.getDatabaseType(conn);


        try {
            return db.checkTableExists(conn, "RHQ_PRINCIPAL");
        } catch (IllegalStateException e) {
            return false;
        } finally {
            db.closeConnection(conn);
        }


        try {
            conn = getDatabaseConnection(connectionUrl, username, password);
            db = DatabaseTypeFactory.getDatabaseType(conn);


            if (db.checkTableExists(conn, "rhq_server")) {


                stm = conn.createStatement();
                rs = stm.executeQuery("SELECT name FROM rhq_server ORDER BY name asc");


                while (rs.next()) {


        DatabaseType db_type = getDatabaseType();
        Connection conn = getConnection();


        try {
            boolean table_exists = db_type.checkTableExists(conn, table);


            if (!table_exists) {
                log(MSG.getMsg(DbAntI18NResourceKeys.DROP_TABLE_TABLE_DOES_NOT_EXIST, table));
                return;
            }

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.

Examples of checkTableExists()

Examples of org.rhq.core.db.DatabaseType.checkTableExists()

Examples of org.rhq.core.db.DatabaseType.checkTableExists()

Examples of org.rhq.core.db.DatabaseType.checkTableExists()