Menu
▾
▴
[Rhq-commits] [rhq-project.org rhq] [1961] Improved JPQL for new queries, as suggested by mazz
|
From: <jsh...@rh...> - 2008-11-11 19:02:59
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head><style type="text/css"><!-- #msg DL { border : 1px #006 solid; background-color : #369; padding : 6px; color : #fff; } #msg DT { float : left; width : 6em; font-weight : bold; } #msg DL, #msg DT, #msg UL, #msg LI { font-family : arial,helvetica,sans-serif; font-size : 10pt; } h3 { font-family : arial,helvetica,sans-serif; font-size : 10pt; font-weight : bold; } #msg PRE { overflow : auto; white-space : normal; background-color : #ffc; border : 1px #fc0 solid; padding : 6px; } #msg UL, PRE, .diff { overflow : auto; } #patch h4 { font-family : arial,helvetica,sans-serif; font-size : 10pt; } #patch h4 { padding: 8px; background : #369; color : #fff; margin : 0; } #patch .propset h4, #patch .binary h4 {margin: 0;} #patch pre {padding:0;line-height:1.2em;margin:0;} #patch .diff {background:#eeeeee;padding: 0 0 10px 0;} #patch .propset .diff, #patch .binary .diff {padding: 10px 0;} #patch span {display:block;padding:0 10px;} #patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} #patch .add {background:#ddffdd;} #patch .rem {background:#ffdddd;} #patch .lines, .info {color:#888888;background:#ffffff;} .diff { width : 100%; } #msg DL { border : 1px #006 solid; background-color : #369; padding : 6px; color : #fff; } #msg DT { float : left; width : 6em; font-weight : bold; } #msg DL, #msg DT, #msg UL, #msg LI { font-family : arial,helvetica,sans-serif; font-size : 10pt; } h3 { font-family : arial,helvetica,sans-serif; font-size : 10pt; font-weight : bold; } #msg PRE { overflow : auto; white-space : normal; background-color : #ffc; border : 1px #fc0 solid; padding : 6px; } #msg UL, PRE, .diff { overflow : auto; } #patch h4 { font-family : arial,helvetica,sans-serif; font-size : 10pt; } #patch h4 { padding: 8px; background : #369; color : #fff; margin : 0; } #patch .propset h4, #patch .binary h4 {margin: 0;} #patch pre {padding:0;line-height:1.2em;margin:0;} #patch .diff {background:#eeeeee;padding: 0 0 10px 0;} #patch .propset .diff, #patch .binary .diff {padding: 10px 0;} #patch span {display:block;padding:0 10px;} #patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} #patch .add {background:#ddffdd;} #patch .rem {background:#ffdddd;} #patch .lines, .info {color:#888888;background:#ffffff;} .diff { width : 100%; } --></style> <title>[rhq-project.org rhq] [1961] Improved JPQL for new queries, as suggested by mazz</title> </head> <body> <div id="msg"> <dl> <dt>Revision</dt> <dd>1961</dd> <dt>Author</dt> <dd>jshaughn</dd> <dt>Date</dt> <dd>2008-11-11 13:02:49 -0600 (Tue, 11 Nov 2008)</dd> </dl> <h3>Log Message</h3> <pre>Improved JPQL for new queries, as suggested by mazz</pre> <h3>Modified Paths</h3> <ul> <li><a href="#rhqtrunkmodulescoredomainsrcmainjavaorgrhqcoredomainconfigurationConfigurationjava">rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/configuration/Configuration.java</a></li> </ul> </div> <div id="patch"> <h3>Diff</h3> <a id="rhqtrunkmodulescoredomainsrcmainjavaorgrhqcoredomainconfigurationConfigurationjava"></a> <div class="modfile"><h4>Modified: rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/configuration/Configuration.java (1960 => 1961)</h4> <pre class="diff"> <span class="info">--- rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/configuration/Configuration.java 2008-11-11 02:10:23 UTC (rev 1960) +++ rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/configuration/Configuration.java 2008-11-11 19:02:49 UTC (rev 1961) </span><span class="lines">@@ -102,9 +102,9 @@ </span><span class="cx"> + " AND ps.stringValue IS NOT NULL " // + "GROUP BY ps.stringValue"), // @NamedQuery(name = Configuration.QUERY_GET_PLUGIN_CONFIG_BY_RESOURCE_ID, query = "" // </span><span class="rem">- + "select c from Configuration c, Resource r where r.id = :resourceId and c = r.pluginConfiguration"), </span><span class="add">+ + "select r.pluginConfiguration from Resource r where r.id = :resourceId"), </span><span class="cx"> @NamedQuery(name = Configuration.QUERY_GET_RESOURCE_CONFIG_BY_RESOURCE_ID, query = "" // </span><span class="rem">- + "select c from Configuration c, Resource r where r.id = :resourceId and c = r.resourceConfiguration") }) </span><span class="add">+ + "select r.resourceConfiguration from Resource r where r.id = :resourceId") }) </span><span class="cx"> @SequenceGenerator(name = "SEQ", sequenceName = "RHQ_CONFIG_ID_SEQ") @Table(name = "RHQ_CONFIG") @XmlAccessorType(XmlAccessType.FIELD) </span> </pre> </div> </div> </body> </html> |