Index by: file name | procedure name | procedure call | annotation

sqlrconCmd.tcl (annotations | original source)

    # Initiates a connection to "server" on "port"
    # or to the unix "socket" on the local machine
    # and authenticates with "user" and "password".
    # Failed connections will be retried for
    # "tries" times on interval "retrytime".
    # If "tries" is 0 then retries will continue
    # forever.  If "retrytime" is 0 then retries
    # will be attempted on a default interval.
    #
    # If the "socket" parameter is neither
    # NULL nor "" then an attempt will be made to
    # connect through it before attempting to
    # connect to "server" on "port".  If it is
    # NULL or "" then no attempt will be made to
    # connect through the socket.
    proc sqlrconCmd {server port socket user password retrytime tries}

    # Disconnects and ends the session if
    # it hasn't been ended already.
    proc sqlrconDelete {}

    # Sets the server connect timeout in seconds
    # and milliseconds.  Setting either parameter
    # to -1 disables the timeout.
    proc setTimeout {timeoutsec timeoutusec}

    # Ends the session.
    proc endSession {}

    # Disconnects this connection from the current
    # session but leaves the session open so
    # that another connection can connect to it
    # using resumeSession {}.
    proc suspendSession {}

    # Returns the inet port that the connection is
    # communicating over. This parameter may be
    # passed to another connection for use in
    # the resumeSession {} method.
    # Note: The value this method returns is only
    # valid after a call to suspendSession {}.
    proc getConnectionPort {}

    # Returns the unix socket that the connection
    # is communicating over. This parameter may be
    # passed to another connection for use in
    # the resumeSession {} method.
    # Note: The value this method returns is only
    # valid after a call to suspendSession {}.
    proc getConnectionSocket {}

    # Resumes a session previously left open
    # using suspendSession {}.
    # Returns true on success and false on failure.
    proc resumeSession {port socket}

    # Returns true if the database is up and false
    # if it's down.
    proc ping {}

    # Returns the type of database:
    # oracle8 postgresql mysql etc.
    proc identify {}

    # Returns the version of the database
    proc dbVersion {}

    # Returns the version of the sqlrelay server software.
    proc serverVersion {}

    # Returns the version of the sqlrelay client software.
    proc clientVersion {}

    # Returns a string representing the format
    # of the bind variables used in the db.
    proc bindFormat {}

    # Sets the current database/schema to "database"
    proc selectDatabase {database}

    # Returns the database/schema that is currently in use.
    proc getCurrentDatabase {}

    # Returns the value of the autoincrement
    # column for the last insert
    proc getLastInsertId {}

    # Instructs the database to perform a commit
    # after every successful query.
    proc autoCommitOn {}

    # Instructs the database to wait for the
    # client to tell it when to commit.
    proc autoCommitOff {}

    # Issues a commit.  Returns 1 if the commit
    # succeeded 0 if it failed.
    proc commit {}

    # Issues a rollback.  Returns 1 if the rollback
    # succeeded 0 if it failed.
    proc rollback {}

    # If an operation failed and generated an
    # error the error message is available here.
    # If there is no error then this method
    # returns NULL.
    proc errorMessage {}

    # Causes verbose debugging information to be
    # sent to standard output.  Another way to do
    # this is to start a query with "-- debug\n".
    # Another way is to set the environment variable
    # SQLRDEBUG to "ON"
    proc debugOn {}

    # Turns debugging off.
    proc debugOff {}

    # Returns false if debugging is off and true
    # if debugging is on.
    proc getDebug {}

Index by: file name | procedure name | procedure call | annotation
File generated 2012-01-10 at 06:42.