/** * PUBLIC: * Execute the sql on the database. * <p>Example: * <p>session.executeNonSelectingSQL("Delete from Employee"); * @see #executeNonSelectingCall(Call) */ public void executeNonSelectingSQL(String sqlString) throws DatabaseException { executeNonSelectingCall(new SQLCall(sqlString)); }
/** * INTERNAL: * Execute the DDL to create the varray. */ public void createOnDatabase(AbstractSession session) throws TopLinkException { session.executeNonSelectingCall(new SQLCall(buildCreationWriter(session, new StringWriter()).toString())); }
/** * INTERNAL: * Execute the DDL to drop the varray. */ public void dropFromDatabase(AbstractSession session) throws TopLinkException { session.executeNonSelectingCall(new SQLCall(buildDeletionWriter(session, new StringWriter()).toString())); }
/** * INTERNAL: * Execute the SQL required to alter sequence increment. * Assume that the sequence exists. */ public void alterOnDatabase(AbstractSession session) throws TopLinkException { try { session.executeNonSelectingCall(new oracle.toplink.essentials.queryframework.SQLCall(buildAlterIncrementWriter(session, new StringWriter()).toString())); } catch (DatabaseException exception) { createOnDatabase(session); } }
void createUniqueConstraintsOnDatabase(final AbstractSession session) throws ValidationException, DatabaseException { if ((!session.getPlatform().supportsUniqueKeyConstraints()) || getUniqueKeys().isEmpty()) { return; } for (Enumeration uniqueKeysEnum = getUniqueKeys().elements(); uniqueKeysEnum.hasMoreElements();) { UniqueKeyConstraint uniqueKey = (UniqueKeyConstraint)uniqueKeysEnum.nextElement(); session.executeNonSelectingCall(new oracle.toplink.essentials.queryframework.SQLCall(buildUniqueConstraintCreationWriter(session, uniqueKey, new StringWriter()).toString())); } }
private void dropUniqueConstraintsOnDatabase(final AbstractSession session) throws ValidationException { if ((!session.getPlatform().supportsUniqueKeyConstraints()) || getUniqueKeys().isEmpty()) { return; } for (Enumeration uniqueKeysEnum = getUniqueKeys().elements(); uniqueKeysEnum.hasMoreElements();) { UniqueKeyConstraint uniqueKey = (UniqueKeyConstraint)uniqueKeysEnum.nextElement(); try { session.executeNonSelectingCall(new oracle.toplink.essentials.queryframework.SQLCall(buildUniqueConstraintDeletionWriter(session, uniqueKey, new StringWriter()).toString())); } catch (DatabaseException ex) {/* ignore */ } } }
private void dropForeignConstraintsOnDatabase(final AbstractSession session) throws ValidationException { if ((!session.getPlatform().supportsForeignKeyConstraints()) || getForeignKeyMap().isEmpty()) { return; } for (ForeignKeyConstraint foreignKey : getForeignKeyMap().values()) { try { session.executeNonSelectingCall(new SQLCall(buildConstraintDeletionWriter(session, foreignKey, new StringWriter()).toString())); } catch (DatabaseException ex) {/* ignore */ } } }
void createForeignConstraintsOnDatabase(final AbstractSession session) throws ValidationException, DatabaseException { if ((!session.getPlatform().supportsForeignKeyConstraints()) || getForeignKeyMap().isEmpty()) { return; } for (ForeignKeyConstraint foreignKey : getForeignKeyMap().values()) { session.executeNonSelectingCall(new SQLCall(buildConstraintCreationWriter(session, foreignKey, new StringWriter()).toString())); } }