RE: Problems with MS SQL Server and creating merger tokens

From: Scott Anderson (sanderso..irvana.com)
Date: Thu Sep 25 2008 - 13:04:05 EDT

  • Next message: Scott Anderson: "RE: Insert at a particular position in the detail list"

    I'm not familiar with MSSQL, but in MySQL that's definitely the case - both database and table visibility are opt in, not opt out.

    -----Original Message-----
    From: oyvindharbo..mail.com [mailto:oyvindharboe@gmail.com] On Behalf Of Øyvind Harboe
    Sent: Thursday, September 25, 2008 4:16 AM
    To: use..ayenne.apache.org
    Subject: Re: Problems with MS SQL Server and creating merger tokens

    On Thu, Sep 25, 2008 at 9:52 AM, Tore Halset <halse..vv.ntnu.no> wrote:
    > 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.

    So that means that there *is* no way to distinguish between the case where there
    are no tables and where the database user does not have access to enumerate
    the tables?

    Not even in principle?

    Ouch!

    I wonder how I might deal with this in my application, especially
    since it is intended to
    run unsupervised(or by a user not capable of supervising). 

    -- 
Ø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 - 13:04:57 EDT