db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: Regarding DERBY-2750
Date Mon, 02 Jul 2007 17:34:43 GMT
The text fixtures in junit are supposed to be self sufficient, so maybe it
will be ok to have other test fixtures drop the tables created by
them before they finish and hence this particular test fixture shouldn't
find anything in SESSION schema. Just a suggestion.

Mamta


On 7/2/07, Ravinder Reddy <pandiri@students.iiit.ac.in> wrote:
>
> On Mon, 2 Jul 2007, Mamta Satoor wrote:
>
>        Thanks for a quick reply.
>
> > Hi Ravinder,
> >
> > I have more of a junit framework question for this particular test(for
> > DERBY-1706) change. This test in the non-junit test framework made sure
> that
> > it was executed before anyone physically created the SESSION schema. The
> > reason for that is we wanted to make sure that if the SESSION schema
> didn't
> > exist, we should be able to create a table inside that schema and that
> table
> > creation should automatically create SESSION schema. Just like what
> would
> > happen for any other user schema.
> >
> > Now in the junit framework, there is no way (I could be wrong) to ensure
> > that this test fixture (ie the test for DERBY-1706) gets run before
> other
> > test fixtures and hence it is possible that the SESSION schema has
> already
> > been created by other test fixtures by the time this particular test
> fixture
> > gets called and hence we won't really be testing what the original test
> > intended to run.
> > I guess one way would be drop the SESSION schema at the
> > beginning of this test fixture and then run rest of the code in this
> test
> > fixture.
>        I think we can't drop the SESSION schema unless it is empty.
> we have to drop all the tables before drop the SESSION. more
> complication.!!
>
> > This will not test exactly what the original test was testing but
> > will be close enough.
>
> >
> > Hope this helps,
> > Mamta
> >
> >
> > On 7/2/07, Ravinder Reddy <pandiri@students.iiit.ac.in> wrote:
> >>
> >>
> >>        hi,
> >>                I am converting lang/declareGlobalTempTableJava.java to
> >> junit.
> >> One of the tests test the Derby1706 which was handled by You.
> >> plzz look at the fixture and let me know If I am going something wrong.
> >>
> >> public void testDerby1706() throws SQLException {
> >>                Statement s = createStatement();
> >>                s.executeUpdate("set schema SESSION");
> >>                try{
> >>                        s.executeUpdate("create table DERBY1706(c11
> int)");
> >>                }
> >>                catch(SQLException e){
> >>                        assertFalse( "XJ001" == e.getSQLState());
> >>                }
> >>                 s.executeUpdate("drop table DERBY1706");
> >>                 s.executeUpdate("set schema APP");
> >>                 s.executeUpdate("drop schema SESSION restrict");
> >>
> >>           s.close();
> >>        }
> >>
> >> Thanks in Advance.
> >>
> >> --
> >>
> >>
> ******************************************************************************
> >>
> >>    Every problem that has been solved can be solved again in a better
> way
> >>
> >>                                                   - Ravinder Reddy
> >>
> >>
> >>
> *******************************************************************************
> >>
> >>
> >> --
> >> This message has been scanned for viruses and
> >> dangerous content by MailScanner, and is
> >> believed to be clean.
> >>
> >>
> >
> >
>
> --
>
> ******************************************************************************
>
>    Every problem that has been solved can be solved again in a better way
>
>                                                   - Ravinder Reddy
>
>
> *******************************************************************************
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>

Mime
View raw message