Package com.microstrategy.web.objects

Interface WebDBConnection

    • Method Detail

      • getDBLogin

        WebDBLogin getDBLogin()
        Returns:
        WebDBLogin object used to connect to ODB associated with this connection

      • getConnectionString

        java.lang.String getConnectionString()
        Returns:
        a String including connection information about this Database connection

      • getOAuthParameter

        java.lang.String getOAuthParameter()
        Returns:
        a String including OAuth parameter

      • getDatabaseType

        java.lang.Integer getDatabaseType()
        Returns the type of DB being accessed.
        Returns:
        integer from EnumDSSXMLDatabaseType

      • getDBRoleType

        java.lang.Integer getDBRoleType()
        Returns the type of DB role accessed.
        Returns:
        integer from EnumDSSXMLDatabaseType

      • getDriverMode

        java.lang.Integer getDriverMode()
        Returns:
        Integer from EnumDSSXMLDBConnectionDriverMode. DriverType is an enumeration property. It specifies the connection driver type. It specifies whether the connection is made using ODBC or some native database driver.

      • getExecutionMode

        java.lang.Integer getExecutionMode()
        Returns:
        Integer from EnumDSSXMLDBConnectionExecutionMode. ExecutionMode is an enumeration property. It specifies the manner in which SQL statements will be executed on a physical connection made using this object. In particular it indicates if the statement is executed synchronously or asynchronously.

      • isExtendedFetchEnabled

        java.lang.Boolean isExtendedFetchEnabled()
        Returns:
        ExtendedFetch is a Boolean property. It specifies whether or not to use the extended fetch ODBC call to retrieve data from the connection.

      • getCacheTimeout

        java.lang.Integer getCacheTimeout()
        Returns:
        Integer seconds for CacheTimeout. CacheTimeOut is a numeric property. When use connection pooling, the connection is not disconnected when it is released. Instead, it is kept open until it idles for ConnectionCacheTimeOut seconds. If a connection is open and released frequently, connection pooling reduces the cost associated with creating a new connection.

      • setCacheTimeout

        void setCacheTimeout​(int cacheTimeout)
        Parameters:
        cacheTimeout - Integer seconds for CacheTimeout. CacheTimeOut is a numeric property. When use connection pooling, the connection is not disconnected when it is released. Instead, it is kept open until it idles for ConnectionCacheTimeOut seconds. If a connection is open and released frequently, connection pooling reduces the cost associated with creating a new connection.

      • getConnectionTimeout

        java.lang.Integer getConnectionTimeout()
        Returns:
        Integer specifying how long before requests on connection are timed out. It specifies the time in seconds to wait for a connection request comes back.

      • setConnectionTimeout

        void setConnectionTimeout​(int time)
        Parameters:
        time - Integer specifying how long before requests on connection are timed out. It specifies the time in seconds to wait for a connection request comes back.

      • getTablePrefix

        java.lang.String getTablePrefix()
        Returns:
        String containing table prefix for this connection. TablePrefixString is a text property. The QueryEngine prefixed the names of all temporary tables that it creates during report execution with this string.

      • getMaxDBConnections

        java.lang.Integer getMaxDBConnections()
        Returns:
        integer numeric property (Backend information)

      • getMaxDBCost

        java.lang.Integer getMaxDBCost()
        Returns:
        integer numeric property (Backend information)

      • getTraceFlag

        java.lang.Boolean getTraceFlag()
        Returns:
        boolean specifying whether requests on this connection should be traced

      • enableTrace

        void enableTrace()

      • disableTrace

        void disableTrace()

      • setMultiProcess

        void setMultiProcess​(int type)

      • setDBLogin

        void setDBLogin​(WebDBLogin newL)
        Parameters:
        newL - WebDBLogin to be associated with this connection

      • setDBLogin

        void setDBLogin​(WebDBLogin newL,
                boolean embed)
        Sets the login credentials to be used by this connection
        Parameters:
        newL - WebDBLogin object representing login credentials for this connection
        embed - boolean true when newL should be embedded in

      • setConnectionString

        void setConnectionString​(java.lang.String connectionString)
        Parameters:
        connectionString - String including connection information associated with this database connection

      • setOAuthParameter

        void setOAuthParameter​(java.lang.String oa)
        Parameters:
        oa - String including OAuth parameter

      • setDatabaseType

        void setDatabaseType​(int newType)
        Changes the type of Database type associated with this database connection This method is only applicable for MDX database, which is DssXmlDBSAP or DssXmlDBMicrosoftAS. For other database type, we always use default database type and not allow use this method to set database type.
        Parameters:
        newType - integer representing the type of the new DB to be connected by this DBConnection from EnumDSSXMLDatabaseType

      • setDBRoleType

        void setDBRoleType​(int newType)
        Changes the type of DBRole type associated with this database connection This method is only applicable for remote projects
        Parameters:
        newType - integer representing the type of the new DB to be connected by this DBConnection from EnumDSSXMLDatabaseType

      • setDriverMode

        void setDriverMode​(int newMode)
        Parameters:
        newMode - Integer from EnumDSSXMLDBConnectionDriverMode. It specifies the connection driver type. It specifies whether the connection is made using ODBC or some native database driver.

      • setExecutionMode

        void setExecutionMode​(int newMode)
        Parameters:
        newMode - Integer from EnumDSSXMLDBConnectionExecutionMode. It specifies the manner in SQL statements will be executed on a physical connection made using this object. In particular it indicates if the statement is executed synchronously or asynchronously.

      • enableExtendedFetch

        void enableExtendedFetch()
        Enable Extended fetch for ODB for this connection. ExtendedFetch is a Boolean property. It specifies whether or not to use the extended fetch ODBC call to retrieve data from the connection.

      • disableExtendedFetch

        void disableExtendedFetch()
        Disable Extended Fetch for ODB associated with this connection. ExtendedFetch is a Boolean property. It specifies whether or not to use the extended fetch ODBC call to retrieve data from the connection.

      • enableParameterizedQueries

        void enableParameterizedQueries()
                         throws WebObjectsException
        Enable parameterized queries. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it.
        Throws:
        WebObjectsException

      • disableParameterizedQueries

        void disableParameterizedQueries()
                          throws WebObjectsException
        Disable parameterized queries. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it.
        Throws:
        WebObjectsException

      • setMaxCancelAttemptTime

        void setMaxCancelAttemptTime​(int time)
                      throws WebObjectsException
        Set the maximum cancel attempt time. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it
        Parameters:
        time - Integer seconds maximum time to attempt to cancel a connection
        Throws:
        WebObjectsException

      • setMaxQueryExeTime

        void setMaxQueryExeTime​(int time)
                 throws WebObjectsException
        Set the maximum query execution time. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it
        Parameters:
        time - Integer seconds maximum time a query can execute before being timed out
        Throws:
        WebObjectsException

      • getMaxConnectionAttemptTime

        int getMaxConnectionAttemptTime()
                         throws WebObjectsException
        Set the maximum connection attempt time. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it
        Returns:
        Integer number of seconds connection attempts to be made before timing out
        Throws:
        WebObjectsException

      • setMaxConnectionAttemptTime

        void setMaxConnectionAttemptTime​(int time)
                          throws WebObjectsException
        Set the maximum connection attempt time. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it
        Parameters:
        time - Integer seconds maximum time to try to connect to IServer
        Throws:
        WebObjectsException

      • setTablePrefix

        void setTablePrefix​(java.lang.String prefix)
             throws java.lang.IllegalArgumentException
        Parameters:
        prefix - String containing table prefix for this connection
        Throws:
        java.lang.IllegalArgumentException

      • setCharEncoding

        void setCharEncoding​(int encoding)
              throws WebObjectsException
        Set the character set encoding for Windows drivers. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it.
        Parameters:
        encoding -
        Throws:
        WebObjectsException

      • setCharEncodingForUnix

        void setCharEncodingForUnix​(int encoding)
                     throws WebObjectsException
        Set the character set encoding for Unix drivers. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it.
        Parameters:
        encoding -
        Throws:
        WebObjectsException

      • setConnectionLifetime

        void setConnectionLifetime​(int timeout)
                    throws WebObjectsException
        Set the connection lifetime. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it.
        Parameters:
        timeout - integer seconds maximum connection lifetime
        Throws:
        WebObjectsException

      • setIdleTimeout

        void setIdleTimeout​(int timeout)
             throws WebObjectsException
        Set the connection idle timeout. This method modifies a WebObjectInfo property. Therefore, this object must exist in the MD prior to calling it.
        Parameters:
        timeout - integer seconds maximum connection lifetime
        Throws:
        WebObjectsException

      • setMaxDBConnections

        void setMaxDBConnections​(int conns)
        Parameters:
        conns - integer specifying a numeric property for this connection

      • setMaxDBCost

        void setMaxDBCost​(int cost)
        Parameters:
        cost - integer specifying a numeric property for this connection

      • getCacheOption

        java.lang.Integer getCacheOption()
        Returns:
        integer from EnumDSSXMLDBConnectionCacheOption It specifies the degree to which the intelligence server will attempt to reuse physical connections made using the specification contained in this DBConnection object.

      • setCacheOption

        void setCacheOption​(int option)
        Parameters:
        option - integer from EnumDSSXMLDBConnectionCacheOption. It specifies the degree to which the intelligence server will attempt to reuse physical connections made using the specification contained in this DBConnection object.

      • getCacheSize

        java.lang.Integer getCacheSize()
        Returns:
        integer. It contains the maximum number of physical connections made using the specifications in this object that may be opened simultaneously. Thus it is the maximum size of the connection pool.

      • setCacheSize

        void setCacheSize​(int size)
        Parameters:
        size - integer. It contains the maximum number of physical connections made using the specifications in this object that may be opened simultaneously. Thus it is the maximum size of the connection pool.

      • setDBVersion

        void setDBVersion​(java.lang.Integer dbVersion)
        Parameters:
        dbVersion - integer value from EnumDSSXMLDatabaseVersion