hi matthieu,
this is a known issue with ojb 1.0.x. have you tried it with ojb 1.1 ?
jakob
[EMAIL PROTECTED] schrieb:
Hello list,
i'm willing to use a function that needs 2 parameters (ie: concat).
If one parameter is not a column or an attribute OJB acheive to produce
correct code.
Example:
public static void fooDAO(PersistenceBroker broker)
{
String[] attributs = {"CONCAT(char(max(purchaseDate)), 'bar')"};
ReportQueryByCriteria query = new ReportQueryByCriteria(purchase.
class, attributs, null);
Iterator iter = broker.getReportQueryIteratorByQuery(query);
}
but if i put two parameters that are either attributes or column name then
ojb failed to replace the attributes (if the two parameters are column
names of course it works but there is a side effect problem with the table
alias).
Also: is there a way to get table alias or to set it in order to avoid some
troubles when you use direct SQL ?
Cordialement
Matthieu PATOU
DINQ/DSIN/SIDM/VNVO/VOIN
Téléphone 01 30 19 17 91 (29 17 91)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
