Decoding query name attribute in deployment/subsystem/jpa/hibernate-persistence-unit/query-cache nodes
5:02 p.m.
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
5:22 p.m.
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>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
https://lists.jboss.org/mailman/listinfo/wildfly-dev
5:57 p.m.
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
6:10 p.m.
Hi Scott,
Thanks for replying. Please find my answers below.
Le 27/01/2014 17:57, Scott Marlow a écrit :
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...
OK. Where in the management tree will the nodes appear?
The *why* is to turn the query name into a legal name (e.g. that can be
displayed by the jboss-cli tool).
Got you.
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
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
>
Thanks,
Thomas
6:25 p.m.
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.
6:44 p.m.
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
6:46 p.m.
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.
_______________________________________________
wildfly-dev mailing list
wildfly-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/wildfly-dev
6:51 p.m.
Le 27/01/2014 18:46, Scott Marlow a écrit :
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.
Good news. Still why the "Hibernate Persistence Unit" description does
not appear on Wildscribe site?
http://wildscribe.github.io/Wildfly/8.0.0.CR1/deployment/subsystem/jpa/in...
It does appear in EAP6.2 model:
http://wildscribe.github.io/JBoss%20EAP/6.2.0/deployment/subsystem/jpa/in...
6:53 p.m.
On 01/27/2014 12:44 PM, Thomas Segismont wrote:
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?
I'm not sure. If I didn't translate the query as I did, it wouldn't be
displayable in the jboss-cli tool.
Thanks,
Thomas
_______________________________________________
wildfly-dev mailing list
wildfly-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/wildfly-dev
8:35 p.m.
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.
8:49 p.m.
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.
_______________________________________________
wildfly-dev mailing list
wildfly-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/wildfly-dev
--
Brian Stansberry
Senior Principal Software Engineer
JBoss by Red Hat
8:54 p.m.
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
>
9:01 p.m.
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?
9:06 p.m.
On 01/27/2014 02:54 PM, Scott Marlow wrote:
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_
Before translation, the PathAddress would of been:
SELECT m FROM Message m where m.reliable = 'y'
>
>> _______________________________________________
>> 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
9:16 p.m.
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
9:26 p.m.
Le 27/01/2014 21:16, Scott Marlow a écrit :
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
>
Yes, a new attribute in "query-cache" nodes, named "query-string",
sibling of "query-cache-hit-count", "query-cache-miss-count",
"query-execution-average-time" ... etc
10:44 p.m.
On 01/27/2014 03:26 PM, Thomas Segismont wrote:
Yes, a new attribute in "query-cache" nodes, named
"query-string",
sibling of "query-cache-hit-count", "query-cache-miss-count",
"query-execution-average-time" ... etc
Sure, that should be doable. The upstream jira should be in
https://issues.jboss.org/browse/JIPI.
3742
days inactive
3742
days old
17 comments
4 participants
participants (4)
-
Brian Stansberry -
Scott Marlow -
Thomas Segismont -
Tomaž Cerar