Hi, deployment/subsystem/jpa/hibernate-persistence-unit/query-cache nodes expose an "encoded" query name attribute. Here's an example: "rhq.ear/rhq-core-domain-ejb3.jar#rhqpu.rhq.ear_divide_rhq_minus_core_minus_domain_minus_ejb3.jar#rhqpu.rhq.ear_divide_rhq_minus_core_minus_domain_minus_ejb3.jar#rhqpu.SELECT_space_subject_newline_FROM_space_Subject_space_subject_newline_WHERE_space__left_paren__space_LOWER_left_paren__space_subject.name_space__right_paren__space_like_space__colon_name_space_ESCAPE_space__quote_\\_quote__space__space__right_paren__newline_ORDER_space_BY_space_subject.id_space_ASC_newline_" I could write something to decode every occurrence of "_minus_", "_space_" and so on, provided I can get the list of all the keywords in use. But I wonder if there's already a library in the Hibernate subsystem which does that. By the way, these nodes exist in AS7 and EAP6, but I found no equivalent in Wildfly management model. Did I miss the definition on the Wildscribe site? http://wildscribe.github.io/JBoss%20AS7/7.1.1/deployment/subsystem/jpa/hi... Thanks, Thomas _______________________________________________ wildfly-dev mailing list wildfly-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/wildfly-dev

Thomas, In WildFly 8, the code moved to the Jipijapa project. For Hibernate 4.3.x, the (private api) QueryName class transforms the query via https://github.com/jipijapa/jipijapa/blob/master/hibernate4_3/src/main/ja... There is also a Hibernate 4.1.x/4.2.x implementation here https://github.com/jipijapa/jipijapa/blob/master/hibernate4_1/src/main/ja...

The *why* is to turn the query name into a legal name (e.g. that can be displayed by the jboss-cli tool).

Why are you trying to decode the query back into its original (internal Hibernate) form? Which project are you trying to do this for?

Scott On 01/27/2014 11:22 AM, Tomaž Cerar wrote: > It was removed as part of this commit > https://github.com/wildfly/wildfly/commit/ac3bee2#diff-d3c9757d55cdb99a97... > > > why, that would be question for Scott. > > -- > tomaz > > > On Mon, Jan 27, 2014 at 5:02 PM, Thomas Segismont <tsegismo(a)redhat.com > <mailto:tsegismo@redhat.com>> wrote: > > Hi, > > deployment/subsystem/jpa/hibernate-persistence-unit/query-cache nodes > expose an "encoded" query name attribute. Here's an example: > > > "rhq.ear/rhq-core-domain-ejb3.jar#rhqpu.rhq.ear_divide_rhq_minus_core_minus_domain_minus_ejb3.jar#rhqpu.rhq.ear_divide_rhq_minus_core_minus_domain_minus_ejb3.jar#rhqpu.SELECT_space_subject_newline_FROM_space_Subject_space_subject_newline_WHERE_space__left_paren__space_LOWER_left_paren__space_subject.name_space__right_paren__space_like_space__colon_name_space_ESCAPE_space__quote_\\_quote__space__space__right_paren__newline_ORDER_space_BY_space_subject.id_space_ASC_newline_" > > > I could write something to decode every occurrence of "_minus_", > "_space_" and so on, provided I can get the list of all the > keywords in > use. But I wonder if there's already a library in the Hibernate > subsystem which does that. > > By the way, these nodes exist in AS7 and EAP6, but I found no > equivalent > in Wildfly management model. Did I miss the definition on the > Wildscribe > site? > > > http://wildscribe.github.io/JBoss%20AS7/7.1.1/deployment/subsystem/jpa/hi... > > > Thanks, > Thomas > _______________________________________________ > wildfly-dev mailing list > wildfly-dev(a)lists.jboss.org <mailto:wildfly-dev@lists.jboss.org> > https://lists.jboss.org/mailman/listinfo/wildfly-dev > > > > > _______________________________________________ > wildfly-dev mailing list > wildfly-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/wildfly-dev >

Le 27/01/2014 18:10, Thomas Segismont a écrit : >>> >>> Why are you trying to decode the query back into its original (internal >>> Hibernate) form? Which project are you trying to do this for? > I'm trying to decode the name to show the query statistics in RHQ. I > wish there was an attribute in the node with the plain query string. > That would be a nice add in Wildfly, but for RHQ to work with already > released versions of AS7 and EAP6, there's no other way... > Scott, I want to file a JIRA about a new attribute showing the plain query string, should it be against WILDFLY or JIPI?

Thanks, Thomas _______________________________________________ wildfly-dev mailing list wildfly-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/wildfly-dev

