-
1. Re: Syntax Error on Generated SQL
triathlon98 Apr 2, 2004 3:33 AM (in response to michaellee)I would say this looks like a Sybase problem.
You can not really control how JBoss "generates" SQL, but you can tell it the SQL code to use using "declared-sql". See CMP docs.
Joachim -
2. Re: Syntax Error on Generated SQL
michaellee Apr 2, 2004 8:28 PM (in response to michaellee)Thank you for the suggestion. Using <declared-sql>, the problem is fixed.
Regadrs,
Michael -
3. Re: Syntax Error on Generated SQL
mburdman Nov 18, 2005 8:39 AM (in response to michaellee)Gracias!!!! Thanks!!
with something like this my problem with the NOT EXISTS in Sybase was solved.
XDoclet
* @ejb.finder query=""
* signature="java.util.Collection
* findCabecerasById_cuenta(java.lang.Integer ointId_cuenta)"
*
* @jboss.declared-sql signature="java.util.Collection findCabecerasById_cuenta(java.lang.Integer ointId_cuenta)"
* description="Fuerzo el query de not exists para que no use campo0, campo1"
* where= "(H_COMPROBANTE.Id_cuenta = {0} AND
* NOT EXISTS (SELECT 'comprobantes modificadores'
* FROM H_MODIFICA comprobantesModificadores
* WHERE H_COMPROBANTE.Id_comprobante=comprobantesModificadores.Comp_Modificador))"