[JBoss jBPM] - Using non-qualified column reference WARN messages?
by dleerob
Hi,
When retrieving the latest Process Definitions like so:
| System.out.println("Getting Process Definition List...");
| JbpmContext jbpmContext = null;
| List processDefinitions = null;
| try {
| JbpmConfiguration jbpmConfiguration = JbpmConfiguration.getInstance();
| jbpmContext = jbpmConfiguration.createJbpmContext();
| GraphSession graphSession = jbpmContext.getGraphSession();
| processDefinitions = graphSession.findLatestProcessDefinitions();
| }
| catch (Exception e) {
| e.printStackTrace();
| }
| finally {
| jbpmContext.close();
| }
| System.out.println("Get List returned: "+processDefinitions.size() +" process definitions.");
|
The Process Definitions are returned, but I get the following warning messages in my log. Anyone know what causes this? And is it something to worry about?
| 13:09:37,281 WARN [FromElementType] Using non-qualified column reference [processInstance -> ([PROCESSINSTANCE_])]
| 13:09:37,875 WARN [FromElementType] Using non-qualified column reference [isSuspended -> ([ISSUSPENDED_])]
| 13:09:37,875 WARN [FromElementType] Using non-qualified column reference [token -> ([TOKEN_])]
| 13:09:38,203 WARN [FromElementType] Using non-qualified column reference [id -> ([ID_])]
| 13:09:38,328 WARN [FromElementType] Using non-qualified column reference [processInstance -> ([PROCESSINSTANCE_])]
| 13:09:39,437 WARN [FromElementType] Using non-qualified column reference [isSuspended -> ([ISSUSPENDED_])]
| 13:09:39,484 WARN [FromElementType] Using non-qualified column reference [token -> ([TOKEN_])]
| 13:09:39,609 WARN [FromElementType] Using non-qualified column reference [processInstance -> ([PROCESSINSTANCE_])]
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4070069#4070069
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4070069
19Â years
[JBoss Seam] - query order by extension and restrictions
by jamesjmp
hi!
setting the order of a query result by configuration may be done this way:
<framework:entity-query name="jmpRstReport4"
ejbql="select rstReport from RstReport rstReport"
order="code desc"/>
I wonder if there is a way of doing the same by extension.
I have a POJO DAO this way:
@Name("rstReportList")
private static final String[] RESTRICTIONS = {
"lower(rstReport.rstStatus.description) like concat(lower(#{rstReportList.rstReport.rstStatus.description}),'%')",
"lower(rstReport.rstStatus.description) not like lower(#{'TEMPLATE'})",
"lower(rstReport.shortDescription) like concat(lower(#{rstReportList.rstReport.shortDescription}),'%')",
};
public class RstReportList extends EntityQuery {
@Override
public String getEjbql() {
return "select rstReport from RstReport rstReport";
}
}
Apart from adding "order by code desc" to the ejbql code, how may I set the order by extension?
On the other hand, if 2 pages need the same query but with different restrictions. the best way would be to define 2 queries, each one with its proper restriction/s, or is there a way to set restrictions dinamycally by means of a parameter or something like that?
For instance I have a component called "myQuery". Once I want to use it with restriction 1, but in other page I want to use it with restriction 2 and not applying 1. is that possible? Defining 2 queries (each with its restriction) works fine and solves the problem. but is that the best way?
thanks in advance!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4070057#4070057
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4070057
19Â years