Issue Details (XML | Word | Printable)

Key: DERBY-1585
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Daniel John Debrunner
Reporter: Henri van de Scheur
Votes: 2
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Derby

derbylang/procedureInTrigger: not able to create trigger due to an open ResultSet

Created: 25/Jul/06 08:54 AM   Updated: 25/Jan/08 02:39 PM
Return to search
Component/s: SQL
Affects Version/s: 10.2.1.6
Fix Version/s: 10.3.3.0, 10.4.1.3

Time Tracking:
Not Specified

File Attachments:
  File Name Date Attached Attached By Size
File Licensed for inclusion in ASF works close.diff 2007-04-19 10:54 PM Knut Anders Hatlen 2 kB
Text File Licensed for inclusion in ASF works derby1585_diff.txt 2007-12-05 10:38 PM Daniel John Debrunner 9 kB
Text File Licensed for inclusion in ASF works derby1585_diff_v2.txt 2007-12-06 06:08 PM Daniel John Debrunner 14 kB
File Licensed for inclusion in ASF works derby1585_v1.diff 2006-09-08 10:52 PM Deepa Remesh 41 kB
File Licensed for inclusion in ASF works derby1585_v1.status 2006-09-08 10:52 PM Deepa Remesh 0.4 kB
Java Source File Licensed for inclusion in ASF works Main.java 2008-01-08 03:59 PM Dag H. Wanvik 3 kB
Environment:
------------------ Java Information ------------------
Java Version: 1.6.0-rc
Java Vendor: Sun Microsystems Inc.
Java home: /usr/local/java/jdk1.6.0_b91/jre
Java classpath:
test/junit.jar:test/dbprocedures.jar:test/jmxremote.jar:test/javadbtests.jar: test/Dots.jar:test/mail.jar:test/activation.jar:test/Perfmon.jar: test/jakarta-oro-2.0.8.jar:test/commons-logging.jar:test/jagops.jar: test/jdmkrt.jar:test/db2jcc_license_c.jar:test/jet.jar:test/jetbatch.jar: test/db2jcc.jar:test/jag.jar:test/jagclient.jar:test/jagutils.jar:test/GenCfg.jar: test/jmxremote_optional.jar:test/jmx.jar:test/hadbjdbc4.jar:derbyTesting.jar: derby.jar:derbyLocale_zh_TW.jar:derbytools.jar:derbyLocale_ko_KR.jar: derbyLocale_zh_CN.jar:derbyLocale_es.jar:derbyLocale_de_DE.jar:derbyLocale_ja_JP.jar: derbynet.jar:derbyLocale_pt_BR.jar:derbyclient.jar:derbyLocale_fr.jar:derbyrun.jar: derbyLocale_it.jar:

OS name: Linux
OS architecture: i386
OS version: 2.6.9-34.ELsmp
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derby.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbytools.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbynet.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyclient.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc_license_c.jar] 2.4 - (17)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [de_DE]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [es]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [fr]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [it]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [ja_JP]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [ko_KR]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [pt_BR]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [zh_CN]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [zh_TW]
version: 10.2.0.4 alpha - (423199)
------------------------------------------------------
Issue Links:
Reference
 

Urgency: Normal
Resolution Date: 11/Jan/08 08:01 PM


 Description  « Hide
