Hello Pivoteers, the current discussion about preferences and persistence just inspired me to pose a question:
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. Would be great for our in-house enterprise application. 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? Apache Pivot is really great work, I'm considering the platform as a replacement for Oracle Forms in our enterprise. Greetings Thomas ------------------------------------------------------------ Thomas Guretzki Telefon +49 511 7631 334; Fax +49 511 7631 718 T.I.K. GmbH - Datenbankadministration & Softwareentwicklung Königsworther Platz 6 30167 Hannover Germany Steuer-Nr. 2520601056 Geschäftsführer: Dr. Rainer Koch, Sitz: Hannover Registereintrag: HRB 58144, Amtsgericht Hannover -----Ursprüngliche Nachricht----- Von: Greg Brown [mailto:gkbr...@mac.com] Gesendet: Freitag, 21. August 2009 16:14 An: pivot-dev@incubator.apache.org Cc: pivot-u...@incubator.apache.org Betreff: Re: Preferences Demo X-ESAFE-STATUS:[dschafar] Mail clean X-ESAFE-DETAILS:[dschafar] >> Since preferences APIs are generally built on top of persistence >> APIs, it might be more valuable to write a persistence demo - I'd >> especially like to see an example that uses the JNLP APIs to >> support local storage in untrusted code. That way, readers can >> apply the example to a wider range of use cases. > > Ok, that's why I was thinking of a simple TODO List ... otherwise > ideas (as you said, saving/loading the current window position, etc > could be enough) ? I think it would be more valuable to show a "persistence" example than a "preferences" example, since you can build preferences on top of persistence. > And a last thing, to use Web Start, I have to put also a jnlp file > (and jnlp files must have the right codebase path inside them, or > there should be a servlet that handle this ...), but we need to > publish also this stuff inside the demos, if i remember well you or > Todd have done an ant task to package a webapp, right ? Or put this > only on wiki with only an on-line demo (with source code) ? > Should i use something like this ? Ideas / suggestions ? You should be able to add a JSP to the demos WAR that generates a JNLP file with the correct codebase.