UserConnection Class

Article
04/11/2014

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
	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. (Inherited from Connection.)
	equal	Determines whether the specified object is equal to the current one. (Inherited from Object.)
	finalize	(Inherited from Connection.)
	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. (Inherited from 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. (Inherited from 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. (Inherited from 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. (Inherited from Connection.)
	ttsabort	Discards changes that are associated with a transaction and rolls the database back to the original state. (Inherited from Connection.)
	ttsbegin	Begins a transaction. (Inherited from Connection.)
	ttscommit	Commits the changes that are associated with a transaction to the database. (Inherited from Connection.)
	ttsLevel	Returns the number for the last call to the ttsbegin method that is used to begin a transaction. (Inherited from Connection.)
	ttsNotifyAbort	Is called when an exception is thrown. (Inherited from Connection.)
	ttsNotifyBegin	(Inherited from Connection.)
	ttsNotifyCommit	Is called when the ttscommit method is called. (Inherited from Connection.)
	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

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