Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of farkmischer@gmail.com
 designates 209.85.212.43 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=ogUtBb6Os/O2AGNq8ieExAG6dCEA18sXK4U9lr0/AcoVnuslylWys0qT8zlbvbs4Qh
         m1h1m0gM6nBDp7D59zUdz941jmmoTODeUtgnt3NuBnPHzxn41eahme61140ueJHNERi7
         XCMcp4scFQPy8QGJC/hi8IykQckk/j/DPiu2o=
MIME-Version: 1.0
In-Reply-To: <1289420561209-1878441.post@n3.nabble.com>
References: <AANLkTik6jNkqVVCsp8bngU+WHDdptjojDKXn+NVHXFkX@mail.gmail.com>
	<1289420561209-1878441.post@n3.nabble.com>
Date: Thu, 11 Nov 2010 10:41:31 -0600
Message-ID: <AANLkTim5wfev0mZOzT6x6oGXQS=Kuuo110a3wv7APM7q@mail.gmail.com>
Subject: Re: Reengineer Database Schema not generating anything
From: Mark Fischer <farkmischer@gmail.com>
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=0016e64c24f26cb51b0494c9a54a

--0016e64c24f26cb51b0494c9a54a
Content-Type: text/plain; charset=ISO-8859-1

That did it!!!  I must admit that maybe because I am from a visual studio or
windows background I have never had to "Select Schema" like I do with
Cayenne and so I had to idea what to pick 3-4 weeks ago when I first tried
Cayenne.  When you connect from visual studio you just give the url and
username and password, there is no schema to select from.  Also, when I
wrote the small jdbc program to check my connection it did not ask me for a
schema.  What does the schema do?

When I first tried this 3-4 weeks ago  I started at the top with
"db_accessadmin" and worked my way down through the 13 options to "db_owner"
and gave up.  There were still 5 choices left but I figured that if
"db_owner" did not have the proper rights then none of the others would.  I
went into SQL Server and made sure that "db_owner" was assigned full rights
before I gave up.  Turns out if I pick "sys" I get a Map with all the tables
including the system tables and if I pick "dbo" I get all the non system
tables.  Any idea why "dbo" works but "db_owner" does not?  My knowledge of
databases is not extensive so I must admit I do not know much about how the
schemas work in SQL Server.

Sorry if this was a dumb error and wasting everyones time.  Thanks for
sticking it out with me!!!

Mark

On Wed, Nov 10, 2010 at 2:22 PM, bogdan_voloshincu <
bogdan_voloshincu@yahoo.com> wrote:

>
> take a look :
>
> http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-td1876015.html#a1876015
> --
> View this message in context:
> http://cayenne.195.n3.nabble.com/Reengineer-Database-Schema-not-generating-anything-tp1831261p1878441.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>

--0016e64c24f26cb51b0494c9a54a--