Re: Problems with MS SQL Server and creating merger tokens

From: Tore Halset (halse..vv.ntnu.no)
Date: Thu Sep 25 2008 - 03:52:59 EDT

  • Next message: Andrus Adamchik: "Re: 3.0M4 : Fetching from relationship returns TRANSIENT objects."

    Hello.

    The merger get the table info using DbLoader that does a
    jdbcConnection.getMetaData().getTables() to pick up info on all the
    tables. My guess is that the database/jdbc-driver simply does not list
    the tables for your misconfigured user.

      - Tore.

    On Sep 25, 2008, at 9:32 , Øyvind Harboe wrote:

    > I had a database connection set up incorrectly, the
    > database user did not have the correct
    > access rights to the database. Not that uncommon
    > when messing around with restoring MS SQL databases...
    >
    > This cause the code below to return a list of tokens that tables
    > should
    > be added to the database.
    >
    > DbMerger merger = new DbMerger();
    > List<MergerToken> tokens = merger.createMergeTokens(dataNode,
    > dataMap);
    >
    >
    > I take it that the implementation does not distinguish between failing
    > to find a database table and not having access to it?
    >
    >
    > Ideally I'd like the above to throw an exception upon failure...
    >
    >
    > --
    > Øyvind Harboe
    > http://www.zylin.com/zy1000.html
    > ARM7 ARM9 XScale Cortex
    > JTAG debugger and flash programmer
    >



    This archive was generated by hypermail 2.0.0 : Thu Sep 25 2008 - 03:57:03 EDT