On 14/09/11 9:15 PM, Durchholz, Joachim wrote: >> dropping down to native SQL, > > Moving to SQL will not be one of the changes you'll need to make.
Ah, I see I was being unclear. I meant the places where the program drops down to raw SQL. E.g. for importing data from other databases where the actual data never hits the JVM; it's just a series of bulk SQL. Cayenne shouldn't come into play, except I'll want a JDBC connection and I tend to let the ORM manage connections (no need to reinvent the wheel), which means I'll probably need to ask Cayenne for one. And then there's always the utterly nonportable code. Such as database process monitoring. I just completed a small management tool that allows shooting down Oracle sessions; the selling point here being that the list of eligible processes is limited to those started by my software. > The Cayenne query API is powerful and easy to use. Excellent :-) Regards, Jo
