[#DERBY-3690] EmbedPooledConnection doesn't reset schema when creating a new logical connection

Derby

EmbedPooledConnection doesn't reset schema when creating a new logical connection

Created: 23/May/08 11:17 AM Updated: 04/May/09 06:22 PM

Return to search

Component/s:

JDBC

Affects Version/s:

10.1.1.0, 10.2.1.6, 10.3.1.4, 10.4.1.3

Fix Version/s:

10.4.2.0, 10.5.1.1

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
derby-3690-1a-reset_schema.diff	2008-05-26 12:44 PM	Kristian Waagan	7 kB
derby-3690-1b-reset_schema.diff	2008-05-27 06:51 AM	Kristian Waagan	7 kB
PooledSchema.java	2008-05-23 11:27 AM	Knut Anders Hatlen	1 kB

Issue Links:

Reference

This issue relates to:

~~DERBY-3859~~ Reset the current role when EmbedPooledConnection creates a new logical connection

~~DERBY-3692~~ 'javax.transaction.xa.XAException' ++ in 'J2EEDataSourceTest'

dependent

This issue depends upon:

~~DERBY-1331~~ Derby's "set schema" behavior is not compliant with SQL 2003 Foundation spec.

~~DERBY-3327~~ SQL roles: Implement authorization stack (and SQL session context to hold it)

Resolution Date:

03/Jun/08 12:46 PM

Description

« Hide

If you set the schema on a logical connection obtained from EmbedPooledConnection, that schema will also be the current schema for subsequent logical connections obtained from the same EmbedPooledConnection.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Repository	Revision	Date	User	Message
ASF	#660404	Tue May 27 06:50:25 UTC 2008	kristwaa	~~DERBY-3690~~: EmbedPooledConnection doesn't reset schema when creating a new logical connection. Fixes the bug by resetting the schema in GLCC.resetFromPool, and adds two regression tests. Patch file: ~~DERBY-3690~~-1b-reset_schema.diff
				Files Changed
				MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/conn/GenericLanguageConnectionContext.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/J2EEDataSourceTest.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/junit/JDBC.java

Repository	Revision	Date	User	Message
ASF	#660408	Tue May 27 07:00:10 UTC 2008	kristwaa	~~DERBY-3690~~: EmbedPooledConnection doesn't reset schema when creating a new logical connection. Merged revision 660404 (~~DERBY-3690~~-1b-reset_schema.diff) from trunk.
				Files Changed
				MODIFY /db/derby/code/branches/10.4/java/engine/org/apache/derby/impl/sql/conn/GenericLanguageConnectionContext.java MODIFY /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/J2EEDataSourceTest.java MODIFY /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/junit/JDBC.java

Repository	Revision	Date	User	Message
ASF	#662416	Mon Jun 02 12:45:35 UTC 2008	kristwaa	~~DERBY-3327~~ / ~~DERBY-3690~~: Made GLCC cache the initial default schema descriptor. This fix is an excerpt from issue 3327, and the code was extracted from the '4-full-e' patch. The relevant commit on trunk is revision 643920. Patch file: ~~DERBY-3327~~-5a-extracted_initial_schema_patch.diff Patch was extracted from a patch contributed by Dag H. Wanvik.
				Files Changed
				MODIFY /db/derby/code/branches/10.4/java/engine/org/apache/derby/impl/sql/conn/GenericLanguageConnectionContext.java

Repository	Revision	Date	User	Message
ASF	#666164	Tue Jun 10 15:42:36 UTC 2008	kristwaa	~~DERBY-3690~~ / ~~DERBY-3327~~: Removed unwarranted assert. This is a manual backport of revision 662911.
				Files Changed
				MODIFY /db/derby/code/branches/10.4/java/engine/org/apache/derby/impl/sql/conn/GenericLanguageConnectionContext.java