Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 40663 invoked from network); 20 Apr 2007 08:31:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Apr 2007 08:31:37 -0000 Received: (qmail 73119 invoked by uid 500); 20 Apr 2007 08:31:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 73084 invoked by uid 500); 20 Apr 2007 08:31:43 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 73068 invoked by uid 99); 20 Apr 2007 08:31:43 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Apr 2007 01:31:42 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Apr 2007 01:31:35 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 6AA70714071 for ; Fri, 20 Apr 2007 01:31:15 -0700 (PDT) Message-ID: <853069.1177057875417.JavaMail.jira@brutus> Date: Fri, 20 Apr 2007 01:31:15 -0700 (PDT) From: "Kristian Waagan (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-1585) derbylang/procedureInTrigger: not able to create trigger due to an open ResultSet In-Reply-To: <30697051.1153817713829.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-1585?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristian Waagan updated DERBY-1585: ----------------------------------- Environment:=20 ------------------ 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: =20 test/junit.jar:test/dbprocedures.jar:test/jmxremote.jar:test/javadbtests.ja= r: test/Dots.jar:test/mail.jar:test/activation.jar:test/Perfmon.jar: test/j= akarta-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.j= ar:test/jag.jar:test/jagclient.jar:test/jagutils.jar:test/GenCfg.jar: test/= jmxremote_optional.jar:test/jmx.jar:test/hadbjdbc4.jar:derbyTesting.jar: de= rby.jar:derbyLocale_zh_TW.jar:derbytools.jar:derbyLocale_ko_KR.jar: derbyLo= cale_zh_CN.jar:derbyLocale_es.jar:derbyLocale_de_DE.jar:derbyLocale_ja_JP.j= ar: derbynet.jar:derbyLocale_pt_BR.jar:derbyclient.jar:derbyLocale_fr.jar:d= erbyrun.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_lice= nse_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] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [es] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [fr] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [it] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [ja_JP] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [ko_KR] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [pt_BR] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [zh_CN] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [zh_TW] =09 version: 10.2.0.4 alpha - (423199) ------------------------------------------------------ was: ------------------ 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/te= st/dbprocedures.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/l= ib/test/jmxremote.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install= /lib/test/javadbtests.jar:/export/home/tmp/jagtmp/autoderbyN_regression/ins= tall/lib/test/Dots.jar:/export/home/tmp/jagtmp/autoderbyN_regression/instal= l/lib/test/mail.jar:/export/home/tmp/jagtmp/autoderbyN_regression/install/l= ib/test/activation.jar:/export/home/tmp/jagtmp/autoderbyN_regression/instal= l/lib/test/Perfmon.jar:/export/home/tmp/jagtmp/autoderbyN_regression/instal= l/lib/test/jakarta-oro-2.0.8.jar:/export/home/tmp/jagtmp/autoderbyN_regress= ion/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_r= egression/install/lib/test/db2jcc_license_c.jar:/export/home/tmp/jagtmp/aut= oderbyN_regression/install/lib/test/jet.jar:/export/home/tmp/jagtmp/autoder= byN_regression/install/lib/test/jetbatch.jar:/export/home/tmp/jagtmp/autode= rbyN_regression/install/lib/test/db2jcc.jar:/export/home/tmp/jagtmp/autoder= byN_regression/install/lib/test/jag.jar:/export/home/tmp/jagtmp/autoderbyN_= regression/install/lib/test/jagclient.jar:/export/home/tmp/jagtmp/autoderby= N_regression/install/lib/test/jagutils.jar:/export/home/tmp/jagtmp/autoderb= yN_regression/install/lib/test/GenCfg.jar:/export/home/tmp/jagtmp/autoderby= N_regression/install/lib/test/jmxremote_optional.jar:/export/home/tmp/jagtm= p/autoderbyN_regression/install/lib/test/jmx.jar:/export/home/tmp/jagtmp/au= toderbyN_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/autoder= byN_regression/install/lib/derbyLocale_zh_TW.jar:/export/home/tmp/jagtmp/au= toderbyN_regression/install/lib/derbytools.jar:/export/home/tmp/jagtmp/auto= derbyN_regression/install/lib/derbyLocale_ko_KR.jar:/export/home/tmp/jagtmp= /autoderbyN_regression/install/lib/derbyLocale_zh_CN.jar:/export/home/tmp/j= agtmp/autoderbyN_regression/install/lib/derbyLocale_es.jar:/export/home/tmp= /jagtmp/autoderbyN_regression/install/lib/derbyLocale_de_DE.jar:/export/hom= e/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_ja_JP.jar:/expor= t/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbynet.jar:/export/ho= me/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_pt_BR.jar:/expo= rt/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyclient.jar:/expor= t/home/tmp/jagtmp/autoderbyN_regression/install/lib/derbyLocale_fr.jar:/exp= ort/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_lice= nse_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] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [es] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [fr] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [it] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [ja_JP] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [ko_KR] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [pt_BR] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [zh_CN] =09 version: 10.2.0.4 alpha - (423199) Found support for locale: [zh_TW] =09 version: 10.2.0.4 alpha - (423199) ------------------------------------------------------ There were problems with the line-breaking in the environment field. I remo= ved the prefix '/export/home/tmp/jagtmp/autoderbyN_regression/install/lib' = from the Java classpath and broke the lines manually. > derbylang/procedureInTrigger: not able to create trigger due to an open R= esultSet > -------------------------------------------------------------------------= -------- > > Key: DERBY-1585 > URL: https://issues.apache.org/jira/browse/DERBY-1585 > Project: Derby > Issue Type: Bug > Components: Regression Test Failure, Test > Affects Versions: 10.2.1.6 > 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: =20 > 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/jdmkr= t.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: tes= t/jmxremote_optional.jar:test/jmx.jar:test/hadbjdbc4.jar:derbyTesting.jar: = derby.jar:derbyLocale_zh_TW.jar:derbytools.jar:derbyLocale_ko_KR.jar: derby= Locale_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.ja= r] 10.2.0.4 alpha - (423199) > [/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc_li= cense_c.jar] 2.4 - (17) > [/export/home/tmp/jagtmp/autoderbyN_regression/install/lib/test/db2jcc.ja= r] 2.4 - (17) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > Current Locale : [English/United States [en_US]] > Found support for locale: [de_DE] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [es] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [fr] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [it] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [ja_JP] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [ko_KR] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [pt_BR] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [zh_CN] > =09 version: 10.2.0.4 alpha - (423199) > Found support for locale: [zh_TW] > =09 version: 10.2.0.4 alpha - (423199) > ------------------------------------------------------ > Reporter: Henri van de Scheur > Attachments: close.diff, derby1585_v1.diff, derby1585_v1.status > > > ********* Diff file derbyall/derbylang/procedureInTrigger.diff > *** Start: procedureInTrigger jdk1.6.0-rc derbyall:derbylang 2006-07-19 1= 3: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=3D10; > > 1 row inserted/updated/deleted > > ij> --- check delete is successful > > select * from t1; > > I |B =20 > > --------------------------- > > 5 |two =20 > > 6 |four =20 > > 8 |eight =20 > > 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 ta= ble > > create trigger alter_table_trig AFTER delete on t1=20 > > =09for 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=3D10; > < selectRows - 1 arg - 1 rs > < 1 row inserted/updated/deleted > < ij> --- check delete is successful > < select * from t1; > < I |B =20 > < --------------------------- > < 5 |two =20 > < 6 |four =20 > < 8 |eight =20 > < ij> drop trigger select_from_trig_table; > < 0 rows inserted/updated/deleted > < ij> --- use procedures which alter/drop trigger table and some other ta= ble > < create trigger alter_table_trig AFTER delete on t1=20 > < =09for 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 1= 3:52:34 *** --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.