On 01/27/2014 12:10 PM, Thomas Segismont wrote: > I'm trying to decode the name to show the query statistics in RHQ. I > wish there was an attribute in the node with the plain query string. > That would be a nice add in Wildfly, but for RHQ to work with already > released versions of AS7 and EAP6, there's no other way... Currently, the plain query string would cause an (Dynamic Model Representation) exception to be thrown, as it could contain illegal characters sequences.

_______________________________________________ wildfly-dev mailing list wildfly-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/wildfly-dev

> In an attribute? > > > >PathAddress has rules, but an attribute of ModelType.STRING should be > >able to store arbitrary text. In the PathAddress. for example: cd SELECT_space_m_space_FROM_space_Message_space_m_space_where_space_m.reliable_space__equal__space__quote_y_quote_

On 01/27/2014 03:01 PM, Thomas Segismont wrote: > Le 27/01/2014 20:54, Scott Marlow a écrit : >>> In an attribute? >>>> >>>> PathAddress has rules, but an attribute of ModelType.STRING should be >>>> able to store arbitrary text. >> In the PathAddress. for example: >> >> cd >> SELECT_space_m_space_FROM_space_Message_space_m_space_where_space_m.reliable_space__equal__space__quote_y_quote_ >> >> > > The JIRA I want to file is actually about adding an attribute. > > WILDFLY or JIPI? Thomas, Do you want to add another attribute within the SELECT_space_m_space_FROM_space_Message_space_m_space_where_space_m.reliable_space__equal__space__quote_y_quote_? Or at a higher level? Currently, for this test application that I deployed, the path to the query cache entries is: /deployment=jmxp.ear.ear/subdeployment=jmxp.ejb.jar/subsystem=jpa/hibernate-persistence-unit=jmxp.ear.ear/jmxp.ejb.jar#fraudPU/query-cache which contains two PathAddress entries: SELECT_space_m_space_FROM_space_Message_space_m SELECT_space_m_space_FROM_space_Message_space_m_space_where_space_m.reliable_space__equal__space__quote_y_quote_ Scott > _______________________________________________ > wildfly-dev mailing list > wildfly-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/wildfly-dev >

On 01/27/2014 02:49 PM, Brian Stansberry wrote: > On 1/27/14, 1:35 PM, Scott Marlow wrote: >> On 01/27/2014 12:10 PM, Thomas Segismont wrote: >>> I'm trying to decode the name to show the query statistics in RHQ. I >>> wish there was an attribute in the node with the plain query string. >>> That would be a nice add in Wildfly, but for RHQ to work with already >>> released versions of AS7 and EAP6, there's no other way... >> >> Currently, the plain query string would cause an (Dynamic Model >> Representation) exception to be thrown, as it could contain illegal >> characters sequences. >> > > In an attribute? > > PathAddress has rules, but an attribute of ModelType.STRING should be > able to store arbitrary text. In the PathAddress. for example: cd SELECT_space_m_space_FROM_space_Message_space_m_space_where_space_m.reliable_space__equal__space__quote_y_quote_

> >> _______________________________________________ >> wildfly-dev mailing list >> wildfly-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/wildfly-dev >> > > _______________________________________________ wildfly-dev mailing list wildfly-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/wildfly-dev

On Mon, Jan 27, 2014 at 5:57 PM, Scott Marlow <smarlow(a)redhat.com <mailto:smarlow@redhat.com>> wrote: In WildFly 8, the code moved to the Jipijapa project. This does not explain why deployment resources are not present / registered anymore.

On 01/27/2014 12:25 PM, Scott Marlow wrote: > On 01/27/2014 12:12 PM, Tomaž Cerar wrote: >> >> On Mon, Jan 27, 2014 at 5:57 PM, Scott Marlow <smarlow(a)redhat.com >> <mailto:smarlow@redhat.com>> wrote: >> >> In WildFly 8, the code moved to the Jipijapa project. >> >> >> >> This does not explain why deployment resources are not present / >> registered anymore. > > I'll take a look. I deployed a test from another issue and am able to change into /deployment=jmxp.ear.ear/subdeployment=jmxp.ejb.jar/subsystem=jpa/hibernate-persistence-unit=jmxp.ear.ear/jmxp.ejb.jar#fraudPU/query-cache and doing an "ls" shows: SELECT_space_m_space_FROM_space_Message_space_m SELECT_space_m_space_FROM_space_Message_space_m_space_where_space_m.reliable_space__equal__space__quote_y_quote_ If these queries didn't exist, I wouldn't see them but otherwise I don't see the problem.