Good thinking! That actually should be fairly simple to do, I'll get that done right now (shouldn't take very long).
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wouter Zoons Sent: Wednesday, December 15, 2004 6:46 AM To: [EMAIL PROTECTED] Subject: [Andromda-devel] ocl query translation for hibernate I have this OCL fragment as a finder query on an operation called "findValidByUser" of entity "MedicalCertificate": context MedicalCertificate::findValidByUser(userId:Long,date:Date) : Collection(MedicalCertificate) body findValidByUser : allInstances->select(certificate | certificate.user.id = userId and certificate.validityStart <= date and certificate.validityEnd >= date) note how there are two parameters to that operation, while I use them three times in total (userId is used once, and date is used twice) this translates into something like this (query + spring generated code): QUERY: ------ from be.sylis.vw.akvdt.medicalcertificate.MedicalCertificate as certificate where certificate.user.id = ? certificate.validityStart > ? or certificate.validityEnd < ?", userId, date) JAVA: ----- public List findValidByUser(...) { ... queryObject.setParameter(0, userId); queryObject.setParameter(1, date); ... IMHO it would be a better idea to do this instead: (in the query the question marks are replaced by the parameter names prefixed with a colon) (in the java code the parameter substitution is updated to reflect the change in the query) QUERY: ------ from be.sylis.vw.akvdt.medicalcertificate.MedicalCertificate as certificate where certificate.user.id = :userId certificate.validityStart > :date or certificate.validityEnd < :date", userId, date) JAVA: ----- public List findValidByUser(...) { ... queryObject.setLong("userId", userId); queryObject.setDate("date", date); ... doing so is IMO more inline with the OCL code, and it allows us to logically reuse parameters in the query itself how hard is this to do ? Chad, if you point me in the good direction I can do it if you want. -- Wouter ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ Andromda-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/andromda-devel ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ Andromda-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/andromda-devel
