Hi Nestor, Has there been any update you have on state persistence for scxml ? Regards, R2D2.
Nestor Urquiza-3 wrote: > > Yes I will keep you posted and in fact I am evaluating > to use iBATIC (I posted the question to javaranch, > iBATIC and Hibernate forums) because seems like iBATIC > creates columns per fields from objects which makes > the reporting easy if the way of storing is > consistent. > > However I really think that mysql 5.0 option is still > a good one. I will wait for responses from the rest of > the forums and I will be back with whatever approach I > fillow and the results of course. > > Thanks > > --- Rahul Akolkar <rahul.akol...@gmail.com> wrote: > >> While there may be subscribers to this list that are >> quite familiar >> with hibernate, I'd also suggest asking (the >> question below) on the >> hibernate lists since this seems more appropriate >> there. >> >> But I imagine this to be of interest to [scxml] >> users (it certainly is >> to me), so if you do get things set up the way you >> want with hibernate >> and are so inclined, please feel free to add a page >> to our wiki [1] so >> it becomes commons knowledge. >> >> Thanks, >> -Rahul >> >> [1] >> > http://wiki.apache.org/jakarta-commons/SCXML/HomePage >> >> >> On 5/8/06, Nestor Urquiza <nest...@yahoo.com> wrote: >> > I have to decide for my project if it is worth it >> to >> > store some of my objects directly in mysql using >> > Hibernate. >> > >> > The usecase is just a web application accepting >> HTTP >> > GET/POST requests and depending on given states it >> > executes some code and move the client to a new >> state >> > (I am using commons-scxml [1] for this). Moving >> from a >> > starting state to an ending state the application >> pass >> > several internal states and I need to store the >> whole >> > history in a table. >> > >> > I could use mysql 5 UpdateXML() extractValue() UDF >> > functions to store/retrieve the hierarchical data >> but >> > as an alternative I think storing objects directly >> is >> > a perfect approach. In fact I think ORM is a >> pretty >> > cool alternative to native xml storage. >> > >> > The real problem arrives when Reporting guys want >> to >> > query the mysql database for the states I have >> stored >> > using Hibernate. I saw from Hibernate Tools there >> is a >> > console plugin for eclipse [2] that allows to >> query >> > the database using HSQL, however I am wondering if >> > anyone knows about a way of using just plain SQL >> from >> > a mysql client to query data that is stored using >> > Hibernate. I understand this could be done using >> an >> > UDF (User Defined Function). >> > >> > Any thoughts? Whatever idea you might have could >> help >> > a lot my storage options/decision. >> > >> > Thanks a lot!, >> > Nestor Urquiza >> > >> > [1] http://jakarta.apache.org/commons/scxml/ >> > [2] http://www.hibernate.org/255.html >> > >> >> > --------------------------------------------------------------------- >> To unsubscribe, e-mail: >> commons-user-unsubscr...@jakarta.apache.org >> For additional commands, e-mail: >> commons-user-h...@jakarta.apache.org >> >> > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: commons-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: commons-user-h...@jakarta.apache.org > > > -- View this message in context: http://www.nabble.com/-scxml--some-ways-for-storing-the-states%2C-transitions-and-any-hierarchical-structure-tp4282259p24074766.html Sent from the Commons - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org