********* Diff file derbyall/derbylang/procedureInTrigger.diff
*** Start: procedureInTrigger jdk1.6.0-rc derbyall:derbylang 2006-07-19 13:52:20 ***
714a715,730
> ERROR X0X95: Operation 'CREATE TRIGGER' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object.
> ij> --- delete a row. check that trigger is fired - procedure should be called once
> delete from t1 where i=10;
> 1 row inserted/updated/deleted
> ij> --- check delete is successful
> select * from t1;
> I |B
> ---------------------------
> 5 |two
> 6 |four
> 8 |eight
> ij> drop trigger select_from_trig_table;
> ERROR 42X94: TRIGGER 'SELECT_FROM_TRIG_TABLE' does not exist.
> ij> --- use procedures which alter/drop trigger table and some other table
> create trigger alter_table_trig AFTER delete on t1
> for each STATEMENT mode db2sql call alter_table_proc();
716,732d731
< ij> --- delete a row. check that trigger is fired - procedure should be called once
< delete from t1 where i=10;
< selectRows - 1 arg - 1 rs
< 1 row inserted/updated/deleted
< ij> --- check delete is successful
< select * from t1;
< I |B
< ---------------------------
< 5 |two
< 6 |four
< 8 |eight
< ij> drop trigger select_from_trig_table;
< 0 rows inserted/updated/deleted
< ij> --- use procedures which alter/drop trigger table and some other table
< create trigger alter_table_trig AFTER delete on t1
< for each STATEMENT mode db2sql call alter_table_proc();
< 0 rows inserted/updated/deleted
Test Failed.
*** End: procedureInTrigger jdk1.6.0-rc derbyall:derbylang 2006-07-19 13:52:34 ***

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Kathey Marsden made changes - 27/Jul/06 04:49 AM
Field Original Value New Value
Description
********* Diff file derbyall/derbylang/procedureInTrigger.diff
*** Start: procedureInTrigger jdk1.6.0-rc derbyall:derbylang 2006-07-19 13:52:20 ***
714a715,730
> ERROR X0X95: Operation 'CREATE TRIGGER' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object.
> ij> --- delete a row. check that trigger is fired - procedure should be called once
> delete from t1 where i=10;
> 1 row inserted/updated/deleted
> ij> --- check delete is successful
> select * from t1;
> I |B
> ---------------------------
> 5 |two
> 6 |four
> 8 |eight
> ij> drop trigger select_from_trig_table;
> ERROR 42X94: TRIGGER 'SELECT_FROM_TRIG_TABLE' does not exist.
> ij> --- use procedures which alter/drop trigger table and some other table
> create trigger alter_table_trig AFTER delete on t1
> for each STATEMENT mode db2sql call alter_table_proc();
716,732d731
< ij> --- delete a row. check that trigger is fired - procedure should be called once
< delete from t1 where i=10;
< selectRows - 1 arg - 1 rs
< 1 row inserted/updated/deleted
< ij> --- check delete is successful
< select * from t1;
< I |B
< ---------------------------
< 5 |two
< 6 |four
< 8 |eight
< ij> drop trigger select_from_trig_table;
< 0 rows inserted/updated/deleted
< ij> --- use procedures which alter/drop trigger table and some other table
< create trigger alter_table_trig AFTER delete on t1
< for each STATEMENT mode db2sql call alter_table_proc();
< 0 rows inserted/updated/deleted
Test Failed.
*** End: procedureInTrigger jdk1.6.0-rc derbyall:derbylang 2006-07-19 13:52:34 *** 		********* Diff file derbyall/derbylang/procedureInTrigger.diff
*** Start: procedureInTrigger jdk1.6.0-rc derbyall:derbylang 2006-07-19 13:52:20 ***
714a715,730
> ERROR X0X95: Operation 'CREATE TRIGGER' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object.
> ij> --- delete a row. check that trigger is fired - procedure should be called once
> delete from t1 where i=10;
> 1 row inserted/updated/deleted
> ij> --- check delete is successful
> select * from t1;
> I |B
> ---------------------------
> 5 |two
> 6 |four
> 8 |eight
> ij> drop trigger select_from_trig_table;
> ERROR 42X94: TRIGGER 'SELECT_FROM_TRIG_TABLE' does not exist.
> ij> --- use procedures which alter/drop trigger table and some other table
> create trigger alter_table_trig AFTER delete on t1
> for each STATEMENT mode db2sql call alter_table_proc();
716,732d731
< ij> --- delete a row. check that trigger is fired - procedure should be called once
< delete from t1 where i=10;
< selectRows - 1 arg - 1 rs
< 1 row inserted/updated/deleted
< ij> --- check delete is successful
< select * from t1;
< I |B
< ---------------------------
< 5 |two
< 6 |four
< 8 |eight
< ij> drop trigger select_from_trig_table;
< 0 rows inserted/updated/deleted
< ij> --- use procedures which alter/drop trigger table and some other table
< create trigger alter_table_trig AFTER delete on t1
< for each STATEMENT mode db2sql call alter_table_proc();
< 0 rows inserted/updated/deleted
Test Failed.
*** End: procedureInTrigger jdk1.6.0-rc derbyall:derbylang 2006-07-19 13:52:34 ***
Component/s Test [ 11413 ]
Deepa Remesh made changes - 28/Jul/06 07:31 PM
Assignee Deepa Remesh [ deepa ]
Kathey Marsden made changes - 29/Jul/06 12:02 AM
Component/s Regression Test Failure [ 12310664 ]
Fix Version/s 10.2.0.0 [ 11187 ]
Urgency Normal
Deepa Remesh made changes - 08/Sep/06 10:52 PM
Attachment derby1585_v1.diff [ 12340485 ]
Attachment derby1585_v1.status [ 12340486 ]
Rick Hillegas made changes - 19/Sep/06 02:42 PM
Fix Version/s 10.2.2.0 [ 12312027 ]
Fix Version/s 10.2.1.0 [ 11187 ]
Deepa Remesh made changes - 01/Dec/06 03:47 PM
Assignee Deepa Remesh [ deepa ]
Rick Hillegas made changes - 06/Dec/06 02:37 PM
Fix Version/s 10.2.3.0 [ 12312215 ]
Fix Version/s 10.2.2.0 [ 12312027 ]
Andrew McIntyre made changes - 25/Jan/07 08:36 PM
Fix Version/s 10.2.3.0 [ 12312215 ]
Knut Anders Hatlen made changes - 19/Apr/07 10:54 PM
Attachment close.diff [ 12355869 ]
Kristian Waagan made changes - 20/Apr/07 08:29 AM
Environment ------------------ Java Information ------------------
Java Version: 1.6.0-rc
Java Vendor: Sun Microsystems Inc.
Java home: /usr/local/java/jdk1.6.0_b91/jre
Java classpath: /export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/junit.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/dbprocedures.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jmxremote.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/javadbtests.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/Dots.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/mail.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/activation.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/Perfmon.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jakarta-oro-2.0.8.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/commons-logging.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jagops.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jdmkrt.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc_license_c.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jet.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jetbatch.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jag.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jagclient.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jagutils.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/GenCfg.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jmxremote_optional.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/jmx.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/hadbjdbc4.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyTesting.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derby.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_zh_TW.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbytools.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_ko_KR.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_zh_CN.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_es.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_de_DE.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_ja_JP.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbynet.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_pt_BR.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyclient.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_fr.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyrun.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_it.jar:
OS name: Linux
OS architecture: i386
OS version: 2.6.9-34.ELsmp
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derby.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbytools.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbynet.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyclient.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc_license_c.jar] 2.4 - (17)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [de_DE]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [es]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [fr]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [it]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [ja_JP]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [ko_KR]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [pt_BR]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [zh_CN]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [zh_TW]
version: 10.2.0.4 alpha - (423199)
------------------------------------------------------ 		------------------ Java Information ------------------
Java Version: 1.6.0-rc
Java Vendor: Sun Microsystems Inc.
Java home: /usr/local/java/jdk1.6.0_b91/jre
Java classpath:
test/junit.jar:test/dbprocedures.jar:test/jmxremote.jar:test/javadbtests.jar: test/Dots.jar:test/mail.jar:test/activation.jar:test/Perfmon.jar: test/jakarta-oro-2.0.8.jar:test/commons-logging.jar:test/jagops.jar: test/jdmkrt.jar:test/db2jcc_license_c.jar:test/jet.jar:test/jetbatch.jar: test/db2jcc.jar:test/jag.jar:test/jagclient.jar:test/jagutils.jar:test/GenCfg.jar: test/jmxremote_optional.jar:test/jmx.jar:test/hadbjdbc4.jar:derbyTesting.jar: derby.jar:derbyLocale_zh_TW.jar:derbytools.jar:derbyLocale_ko_KR.jar: derbyLocale_zh_CN.jar:derbyLocale_es.jar:derbyLocale_de_DE.jar:derbyLocale_ja_JP.jar: derbynet.jar:derbyLocale_pt_BR.jar:derbyclient.jar:derbyLocale_fr.jar:derbyrun.jar: derbyLocale_it.jar:

