Hi Bruce,
This is strange... The way you are doing it is completely correct. Also
I just did a little test using the latest Cayenne release (1.0 final)
and com.microsoft.jdbc.sqlserver.SQLServerDriver driver. Server is MS
SQL Server 2000 EE (running on Windows - duh!). I was able to
completely reverse engineer the database schema, including all the
relationships. So reverse engineering SQL Server works.
Is it possible that your login id doesn't have permissions to read the
schema metadata? I never administered a SQL Server installation, so I
can't tell where to look... I guess you could try using the default
superuser login ("sa"), if it is not disabled, and see if it makes any
difference. In any event, verify that you can see the tables you are
trying to reverse engineer using Microsoft tools.
Andrus
On Saturday, September 20, 2003, at 09:44 PM, Bruce Buttles wrote:
> am new to Cayenne ...
> I tried to get the Modeler to Reengineer my MS SQL Server database.
> I got it to connect to the DB just fine using the
> com.microsoft.jdbc.sqlserver.SQLServerDriver driver and using the
> Sybase
> RDBMS Adapter as suggested in the Cayenne docs (also tried the JDBC
> adapter with no luck).
>
> Well, it doesn't fail ... but it also does not create any new mappings
> in the model.
>
> I just get one DataMap called UntitledMap1
>
> Attached are three screen shots showing the sequence of events.
>
> Am I missing something here?
> Maybe the Reengineering is not quite there yet?
>
> Any help would be great ... the reengineer is one of the most
> important features I need for a O/R framework.
>
>
> Thanks!
>
> -Bruce
>
> Bruce Buttles
> CTO, PhoenixBay
> 201 S. Tryon Street
> Suite 1000, 10th Floor
> Charlotte, NC 28202
> office: 704-644-1347
> mobile: 704-839-6783
> eFax: 208-955-2785
This archive was generated by hypermail 2.0.0 : Sat Sep 20 2003 - 23:05:58 EDT