Share via


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
Gg821810.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif createStatement Creates a Statement object that is used to execute an SQL statement.
Gg821810.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif finalize
Gg821810.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Connection class. (Overrides the new Method.)
Gg821810.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif 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.
Gg821810.pubmethod(en-us,AX.60).gif 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.
Gg821810.pubmethod(en-us,AX.60).gif 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.
Gg821810.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif toString Converts the Connection object to a string. (Overrides the toString Method.)
Gg821810.pubmethod(en-us,AX.60).gif ttsabort Discards changes that are associated with a transaction and rolls the database back to the original state.
Gg821810.pubmethod(en-us,AX.60).gif ttsbegin Begins a transaction.
Gg821810.pubmethod(en-us,AX.60).gif ttscommit Commits the changes that are associated with a transaction to the database.
Gg821810.pubmethod(en-us,AX.60).gif ttsLevel Returns the number for the last call to the ttsbegin method that is used to begin a transaction.
Gg821810.pubmethod(en-us,AX.60).gif ttsNotifyAbort Is called when an exception is thrown.
Gg821810.pubmethod(en-us,AX.60).gif ttsNotifyBegin
Gg821810.pubmethod(en-us,AX.60).gif ttsNotifyCommit Is called when the ttscommit method is called.
Gg821810.pubmethod(en-us,AX.60).gif usageCount Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg821810.pubmethod(en-us,AX.60).gif 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