You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2006/03/21 21:49:06 UTC

[jira] Created: (DERBY-1134) Add a test to test that client connection state is set properly and matches server behaviour for different types of connections.

Add a test to test that client connection state is set properly and matches server behaviour for different types of connections.
--------------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-1134
         URL: http://issues.apache.org/jira/browse/DERBY-1134
     Project: Derby
        Type: Test
  Components: Test  
    Versions: 10.2.0.0    
    Reporter: Kathey Marsden


We have seen many bugs where the client connection state is not correct and/or does not match the server.  e.g DERBY-1044.  It would be good to add a test to test that client connection state is set properly and matches server behaviour for different types of connections.

 
State to check
holdability
autocommit
transactionIsolation


Types of Connections
Connections obtained from Driver Manager
Connections obtained from regular DataSource
Connections obtained from PooledConnections 
	- on initial connection.
	- after physical connection reset with getConnection()
Connections obtained from XAConnections
	- PooledConnection tests above, but in addition check
		-in local transaction
		- after transitioning to a global transaction
		- after transitioning  back to local transaction.


For savepoints I added savepointJdbc30_XA.java that extends savepointJdbc30_JSR169 to add in testing for a different type of connection. I don't know if this is the right way to go to test different kinds of connections, for example a similar extension of setTransactionIsolation.java might be one way of testing isolation levels for the different types of connections.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-1134) Add a test to test that client connection state is set properly and matches server behaviour for different types of connections.

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-1134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-1134:
---------------------------------

    Issue Type: Improvement  (was: Test)

> Add a test to test that client connection state is set properly and matches server behaviour for different types of connections.
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1134
>                 URL: https://issues.apache.org/jira/browse/DERBY-1134
>             Project: Derby
>          Issue Type: Improvement
>          Components: Test
>    Affects Versions: 10.2.1.6
>            Reporter: Kathey Marsden
>
> We have seen many bugs where the client connection state is not correct and/or does not match the server.  e.g DERBY-1044.  It would be good to add a test to test that client connection state is set properly and matches server behaviour for different types of connections.
>  
> State to check
> holdability
> autocommit
> transactionIsolation
> Types of Connections
> Connections obtained from Driver Manager
> Connections obtained from regular DataSource
> Connections obtained from PooledConnections 
> 	- on initial connection.
> 	- after physical connection reset with getConnection()
> Connections obtained from XAConnections
> 	- PooledConnection tests above, but in addition check
> 		-in local transaction
> 		- after transitioning to a global transaction
> 		- after transitioning  back to local transaction.
> For savepoints I added savepointJdbc30_XA.java that extends savepointJdbc30_JSR169 to add in testing for a different type of connection. I don't know if this is the right way to go to test different kinds of connections, for example a similar extension of setTransactionIsolation.java might be one way of testing isolation levels for the different types of connections.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.