[scxml] some ways for storing the states, transitions and any hierarchical structure

[Nestor Urquiza-3]

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

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

[Rahul Akolkar]

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 <[hidden email]> 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: [hidden email]
For additional commands, e-mail: [hidden email]

[Nestor Urquiza-3]

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 <[hidden email]> 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 <[hidden email]> 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:
> [hidden email]
> For additional commands, e-mail:
> [hidden email]
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

[ws_dev2001]

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 <[e-mail]> 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 <[e-mail]> 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:
> [e-mail]
> For additional commands, e-mail:
> [e-mail]
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]