Hi to all who know more about Derby In this particular situation mentioned below, is it possible to work with views that are able to use the certain table of the particular schema of the user that is loged in. It is just a thought that may be then the db abstraction layer Cayenne provides still is able to work....(?)
-----Ursprüngliche Nachricht----- Von: Øyvind Harboe [mailto:[email protected]] Gesendet: Donnerstag, 7. Januar 2010 17:37 An: Derby Discussion Betreff: Re: Derby memory consumption with many databases > In case you go that route, I just thought I'd mention here that Derby > supports standard SQL schemas and SQL authorization (so users would be > protected from accessing each others schemas) in contrast to > e.g. MySQL, for which database and schema is more or less the same > thing. The problem I have with schemas is that it isn't really portable between databases... We would like to leave the database choice to the users. Our app is talking to Cayenne which provides the db abstraction. -- Øyvind Harboe US toll free 1-866-980-3434 / International +47 51 63 25 00 http://www.zylin.com/zy1000.html ARM7 ARM9 ARM11 XScale Cortex JTAG debugger and flash programmer
