List of alterColumn() Examples

Examples of alterColumn()

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

Alters an existing column. You can optionally alter the column's type, the default value, precision, and nullability. You can also optionally reindex the table. @param conn connection to the database @param table the name of the table where the column exists @param column the name of the column to alter @param generic_column_type the new generic type of the column @param default_value the new default value @param precision the new precision of the column @param nullable the new nullable value (if true, it's value can now be NULL) @param reindex if true, and the DB supports it, the table will be reindexed @throws SQLException

                preparedStatement = connection.prepareStatement("UPDATE RHQ_STORAGE_NODE SET VERSION = ?");
                preparedStatement.setString(1, "PRE-" + version);
                preparedStatement.executeUpdate();
                db.closeStatement(preparedStatement);
                // set column not null after it's been set
                db.alterColumn(connection, "RHQ_STORAGE_NODE", "VERSION", "VARCHAR2", null, "255", false, false);
                return true;
            }
        } finally {
            JDBCUtil.safeClose(null, preparedStatement, null);
        }

                preparedStatement = connection.prepareStatement("UPDATE RHQ_SERVER SET VERSION = ?");
                preparedStatement.setString(1, "PRE-" + version);
                preparedStatement.executeUpdate();
                db.closeStatement(preparedStatement);
                // set column not null after it's been set
                db.alterColumn(connection, "RHQ_SERVER", "VERSION", "VARCHAR2", null, "255", false, false);
                return true;
            }
        } finally {
            JDBCUtil.safeClose(null, preparedStatement, null);
        }

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


            checkColumnExistence(conn, db_type);


            db_type.alterColumn(conn, table, column, columnType, defval, precision, nullable, reindex);
        } catch (Exception e) {
            throw new BuildException(MSG.getMsg(DbAntI18NResourceKeys.ALTER_COLUMN_ERROR, e), e);
        }
    }

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 alterColumn()

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

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

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