Gavin King schrieb:
After thinking about this, I think I've decided that there is
nothing at all wrong with doing data access via a remote
"gateway", so that Hibernate would run in the client tier and
act as a remote client of a server-side JDBC connection pool.
This would enable transaction demarcation, caching, dirty
checking and lazy fetching to be done on the client, but the
actual database access would take place on the server.
I see the problem off authorization. The client must not be allowed
to access the database by jdbc because there might be access restrictions
in the business layer. Newer db engines might support row-level access
restrictions but I, personally, want to express this in my business layer.
Now, as far as I can see, there is no reason at all for this
to be implemented as part of the ORM solution. Indeed, it
makes much more sense for this to be simply wrapper abound
JDBC. The wrapper would do transparent batching of
INSERT/UPDATE/DELETEs and provide pluggable client/server
remotability strategies (RMI/SOAP/etc), delegating to
a server-side connection pool. It could even be used outside
of Hibernate.
Does anyone know of an existing project like this? If not,
should we start one, under the aegis of hibernate.org? Is
anyone interested in starting work on this. I'm convinced
it is not at all difficult to implement.
There is c-jdbd which acts as a kind of jdbc-"raid" for databases
(Implementing db-clustering at jdbc level), which might be a goot starting
point for this.
Have I gone insane?
Partly, I think, yes ;-)
-billy.
--
Meisterbohne Meisterbohne GbR, Küfner, Mekle, Meier Tel: +49-731-399 499-0
eLösungen Söflinger Straße 100 Fax: +49-731-399 499-9
89077 Ulm http://www.meisterbohne.de/
-------------------------------------------------------
This SF.Net email is sponsored by the new InstallShield X.
From Windows to Linux, servers to mobile, InstallShield X is the
one installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
