UserConnection Class [AX 2012]

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

class UserConnection extends Connection

Run On

Server

  MethodDescription
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

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.

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); 
    } 
}

Object Class
  Connection Class
    UserConnection Class

Community Additions

ADD
Show: