Please enable JavaScript.

Coggle requires JavaScript to display documents.

Database (Operations (Use Cases (TransactionalTestCase (::…

- - - - Query
        
        SQL Query Text
      - Input parameters
      - Use Cases
        
        DeleteTestCase
        
        :: deleteDynamic()
        :: deleteParemeterized()
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Output
        
        Target Variable
    - - Use Cases
        
        DeleteMetadataTestCase
        
        :: deleteNoParametersInputMetadata()
        :: deleteOutputMetadata()
        :: deleteParameterizedInputMetadata()
        :: deleteWithExpressionInputMetadata()
  - - - Query
        
        SQL Query Text
        
        Input Parameters
        
        In out parameters
        
        Expression
        
        Inline
        
        Output parameters
        
        Expression
        
        Inline
      - Use Cases
        
        StoredProcedureTestCase
        
        :: concatenatesStrings()
        :: inOutParameter()
        :: multipliesIntegers()
        :: outParam()
        
        StoredProcedureStreamingTestCase
        
        :: streamingInOutParam()
        
        StoredProcedureJavaUdtTestCase
        
        :: returnsObject()
        
        StoredProcedureJavaArrayUdtTestCase
        
        :: returnsCustomArray()
        :: returnsDefaultArray()
        
        StoredProcedureClobInputParamTestCase
        
        :: convertsStringToClob()
        
        AbstractStoredProcedureReturningStreamingResultsetsTestCase
        
        :: getResultSet()
        
        AbstractStoredProcedureReturningResultsetTestCase
        
        :: testRequestResponse()
        
        AbstractStoredProcedureParameterizedUpdateTestCase
        
        :: update()
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Auto Generate Keys
        
        Auto Generate Keys
        
        False
        
        True
        
        Expression
        
        Auto generate keys column indexes
        
        Expression
        
        Inline
        
        Auto generate keys column names
        
        Expression
        
        Inline
      - Output
        
        Target Variable
    - - Use Cases
        
        StoreProcedureOutputMetadataTestCase
        
        :: updateMetadata()
  - - - Query
        
        SQL Query Text
      - Use Cases
        
        Default Extension Configuration
        
        Default Operation Configuration
        
        execute-ddl - Oracle Connection - DDL statement is successfully executed
        
        execute-ddl - MySQL Connection - DDL statement is successfully executed
        
        execute-ddl - Generic Connection - DDL statement is successfully executed
        
        execute-ddl - Derby Connection - DDL statement is successfully executed
        
        execute-ddl - Data Source Reference Connection - DDL statement is successfully executed
        
        Optional attributes
        
        execute-ddl - Oracle Connection - Transactional action is NOT_SUPPORTED
        
        execute-ddl - Oracle Connection - Transactional action is ALWAYS_JOIN
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query Settings
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
      - Output
        
        Target Variable
  - - - Query
        
        SQL Query Text
        
        Script Path
      - Use Cases
        
        ExecuteScriptTestCase
        
        :: executeScriptFromFile()
        :: updatesDataRequestResponse()
        
        InvalidExecuteScriptTestCase
        
        :: exclusiveFileAndSql()
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query Settings
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
      - Output
        
        Target Variable
  - - - Query
        
        SQL Query Text
        
        Input Parameters
      - Use Cases
        
        UpdateJavaArrayUdtTestCase
        
        :: updatesMappedObjectArray()
        :: updatesStringArray()
        
        UpdateJavaUdtTestCase
        
        :: updatesWithArray()
        :: updatesWithStruct()
        
        UpdateNameParamOverrideTestCase
        
        :: usesExpressionParam()
        :: usesParamsInInlineQuery()
        
        UpdateStoredProcedure
        
        :: testRequestResponse()
        
        UpdateStructUdtTestCase
        
        :: updatesWithObject()
        :: updatesWithStruct()
        
        UpdateTestCase
        
        :: mergesTables()
        :: truncateTable()
        :: update()
        :: updateBlob()
        :: updateBlobWithStream()
        :: updateDynamic()
        :: updateParameterized()
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Auto Generate Keys
        
        Auto Generate Keys
        
        False
        
        True
        
        Expression
        
        Auto generate keys column indexes
        
        Expression
        
        Inline
        
        Auto generate keys column names
        
        Expression
        
        Inline
      - Output
        
        Target Variable
    - - Use Cases
        
        UpdateMetadataTestCase
        
        :: updateNoParametersInputMetadata()
        :: updateOutputMetadata()
        :: updateParameterizedInputMetadata()
        :: updateWithExpressionInputMetadata()
  - - - Input parameters
      - Query
        
        SQL Query Text
      - Use Cases
        
        BulkDeleteTestCase
        
        bulkDelete()
        bulkDeleteWithOverriddenType()
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Output
        
        Target Variable
    - - Use Cases
        
        DeleteMetadataTestCase
        
        :: bulkDeleteNoParametersInputMetadata()
        :: bulkDeleteOutputMetadata()
        :: bulkDeleteParameterizedInputMetadata()
  - - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Auto Generate Keys
        
        Auto Generate Keys
        
        False
        
        True
        
        Expression
        
        Auto generate keys column indexes
        
        Expression
        
        Inline
        
        Auto generate keys column names
        
        Expression
        
        Inline
        
        Use Cases
        
        AbstractInsertAutoGeneratedKeyTestCase
        
        :: returnsAutoGeneratedKeys()
      - Output
        
        Target Variable
    - - Query
        
        Input Parameters
        
        SQL Query Text
      - Use Cases
        
        InsertClobInputParamTestCase
        
        :: usesStringOnExplicitParam()
        :: usesStringOnImplicitParam()
        
        InsertTestCase
        
        :: insert()
        :: insertDynamic()
        :: insertMany()
        :: usesParameterizedQuery()
    - - Use Cases
        
        InsertMetadataTestCase
        
        :: insertNoParametersInputMetadata()
        :: insertOutputMetadata()
        :: insertParameterizedInputMetadata()
        :: insertWithExpressionInputMetadata()
  - - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Output
        
        Target Variable
    - - Query
        
        SQL Query Text
      - Input parameters
      - Use Cases
        
        BulkUpdateTestCase
        
        :: bulkUpdate()
        :: bulkUpdateWithOverriddenType()
        :: updateBulkAfterSelect()
    - - Use Cases
        
        UpdateMetadataTestCase
        
        :: bulkUpdateNoParametersInputMetadata()
        :: bulkUpdateOutputMetadata()
        :: bulkUpdateParameterizedInputMetadata()
  - - - Query
        
        SQL Query Text
      - Input parameters
      - Use Cases
        
        SelectJavaUdtTestCase
        
        :: returnsMappedObject()
        
        SelectStoredProcedureTestCase
        
        :: selectsFromStoredProcedure()
        
        SelectTestCase
        
        :: dynamicQuery()
        :: expressionAndFixedParamMixed()
        :: fixedParam()
        :: maxRows()
        :: missingSQL()
        :: namedParameter()
        :: returnsAliasInResultSet()
        :: select()
        
        OracleSelectWithTestCase
        
        :: selectWith()
        
        SelectJavaArrayUdtTestCase
        
        :: returnsMappedObjectArray()
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
        
        Streaming strategy
        
        Non repeatable iterable
        
        Repeatable file store iterable
        
        In memory objects
        
        Repeatable in memory iterable
        
        Initial buffer size
        
        Buffer size increment
        
        Max in memory instances
        
        Use Cases
        
        SelectExceptionTestCase
        
        :: streamingException()
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Output
        
        Target Variable
    - - Use Cases
        
        SelectMetadataInputTestCase
        
        :: returnsAnySelectInputMetadataFromNotSupportedParameterizedQuery()
        :: returnsNullSelectMetadataUnParameterizedQuery()
        :: returnsSelectInputMetadataFromBeanParameterizedQuery()
        
        SelectMetadataOutputTestCase
        
        :: selectAll()
        :: selectInvalidJoin()
        :: selectJoin()
        :: selectSome()
  - - - Input parameters
      - Query
        
        SQL Query Text
      - Use Cases
        
        BulkInsertTestCase
        
        :: bulkInsertUnusedParameterType()
        :: bulkInsertWithOverriddenType()
        :: dynamicBulkInsert()
    - - General
        
        Transactional action
        
        ALWAYS_JOIN
        
        JOIN_IF_POSSIBLE
        
        NOT_SUPPORTED
      - Query
        
        Query timeout
        
        Query timeout unit
        
        Fetch size
        
        Max rows
        
        Parameter types
        
        None
        
        Expression
        
        Inline
      - Output
        
        Target Variable
    - - Use Cases
        
        InsertMetadataTestCase
        
        :: bulkInsertNoParametersInputMetadata()
        :: bulkInsertOutputMetadata()
        :: bulkInsertParameterizedInputMetadata()
  - - - :: commitAnOptionalTxUpdateIsANonTxBlock()
        :: commitNonTxUpdateInATxBlock()
        :: commitTxUpdateOutsideABlock()
        :: rollbackOptionalTxUpdateInATxBlock()
        :: rollbackTxUpdateInATxBlock()
    - - :: definesTemplateWithComplexExpressionParam()
        :: definesTemplateWithExpressionParam()
        :: detectsDdl()
        :: detectsDelete()
        :: detectsInsert()
        :: detectsInsertWithLineBreak()
        :: detectsMerge()
        :: detectsMissingOutParamStoredProcedureAssignmentAsDdl()
        :: detectsMissingParamEscapingStoredProcedureAssignmentAsDdl()
        :: detectsMissingParamNameStoredProcedureAssignmentAsDdl()
        :: detectsSelect()
        :: detectsStoredProcedureAssignment()
        :: detectsStoredProcedureWithBrackets()
        :: detectsStoredProcedureWithLineBreak()
        :: detectsStoredProcedureWithOutBrackets()
        :: detectsStoredProcedureWithoutSpaceAfterBracket()
        :: detectsStoredProcedureWithSpaces()
        :: detectsTruncate()
        :: detectsUnterminatedMuleExpression()
        :: detectsUpdate()
        :: detectsWith()
        :: parsesNamedParam()
        :: parseSQLVariableAssignment()
        :: parsesQuestionMarkParam()
    - - :: insertAndSelectBlobWhileStreamingItsContent()
    - - :: timeoutsQuery()
- - - - Required Libraries
      - Column types
        
        None
        
        Inline
      - Connection
        
        Host
        
        Port
        
        User
        
        Password
        
        Database
      - Use Cases
        
        MySqlNegativeConnectivityTestCase
        
        :: mySqlConfigInvalidCredentials()
        :: mySqlConfigInvalidDatabaseName()
        :: mySqlConfigInvalidHost()
        :: mySqlConfigInvalidSocketTimeoutValue()
    - - Pooling profile
        
        None
        
        Inline
        
        Max pool size
        
        Min pool size
        
        Acquire increment
        
        Prepared statement cache size
        
        Max wait
        
        Max wait unit
        
        SECONDS
        
        ...
      - Connection
        
        Connection properties
        
        None
        
        Expression
        
        Inline
        
        Reconnection Strategy
        
        None
        
        Standard
        
        Run the reconnection in a separated thread
        
        Frequency
        
        Reconnection Attempts
        
        Forever
        
        Run the reconnection in a separated thread
        
        Frequency
    - - Transaction isolation
        
        NONE
        
        NOT_CONFIGURED
        
        READ_COMMITED
        
        READ_UNCOMMITED
        
        REPEATABLE_READ
        
        SERIALIZABLE
      - Use XA Transactions
  - - - Required Libraries
      - Column types
        
        None
        
        Inline
      - Connection
        
        Host
        
        Port
        
        User
        
        Password
        
        Instance
      - Use Cases
        
        MissingDriverNegativeTestCase
        
        :: oracleMissingDriver()
        
        OracleNegativeConnectivityTestCase
        
        :: oracleConfigInvalidCredentials()
        :: oracleConfigUnknownHost()
        :: oracleConfigUnknownInstance()
    - - Pooling profile
        
        None
        
        Inline
        
        Max pool size
        
        Min pool size
        
        Acquire increment
        
        Prepared statement cache size
        
        Max wait
        
        Max wait unit
        
        SECONDS
        
        ...
      - Connection
        
        Connection properties
        
        None
        
        Expression
        
        Inline
        
        Reconnection Strategy
        
        None
        
        Standard
        
        Run the reconnection in a separated thread
        
        Frequency
        
        Reconnection Attempts
        
        Forever
        
        Run the reconnection in a separated thread
        
        Frequency
    - - Transaction isolation
        
        NONE
        
        NOT_CONFIGURED
        
        READ_COMMITED
        
        READ_UNCOMMITED
        
        REPEATABLE_READ
        
        SERIALIZABLE
      - Use XA Transactions
  - - - Column types
        
        None
        
        Inline
      - Connection
        
        URL
        
        Driver class name
      - Use Cases
        
        MissingDriverNegativeTestCase
        
        :: genericDriverMissingClass()
        :: oracleMissingDriver()
    - - Pooling profile
        
        None
        
        Inline
        
        Max pool size
        
        Min pool size
        
        Acquire increment
        
        Prepared statement cache size
        
        Max wait
        
        Max wait unit
        
        SECONDS
        
        ...
      - Connection
        
        Connection properties
        
        None
        
        Expression
        
        Inline
        
        Reconnection Strategy
        
        None
        
        Standard
        
        Run the reconnection in a separated thread
        
        Frequency
        
        Reconnection Attempts
        
        Forever
        
        Run the reconnection in a separated thread
        
        Frequency
    - - Transaction isolation
        
        NONE
        
        NOT_CONFIGURED
        
        READ_COMMITED
        
        READ_UNCOMMITED
        
        REPEATABLE_READ
        
        SERIALIZABLE
      - Use XA Transactions
  - - - Required Libraries
      - Column types
        
        None
        
        Inline
      - Connection
        
        Database
        
        Subsub protocol
        
        Create
        
        False
        
        True
        
        Expression
        
        Expression
      - Use Cases
        
        DerbyNegativeConnectivityTestCase
        
        :: derbyConfigDatabaseNotFound()
        :: derbyConfigDbFromJarNotFound()
    - - Pooling profile
        
        None
        
        Inline
        
        Max pool size
        
        Min pool size
        
        Acquire increment
        
        Prepared statement cache size
        
        Max wait
        
        Max wait unit
        
        SECONDS
        
        ...
        
        Use Cases
        
        StalePooledConnectionResetTestCase
        
        :: resetsStalePooledConnection
      - Connection
        
        Connection properties
        
        None
        
        Expression
        
        Inline
        
        Reconnection Strategy
        
        None
        
        Standard
        
        Run the reconnection in a separated thread
        
        Frequency
        
        Reconnection Attempts
        
        Forever
        
        Run the reconnection in a separated thread
        
        Frequency
    - - Transaction isolation
        
        NONE
        
        NOT_CONFIGURED
        
        READ_COMMITED
        
        READ_UNCOMMITED
        
        REPEATABLE_READ
        
        SERIALIZABLE
      - Use XA Transactions
  - - - Column types
        
        None
        
        Inline
      - Connection
        
        Data source ref
    - - Pooling profile
        
        Inline
        
        Max pool size
        
        Min pool size
        
        Acquire increment
        
        Prepared statement cache size
        
        Max wait
        
        Max wait unit
        
        SECONDS
        
        ...
        
        None
        
        Use Cases
        
        DataSourcePoolingTestCase
        
        :: connectionsGoBackToThePool()
        :: limitsConnections()
        :: providesMultipleConnections()
        :: waitForever()
        
        StalePooledConnectionResetTestCase
        
        :: resetsStalePooledConnection
      - Connection
        
        Reconnection Strategy
        
        None
        
        Standard
        
        Run the reconnection in a separated thread
        
        Frequency
        
        Reconnection Attempts
        
        Forever
        
        Run the reconnection in a separated thread
        
        Frequency