JDBCCacheLoaderTest run
hmesha Jan 24, 2006 12:31 PMHi all,
Discussion on running JDBCCacheLoaderTest class manually or during the functional test automated run.
This test case requires access to a DBMS and JDBC driver. Given the requirement, we have 2 options:
1) Run the test case manually by configuring the DBMS in /etc/cache-jdbc.properties file and placing the appropriate jdbc driver jar file in the lib directory
2) Include an in-memory database engine and JDBC driver. Configure /etc/cache-jdbc.properties file. Let it run automatically (i.e. Derby)
We have been discussing this on a private email, see below:
Hany Mesha wrote:
>
> Derby jar is 2.0 MB. It can be run embedded mode or as a client
> server. I'm planning to use it in embedded mode. Embedded mode is an
> environment in which only a single application can access a database
> at one time, and no network access occurs. When an application starts
> an instance of Derby within its JVM, the application runs in an
> embedded environment. Loading the embedded driver starts Derby.
>
> Actually, Derby used to be Informix/IBM CloudScape until IBM donated
> to Apache which then has evolved to be Derby.
>
> I'll start a discussion on the design forum for this issue and let's
> continue there.
>
> - Hany
>
>
> Hany M. Mesha
>
> Sr. Software Engineer,
>
> Novell exteNd Engineering
>
> Toronto, Canada
>
> hmesha@novell.com <mailto:hmesha@novell.com>
>
> Mobile: 416-456-6945
>
> Novell, Inc.
>
> Software for the Open Enterprise
>
> www.novell.com/open <http://www.novell.com/open>;
>
>
>
> >>> Manik Surtani <manik@jboss.org> 01/24/06 10:22 am >>>
> Hmm, this discussion is heading towards a lib-reference dir that
> contains reference jars for running unit tests but is not shipped
> with any of the packages... messy though.
>
> And how would Derby compare with Hypersonic?
>
> Cheers,
> --
> Manik Surtani
> manik@jboss.org
>
> Telephone: +44 7786 702 706
> MSN: manik@surtani.org
> Yahoo: maniksurtani
> AIM: maniksurtani
> Skype: maniksurtani
>
>
> On 24 Jan 2006, at 15:09, Bela Ban wrote:
>
> > How big is the Derby DB JAR ? Does it run in-memory only ?
> >
> > Hany Mesha wrote:
> >>
> >> Hi Manik,
> >>
> >> I contacted Ryan Campbell about this issue and he suggested I make
> >> it that way so the build team will tweak the cache-jdbc.properties
> >> to the server config in the lab. Also, I brought up this issue in
> >> the last update meeting we had for the same exact reason that you
> >> mentioned below. Ben had suggested that I look into making the
> >> test case run against derby by the default. Although, that will
> >> add a jar to lib directory in CVS but it's the best option I think
> >> and I'm actually going to do that. If you prefer to eliminate the
> >> failure before cutting the DR, let me know and I'll rename the
> >> test case for the time being until I get to switch it over to
> >> derby and test it.
> >>
> >> Cheers,
> >>
> >> -Hany
> >>
> >>
> >> Hany M. Mesha
> >>
> >> Sr. Software Engineer,
> >>
> >> Novell exteNd Engineering
> >>
> >> Toronto, Canada
> >>
> >> hmesha@novell.com <mailto:hmesha@novell.com>
> >>
> >> Mobile: 416-456-6945
> >>
> >> Novell, Inc.
> >>
> >> Software for the Open Enterprise
> >>
> >> www.novell.com/open <http://www.novell.com/open>;
> >>
> >>
> >> >>> Manik Surtani <manik@jboss.org> 01/24/06 9:57 am >>>
> >> Hi guys
> >>
> >> This test currently fails on lab because of incorrect connection
> >> details in etc/cache-jdbc.properties and due to a missing MySQL
> >> driver.
> >>
> >> How could we effectively set this up so the tests run without
> >> adding unnecessary library jars to CVS? With previous JDBC tests,
> >> we renamed the test to JDBCCacheLoaderTestCase which meant that
> >> the test never ran when using any of the ant targets, but could
> >> only be run manually. While this approach is effective, it does
> >> mean that regression testing the JDBCCacheLoader can get
> >> overlooked. Any suggestions on how we can achieve this?
> >>
> >> Cheers,
> >> --
> >> Manik Surtani
> >> manik@jboss.org
> >>
> >> Telephone: +44 7786 702 706
> >> MSN: manik@surtani.org
> >> Yahoo: maniksurtani
> >> AIM: maniksurtani
> >> Skype: maniksurtani
> >>
> >>
> >>
> >
> > --
> > Bela Ban
> > Lead JGroups / JBossCache
> > callto://belaban
> >
>
>