From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=unavailable autolearn_force=no version=3.4.4 Path: eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!news.eternal-september.org!feeder.eternal-september.org!nntp-feed.chiark.greenend.org.uk!ewrotcd!reality.xs3.de!news.jacob-sparre.dk!loke.jacob-sparre.dk!pnx.dk!.POSTED!not-for-mail From: Jacob Sparre Andersen Newsgroups: comp.lang.ada Subject: Experiences with GNATColl.SQL ORM? Date: Thu, 19 Dec 2013 15:53:12 +0100 Organization: Jacob Sparre Andersen Research & Innovation Message-ID: <87k3f0ao4n.fsf@adaheads.sparre-andersen.dk> NNTP-Posting-Host: 212.27.0.199.mobile.3.dk Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: loke.gir.dk 1387464792 26727 212.27.0.199 (19 Dec 2013 14:53:12 GMT) X-Complaints-To: news@jacob-sparre.dk NNTP-Posting-Date: Thu, 19 Dec 2013 14:53:12 +0000 (UTC) User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) Cancel-Lock: sha1:zRgEWUwJtZgNYPofkmVuYSFqMqo= Xref: news.eternal-september.org comp.lang.ada:18065 Date: 2013-12-19T15:53:12+01:00 List-Id: Can somebody report on their experiences with the Object-Relational Mapping (ORM) layer in GNATColl.SQL? We are using plain GNATColl.SQL at AdaHeads, and I am experimenting with it for some other projects, but I would like to use ORM and not the untyped GNATColl.SQL interface. I have tried to run the "gnatcoll_db2ada" tool on our data model for Alice, but it fails with an internal error: A database error occurred, please try again... Exception name: CONSTRAINT_ERROR Message: gnatcoll-sql-inspect.adb:174 access check failed This does not make me very confident of the quality of the ORM layer of GNATColl.SQL. :-( Are there any alternatives out there? (The requirements are that the persistence backend shouldn't be specific to the tool and that the storage access should be strongly typed.) Greetings, Jacob --