org.netbeans.modules.db.api.sql.execute

Class SQLExecutor

java.lang.Object

org.netbeans.modules.db.api.sql.execute.SQLExecutor

public class SQLExecutor
extends Object

Support execution of SQL scripts without bringing up the editor

Constructor Summary

Constructors

Constructor and Description
SQLExecutor()

Method Summary

Modifier and Type	Method and Description
static SQLExecutionInfo	execute(DatabaseConnection dbconn, String sql) Execute SQL and log summary information about the results and any errors are logged to the error log file.
static SQLExecutionInfo	execute(DatabaseConnection dbconn, String sql, SQLExecuteLogger logger) Execute SQL.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLExecutor

public SQLExecutor()

Method Detail

execute

public static SQLExecutionInfo execute(DatabaseConnection dbconn,
                                       String sql)
                                throws DatabaseException

Execute SQL and log summary information about the results and any errors are logged to the error log file. This method should not be called on the AWT event thread; to do so will cause an exception to be thrown.

Parameters:

dbconn - the database connection to use when executing the SQL

sql - the SQL which contains one or more valid SQL statements

Throws:

IllegalStateException - if this is executed on the AWT event thread

DatabaseException - if the database connection is not connected

execute

public static SQLExecutionInfo execute(DatabaseConnection dbconn,
                                       String sql,
                                       SQLExecuteLogger logger)
                                throws DatabaseException

Execute SQL. Note this is a very basic implementation. Subsequent extensions could include getting results back, passing in a logger, etc., but trying to keep things simple for now. This method should not be called on the AWT event thread; to do so will cause an exception to be thrown.

Parameters:

dbconn - the database connection to use when executing the SQL

sql - the SQL which contains one or more valid SQL statements

logger - this object is notified with execution information when execution of each statement completes and when the entire execution completes or is cancelled.

Throws:

IllegalStateException - if this is executed on the AWT event thread

DatabaseException - if the database connection is not connected