Connection Class

The Connection class establishes a current database session that you can use to execute SQL statements and return results.

Syntax

class Connection extends Object

Run On

Server

Methods

	Method	Description
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	createStatement	Creates a Statement object that is used to execute an SQL statement.
	equal	Determines whether the specified object is equal to the current one. (Inherited from Object.)
	finalize
	getTimeOutTimerHandle	Returns the timer handle for the object. (Inherited from Object.)
	handle	Retrieves the handle of the class of the object. (Inherited from Object.)
	new	Initializes a new instance of the Connection class. (Overrides the new Method.)
	notify	Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
	notifyAll	Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
	objectOnServer	Determines whether the object is on a server. (Inherited from Object.)
	odbcGetInfoInt	Provides an interface to the SQLGetInfo Open Database Connectivity (ODBC) function to retrieve information about the ODBC driver and data source that are associated with a connection.
	odbcGetInfoLong	Provides an interface to the SQLGetInfo ODBC function to retrieve information about the ODBC driver and data source that are associated with a connection.
	odbcGetInfoStr	Provides an interface to the SQLGetInfo ODBC function to retrieve information, in string format, about the ODBC driver and data source that are associated with a connection.
	owner	Returns the instance that owns the object. (Inherited from Object.)
	setTimeOut	Sets up the scheduled execution of a specified method. (Inherited from Object.)
	toString	Converts the Connection object to a string. (Overrides the toString Method.)
	ttsabort	Discards changes that are associated with a transaction and rolls the database back to the original state.
	ttsbegin	Begins a transaction.
	ttscommit	Commits the changes that are associated with a transaction to the database.
	ttsLevel	Returns the number for the last call to the ttsbegin method that is used to begin a transaction.
	ttsNotifyAbort	Is called when an exception is thrown.
	ttsNotifyBegin
	ttsNotifyCommit	Is called when the ttscommit method is called.
	usageCount	Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.)
	wait	Pauses a process. (Inherited from Object.)
	xml	Returns an XML string that represents the current object. (Inherited from Object.)

Top

Remarks

The following classes extend the Connection class:

• OdbcConnection

• OciConnection

• UserConnection

Examples

In the following example, the createStatement method initializes the Statement object. The Statement.executeQuery method executes an SQL statement and then stores the retrieved data in the ResultSet object.

server static void main(Args args) 
{ 
    Connection con = new Connection(); 
    Statement stmt = con.createStatement(); 
    ResultSet r; 
    str sql; 
    SqlStatementExecutePermission perm; 
  
    sql = strfmt('SELECT VALUE FROM SQLSYSTEMVARIABLES'); 
  
    // Set code access permission to help protect the use of 
    // Statement.executeUpdate. 
    perm = new SqlStatementExecutePermission(sql); 
    perm.assert(); 
  
    try 
    { 
        r = stmt.executeQuery(sql); 
        while (r.next()) 
        { 
            print r.getString(1); 
            pause; 
        } 
    } 
    catch (exception::Error) 
    { 
        print "An error occured in the query."; 
        pause; 
    } 
    // Code access permission scope ends here. 
    CodeAccessPermission::revertAssert(); 
}

Inheritance Hierarchy

Object Class
  Connection Class
    OciConnection Class
    OdbcConnection Class
    UserConnection Class

See Also

UserConnection Class

OdbcConnection Class