Re: [dbunit-developer] AbstractDatabaseConnection.createTable needs schema name added to query?

[Roberto Lo G. <rlo...@gm...>]

Well, unless I misunderstood something Codehaus can provide us hudson and
the other stuff but I don't think they are going to give us any server to
run integrations tests againsts real databases.... can someone confirm that?

The next days will be very interesting for the dbUnit project... ;-)

I really need to get confidence with the codehaus stuff...

On Fri, Dec 17, 2010 at 17:26, Jeff Jensen <jj...@ap...> wrote:

> I'll state again: my employer will setup a server we can use and
> install all DBs we need.  No charge, no problem.   I stopped that from
> happening because you were moving to Codehaus.
>
> Do you want me to resume that effort?
>
>
>
>
> On Fri, Dec 17, 2010 at 9:54 AM, Roberto Lo Giacco <rlo...@gm...>
> wrote:
> > I think you will not be able to install Oracle 10 or other such
> "enterprise"
> > grade database with such a configuration man... And with 2GB of storage
> you
> > have not even the space needed by such engines.... I'm not sure how much
> > space they need but I'm quite sure it is much more than that.
> > On Fri, Dec 17, 2010 at 16:42, Zdeněk Vráblík <zd...@vr...>
> wrote:
> >>
> >> Hi,
> >>
> >> Spec:
> >>        800 MHz 512 MB  2 GB
> >>
> >> debian linux
> >>
> >> I would install mentioned databases.
> >>
> >> Hudson results could be available to everybody.
> >> It is fully online. It is cloud solution - under development, but for
> >> DbUnit integration tests should be fine. We could get better CPU and
> >> more hdd if necessary, all parameters are scalable online except
> >> memory ( max configurable is 512 MB right now). I am able get 1GB .
> >>
> >> I am going to install the databases you mentioned.
> >>
> >> Regards,
> >> Zdenek
> >>
> >> 2010/12/17 Roberto Lo Giacco <rlo...@gm...>:
> >> > what kind of virtual server are we talking about? Will you be able to
> >> > install such database engines onto it? Will it be able to receive
> >> > connections from the internet?
> >> >
> >> > On Fri, Dec 17, 2010 at 15:21, Zdeněk Vráblík <zd...@vr...>
> >> > wrote:
> >> >>
> >> >> Hi Roberto,
> >> >>
> >> >> I have one virtual server for free.
> >> >>
> >> >> Are you interested?
> >> >>
> >> >> I would have time to maintain that server, but after Christmas :).
> >> >>
> >> >> Regards,
> >> >> Zdenek
> >> >>
> >> >> On Fri, Dec 17, 2010 at 1:59 PM, Roberto Lo Giacco
> >> >> <rlo...@gm...>
> >> >> wrote:
> >> >> > Humm.. this pushes us again toward an integration test platform....
> I
> >> >> > must
> >> >> > do something to solve this problem, definitely.... I think I'll go
> >> >> > for
> >> >> > Amazon as it seem other options have failed and I'm now really
> tired
> >> >> > to
> >> >> > have
> >> >> > such a fear any change can break other integrations.
> >> >> > I would like starting with the following databases:
> >> >> > Oracle 10
> >> >> > PostgreSQL 8
> >> >> > mySQL 5
> >> >> > HiperSQL (HSQLDB) 2
> >> >> > JDBC drivers yet have a great role on dbUnit test results... any
> >> >> > suggestion
> >> >> > about how to solve the problem? Use the "official" where available
> or
> >> >> > the
> >> >> > "mostly adopted" could be the solution?
> >> >> > On Fri, Nov 26, 2010 at 03:03, Jeff Jensen <jj...@ap...>
> >> >> > wrote:
> >> >> >>
> >> >> >> Hi guys,
> >> >> >>
> >> >> >> I encountered a problem with using schema names today.  The funny
> >> >> >> thing is there is a comment by gomma on the line I needed to
> change
> >> >> >> to
> >> >> >> fix - line 116 of AbstractDatabaseConnection.java says "// TODO
> >> >> >> Think
> >> >> >> about QualifiedTableNames here - needed or not?".
> >> >> >>
> >> >> >> This is the current method:
> >> >> >>    public ITable createTable(String tableName) throws
> >> >> >> DataSetException, SQLException
> >> >> >>    {
> >> >> >>        logger.debug("createTable(tableName={}) - start",
> tableName);
> >> >> >>
> >> >> >>        if (tableName == null) {
> >> >> >>            throw new NullPointerException("The parameter
> 'tableName'
> >> >> >> must not be null");
> >> >> >>        }
> >> >> >>
> >> >> >>        String sql = "select * from " + tableName; // TODO Think
> >> >> >> about
> >> >> >> QualifiedTableNames here - needed or not?
> >> >> >>        return this.createQueryTable(tableName, sql);
> >> >> >>    }
> >> >> >>
> >> >> >> This is my suggested change:
> >> >> >>    public ITable createTable(String tableName) throws
> >> >> >> DataSetException, SQLException
> >> >> >>    {
> >> >> >>        logger.debug("createTable(tableName={}) - start",
> tableName);
> >> >> >>
> >> >> >>        if (tableName == null) {
> >> >> >>            throw new NullPointerException("The parameter
> 'tableName'
> >> >> >> must not be null");
> >> >> >>        }
> >> >> >>
> >> >> >>        // qualify with schema if configured
> >> >> >>        QualifiedTableName qualifiedTableName =
> >> >> >>                new QualifiedTableName(tableName,
> this.getSchema());
> >> >> >>        String qualifiedName =
> qualifiedTableName.getQualifiedName();
> >> >> >>        String sql = "select * from " + qualifiedName;
> >> >> >>        return this.createQueryTable(tableName, sql);
> >> >> >>    }
> >> >> >>
> >> >> >> With adding the schema name to the table query, the problem I
> >> >> >> encountered went away.
> >> >> >>
> >> >> >> Do any of you see any problem with this change?  If not, I will
> >> >> >> commit.
> >> >> >>
> >> >> >> Existing dbUnit tests pass and another of my customer apps with
> lots
> >> >> >> of dbUnit tests but no schema name still works.
> >> >> >>
> >> >> >> It makes me wonder how tests with schemas currently work!  They
> must
> >> >> >> not be using this method!
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> ------------------------------------------------------------------------------
> >> >> >> Increase Visibility of Your 3D Game App & Earn a Chance To Win
> $500!
> >> >> >> Tap into the largest installed PC base & get more eyes on your
> game
> >> >> >> by
> >> >> >> optimizing for Intel(R) Graphics Technology. Get started today
> with
> >> >> >> the
> >> >> >> Intel(R) Software Partner Program. Five $500 cash prizes are up
> for
> >> >> >> grabs.
> >> >> >> http://p.sf.net/sfu/intelisp-dev2dev
> >> >> >> _______________________________________________
> >> >> >> dbunit-developer mailing list
> >> >> >> dbu...@li...
> >> >> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> ------------------------------------------------------------------------------
> >> >> > Lotusphere 2011
> >> >> > Register now for Lotusphere 2011 and learn how
> >> >> > to connect the dots, take your collaborative environment
> >> >> > to the next level, and enter the era of Social Business.
> >> >> > http://p.sf.net/sfu/lotusphere-d2d
> >> >> > _______________________________________________
> >> >> > dbunit-developer mailing list
> >> >> > dbu...@li...
> >> >> > https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >>
> ------------------------------------------------------------------------------
> >> >> Lotusphere 2011
> >> >> Register now for Lotusphere 2011 and learn how
> >> >> to connect the dots, take your collaborative environment
> >> >> to the next level, and enter the era of Social Business.
> >> >> http://p.sf.net/sfu/lotusphere-d2d
> >> >> _______________________________________________
> >> >> dbunit-developer mailing list
> >> >> dbu...@li...
> >> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >> >
> >> >
> >> >
> >> >
> ------------------------------------------------------------------------------
> >> > Lotusphere 2011
> >> > Register now for Lotusphere 2011 and learn how
> >> > to connect the dots, take your collaborative environment
> >> > to the next level, and enter the era of Social Business.
> >> > http://p.sf.net/sfu/lotusphere-d2d
> >> > _______________________________________________
> >> > dbunit-developer mailing list
> >> > dbu...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >> >
> >> >
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> Lotusphere 2011
> >> Register now for Lotusphere 2011 and learn how
> >> to connect the dots, take your collaborative environment
> >> to the next level, and enter the era of Social Business.
> >> http://p.sf.net/sfu/lotusphere-d2d
> >> _______________________________________________
> >> dbunit-developer mailing list
> >> dbu...@li...
> >> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >
> >
> >
> ------------------------------------------------------------------------------
> > Lotusphere 2011
> > Register now for Lotusphere 2011 and learn how
> > to connect the dots, take your collaborative environment
> > to the next level, and enter the era of Social Business.
> > http://p.sf.net/sfu/lotusphere-d2d
> > _______________________________________________
> > dbunit-developer mailing list
> > dbu...@li...
> > https://lists.sourceforge.net/lists/listinfo/dbunit-developer
> >
> >
>
>
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social Business.
> http://p.sf.net/sfu/lotusphere-d2d
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>