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 "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2006/11/18 20:10:38 UTC
[jira] Commented: (DERBY-1850) Test jdbcapi/SURTest_ij.sql fails
on IBM WCTME 5.7 Foundation (jdkJ2ME Foundation Specification v1.0)
[ http://issues.apache.org/jira/browse/DERBY-1850?page=comments#action_12451054 ]
Myrna van Lunteren commented on DERBY-1850:
-------------------------------------------
fixed in trunk by commit http://svn.apache.org/viewvc?view=rev&revision=476588:
- added the required ij.dataSource settings
- added sedding of first CONNECTION line, to avoid extra master
M java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/SURTest_ij_app.properties
AM java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/SURTest_ij_sed.properties
> Test jdbcapi/SURTest_ij.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME Foundation Specification v1.0)
> -------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1850
> URL: http://issues.apache.org/jira/browse/DERBY-1850
> Project: Derby
> Issue Type: Test
> Components: Test
> Affects Versions: 10.3.0.0, 10.2.1.8
> Environment: Windows
> Reporter: Rajesh Kartha
> Assigned To: Myrna van Lunteren
>
> The diff for the test is:
> *** Start: SURTest_ij jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2006-09-10 12:51:18 ***
> 1 del
> < CONNECTION0* - jdbc:derby:SURTest
> 2 del
> < * = current connection
> 2a1
> > java.lang.reflect.InvocationTargetException: java.lang.NullPointerException
> 4 del
> < WARNING 01J01: Database 'SURTest' not created, connection made to existing database instead.
> 5 del
> < ij(CONNECTION1)> autocommit off;
> 6 del
> < ij(CONNECTION1)> create table t1 (c1 int primary key, c2 int);
> 6a3,4
> > ij> autocommit off;
> > ij> create table t1 (c1 int primary key, c2 int);
> 8 del
> < ij(CONNECTION1)> insert into t1 values
> 8a6
> > ij> insert into t1 values
> 12 del
> < ij(CONNECTION1)> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
> 13 del
> < ij(CONNECTION1)> next sc1;
> 13a10,11
> > ij> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
> > ij> next sc1;
> 17 del
> < ij(CONNECTION1)> next sc1;
> 17a15
> > ij> next sc1;
> 21 del
> < ij(CONNECTION1)> -- update row nr. 2 after positioning with next
> 21a19
> > ij> -- update row nr. 2 after positioning with next
> 24 del
> < ij(CONNECTION1)> absolute 5 sc1;
> 24a22
> > ij> absolute 5 sc1;
> 28 del
> < ij(CONNECTION1)> -- update row nr. 5 after positioning with absolute
> 28a26
> > ij> -- update row nr. 5 after positioning with absolute
> 31 del
> < ij(CONNECTION1)> relative 2 sc1;
> 31a29
> > ij> relative 2 sc1;
> 35 del
> < ij(CONNECTION1)> -- update row nr. 7 after positioning with relative
> 35a33
> > ij> -- update row nr. 7 after positioning with relative
> 38 del
> < ij(CONNECTION1)> previous sc1;
> 38a36
> > ij> previous sc1;
> 42 del
> < ij(CONNECTION1)> -- update row nr. 6 after positioning with previous
> 42a40
> > ij> -- update row nr. 6 after positioning with previous
> 45 del
> < ij(CONNECTION1)> relative -1 sc1;
> 45a43
> > ij> relative -1 sc1;
> 49 del
> < ij(CONNECTION1)> last sc1;
> 49a47
> > ij> last sc1;
> 53 del
> < ij(CONNECTION1)> -- update row nr. 10 after positioning with last
> 53a51
> > ij> -- update row nr. 10 after positioning with last
> 56 del
> < ij(CONNECTION1)> after last sc1;
> 56a54
> > ij> after last sc1;
> 58 del
> < ij(CONNECTION1)> -- update when positioned after last should cause an error
> 58a56
> > ij> -- update when positioned after last should cause an error
> 61 del
> < ij(CONNECTION1)> first sc1;
> 61a59
> > ij> first sc1;
> 65 del
> < ij(CONNECTION1)> -- update row nr. 1 after positioning with first
> 65a63
> > ij> -- update row nr. 1 after positioning with first
> 68 del
> < ij(CONNECTION1)> before first sc1;
> 68a66
> > ij> before first sc1;
> 70 del
> < ij(CONNECTION1)> -- update when positioned before first should cause an error
> 70a68
> > ij> -- update when positioned before first should cause an error
> 73 del
> < ij(CONNECTION1)> close sc1;
> 74 del
> < ij(CONNECTION1)> commit;
> 75 del
> < ij(CONNECTION1)> -- check that row where correctly updated
> 75a71,73
> > ij> close sc1;
> > ij> commit;
> > ij> -- check that row where correctly updated
> 90 del
> < ij(CONNECTION1)> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
> 91 del
> < ij(CONNECTION1)> next sc1;
> 91a88,89
> > ij> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE';
> > ij> next sc1;
> 95 del
> < ij(CONNECTION1)> next sc1;
> 95a93
> > ij> next sc1;
> 99 del
> < ij(CONNECTION1)> -- delete row nr. 2 after positioning with next
> 99a97
> > ij> -- delete row nr. 2 after positioning with next
> 102 del
> < ij(CONNECTION1)> absolute 5 sc1;
> 102a100
> > ij> absolute 5 sc1;
> 106 del
> < ij(CONNECTION1)> -- delete row nr. 5 after positioning with absolute
> 106a104
> > ij> -- delete row nr. 5 after positioning with absolute
> 109 del
> < ij(CONNECTION1)> relative 2 sc1;
> 109a107
> > ij> relative 2 sc1;
> 113 del
> < ij(CONNECTION1)> -- delete row nr. 7 after positioning with relative
> 113a111
> > ij> -- delete row nr. 7 after positioning with relative
> 116 del
> < ij(CONNECTION1)> previous sc1;
> 116a114
> > ij> previous sc1;
> 120 del
> < ij(CONNECTION1)> -- delete row nr. 6 after positioning with previous
> 120a118
> > ij> -- delete row nr. 6 after positioning with previous
> 123 del
> < ij(CONNECTION1)> relative -1 sc1;
> 123a121
> > ij> relative -1 sc1;
> 127 del
> < ij(CONNECTION1)> last sc1;
> 127a125
> > ij> last sc1;
> 131 del
> < ij(CONNECTION1)> -- delete row nr. 10 after positioning with last
> 131a129
> > ij> -- delete row nr. 10 after positioning with last
> 134 del
> < ij(CONNECTION1)> after last sc1;
> 134a132
> > ij> after last sc1;
> 136 del
> < ij(CONNECTION1)> -- delete when positioned after last should cause an error
> 136a134
> > ij> -- delete when positioned after last should cause an error
> 139 del
> < ij(CONNECTION1)> first sc1;
> 139a137
> > ij> first sc1;
> 143 del
> < ij(CONNECTION1)> -- delete row nr. 1 after positioning with first
> 143a141
> > ij> -- delete row nr. 1 after positioning with first
> 146 del
> < ij(CONNECTION1)> before first sc1;
> 146a144
> > ij> before first sc1;
> 148 del
> < ij(CONNECTION1)> -- delete when positioned before first should cause an error
> 148a146
> > ij> -- delete when positioned before first should cause an error
> 151 del
> < ij(CONNECTION1)> close sc1;
> 152 del
> < ij(CONNECTION1)> commit;
> 153 del
> < ij(CONNECTION1)> -- check that row where correctly updated
> 153a149,151
> > ij> close sc1;
> > ij> commit;
> > ij> -- check that row where correctly updated
> 162 del
> < ij(CONNECTION1)>
> 162 add
> > ij>
> Test Failed.
> *** End: SURTest_ij jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2006-09-10 12:51:26 ***
--
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