Got it.

There is one problem I see with that. You have to keep the SQL as generic as possible, which means it can't take advantage of things like Stored Procs and other performance advantages one platform may have over another. I prefer to write specific code for the platform and have the same API to each.

>Maybe I was not clear.
>
>We've got the following layers:
>
>GUI
>-----
>BIZZOBJECTS
>DATA LAYER
>-----
>DATABASE
>
>The bizz objects operate on cursors, but also provides data objects in case a web application wants to use this bizzobject. So for the desktop application we can use the cursors directly (2tier), for an outside application they have to do with the data-objects (3+ tier).
>
>In the data layer I want to use cursoradapters to abstract away from backend specifics.