OS name: Linux
OS architecture: i386
OS version: 2.6.9-34.ELsmp
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derby.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbytools.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbynet.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyclient.jar] 10.2.0.4 alpha - (423199)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc_license_c.jar] 2.4 - (17)
[/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [de_DE]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [es]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [fr]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [it]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [ja_JP]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [ko_KR]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [pt_BR]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [zh_CN]
version: 10.2.0.4 alpha - (423199)
Found support for locale: [zh_TW]
version: 10.2.0.4 alpha - (423199)
------------------------------------------------------
Dag H. Wanvik made changes - 25/Apr/07 12:13 AM
Link This issue is related to DERBY-1947 [ DERBY-1947 ]
Daniel John Debrunner made changes - 03/Dec/07 10:52 PM
Component/s Regression Test Failure [ 12310664 ]
Component/s Test [ 11413 ]
Component/s SQL [ 11408 ]
Daniel John Debrunner made changes - 04/Dec/07 06:06 PM
Assignee Daniel John Debrunner [ djd ]
Daniel John Debrunner made changes - 05/Dec/07 10:38 PM
Attachment derby1585_diff.txt [ 12371076 ]
Daniel John Debrunner made changes - 05/Dec/07 10:39 PM
Derby Info [Patch Available]
Daniel John Debrunner made changes - 06/Dec/07 06:08 PM
Attachment derby1585_diff_v2.txt [ 12371154 ]
Daniel John Debrunner made changes - 10/Dec/07 06:47 PM
Resolution Fixed [ 1 ]
Fix Version/s 10.4.0.0 [ 12312540 ]
Derby Info [Patch Available]
Status Open [ 1 ] Resolved [ 5 ]
Dag H. Wanvik made changes - 08/Jan/08 03:59 PM
Attachment Main.java [ 12372720 ]
Dag H. Wanvik made changes - 08/Jan/08 04:00 PM
Status Resolved [ 5 ] Reopened [ 4 ]
Resolution Fixed [ 1 ]
Daniel John Debrunner made changes - 08/Jan/08 04:24 PM
Resolution Fixed [ 1 ]
Status Reopened [ 4 ] Closed [ 6 ]
Daniel John Debrunner made changes - 11/Jan/08 07:58 PM
Status Closed [ 6 ] Reopened [ 4 ]
Resolution Fixed [ 1 ]
Daniel John Debrunner made changes - 11/Jan/08 08:01 PM
Status Reopened [ 4 ] Resolved [ 5 ]
Fix Version/s 10.3.2.2 [ 12312885 ]
Resolution Fixed [ 1 ]
Henri van de Scheur made changes - 25/Jan/08 02:39 PM
Status Resolved [ 5 ] Closed [ 6 ]

Powered by a free Atlassian JIRA open source license for Apache Software Foundation. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators