Is there currently a possibility, or could it be made possible,
to bind Entity Objects (used in a pivot application as storage for
the ui)
via JDBC to Rows in a Database? Without going through the
web services of an application server?
An ORM Framework could be used, though.
I'm not terribly familiar with Java EE terminology, but are the entity
objects Java Beans? If so, you should already be able to bind to them.
And another one: is it possible (there might even be a sample
somewhere)
to easily create a transparent web service on some "dumb" appserver,
which just routes the requests via JDBC to a database?
Maybe even with authentication of the database passed through
(perhaps as a simple "https://login"-Webservice).
No session pooling wanted, just 1:1 cookie-sessions : db-sessions.
I have found http://sqlrest.sourceforge.net/ , but has anyone
tried such a thing, maybe with Pivot?
I have toyed with the idea of creating something like this for a
couple of years. For standalone tables, it's pretty easy to visualize.
When you get into joined tables, though, it gets tougher. It would be
useful, though.
