Re: MS Sql Server

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Apr 19 2004 - 23:07:47 EDT

  • Next message: Andrus Adamchik: "SQLTemplate Preview"

    You are right. Looks like modeler does not display it. I will fix that.

    Now you can simply type
    "org.objectstyle.cayenne.dba.sqlserver.SQLServerAdapter" right in the
    dropdown. It will be saved correctly even if it is not on the list.

    Andrus

    On Apr 19, 2004, at 10:54 PM, Gary Jarrel wrote:
    > Strange! Does 1.1M5 have the SQLServerAdapter? I've got the modeller
    > running
    > in the background (1.1M5) and the adapter doesn't appear in the list.
    >
    > Just used SybaseAdapter to reverse engineer the SQL Server database
    > and it
    > looks as though it grabed all the info I needed.
    >
    > - Gary
    >
    > -----Original Message-----
    > From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    > Sent: Tuesday, 20 April 2004 12:15 PM
    > To: cayenne-use..bjectstyle.org
    > Subject: Re: MS Sql Server
    >
    >
    > Hi Gary,
    >
    > On Apr 19, 2004, at 10:13 PM, Gary Jarrel wrote:
    >> Cayenne doesn't seem to have a DB Adapter for Microsoft SQL Server
    >
    > It doesn't in 1.0.*, however it does in 1.1. Though 1.1 is somewhat
    > unstable at this point, it is quickly moving to Beta. So it is becoming
    > safer to upgrade with every new milestone.
    >
    >
    >> Searching though the mailing lists, it's suggested that the best
    >> solution is
    >> the Sybase adapter! Is this still the case or are there better
    >> alternatives
    >> that someone could suggest?
    >
    > This is the case and it actually makes sense. IIRC, Sybase helped MS a
    > lot to develop SQL Server (and in the process lost its leading position
    > on the DB market). The similarities in the "feel" of two databases are
    > striking. SQLServerAdapter in 1.1 in fact inherits from SybaseAdapter
    > and customizes just a few minor things.
    >
    > Andrus
    >
    >
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Mon Apr 19 2004 - 23:07:53 EDT