Share via


UserConnection Class

The UserConnection class represents an auxiliary connection to the SQL database, based on the same logon properties as the main connection.

Syntax

class UserConnection extends Connection

Run On

Server

Methods

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

Top

Remarks

SQL statements are executed, and results are returned in the context of a UserConnection class. The UserConnection class can be used to obtain a separate transaction scope.

Examples

static void example()  
{ 
    UserConnection Con; 
    Statement Stmt; 
    Str sql; 
    ResultSet R; 
    SqlStatementExecutePermission perm; 
  
    Con = new UserConnection(); 
    sql = 'SELECT VALUE FROM SQLSYSTEMVARIABLES'; 
    Stmt = Con.createStatement(); 
    perm = new SqlStatementExecutePermission(sql); 
 
    // Check for permission to use the statement. 
    perm.assert(); 
    R = Stmt.executeQuery(sql); 
    while ( R.next() ) 
    { 
        print R.getString(1); 
    } 
}

Inheritance Hierarchy

Object Class
  Connection Class
    UserConnection Class

See Also

Connection Class

OdbcConnection Class