| Selection criteria in any mapping [message #1282041] |
Tue, 01 April 2014 19:55 |
 Senen de Diego
Messages: 1
Registered: April 2014 |
Junior Member |
|
|
I'm trying to use Eclipselink with dbase tables (*.dbf files) where there are some indexes defined with expressions such as "STR(ID,7)".
I'm using a jdbc driver that is able to use those indexes, but only when the SQL sentence executed contains the same exact expression in the WHERE clause.
That is, a SQL sentence like
SELECT * FROM MASTER WHERE STR(MASTER_ID,7)=STR(?,7)
SELECT * FROM MASTER WHERE MASTER_ID=?
Without using the indexes the queries can be really slow, and I'm trying to force the platform to generate the right SQL sentences.
I'm failing miserably...
In a DescriptorCustomizer I can attach a selection criteria to certain classes of mappings (collections) such as this:
public class MasterCustomizer implements DescriptorCustomizer {
@Override
public void customize(ClassDescriptor descriptor) throws Exception {
OneToManyMapping detailsMapping = (OneToManyMapping) descriptor.getMappingForAttributeName("details");
ExpressionBuilder eb= new ExpressionBuilder(detailsMapping.getReferenceClass());
Expression where = eb.getField("MASTER_ID").getFunction("str", 7).equal(eb.getParameter("MASTER_ID").getFunction("str", 7));
detailsMapping.setSelectionCriteria(where);
}
}
But that's all I've got. I haven't found a way of attaching such a selection criteria to a DirectToFieldMapping for the Master.id attribute which is what, I think, would allow me to retrieve/update/delete a Master entity by its primary key using the index.
I've also found that the ObjectBuilder has a primaryKeyExpression attribute that could also be used to this purpose, if not in a general way (for any filtering where the attribute with the index appears) at least to find entities by its primary key, and I've tried to populate this attribute inside the MasterCustomizer.customize method:
ExpressionBuilder eb = new ExpressionBuilder(descriptor.getJavaClass());
Expression where = eb.getField("MASTER_ID").getFunction("str", 7).equal(eb.getParameter("MASTER_ID").getFunction("str", 7));
descriptor.getObjectBuilder().setPrimaryKeyExpression(where);
So my question is:
Is it possible to customize the mapping to a column in a way that any filtering by that column is done using an expression?
|
|
|
Powered by
FUDForum. Page generated in 0.03580 seconds
] 
Search
Help
Register
Login
Home
