In general we might define a function like func(a, b, c) and the order of arguments might be different in different dialects. (I am not sure we need this though. This is how JBossCMP does it.) So just '?' won't work.
oh - so you can define it as locate(?1, ?3, ?2) and
when you call it with locate(a,b,c) it would be transformed into locate(a,c,b) ?
:name is a bit more complex. How would you call a function in case of using :name?
If the above is true, I would say locate(:1, :3, :2) would be just as nice (even imagine dateconvert(:year, :month, :day, :hour, :seconds)) which for me says much more.
And if you support ?[0-9]+ syntax, then i guess the parsing would be the same - just
:[a-z]+ instead - or am i totally offbeat here...
but again - it's mostly the for me "unneedded" extra syntax i would like to avoid...
/max
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: Wednesday, December 22, 2004 1:23 PM To: Hibernate development Subject: Re: [Hibernate] new template-based hql functions
On Wed, 22 Dec 2004 06:10:57 -0600, Alexey Loubyansky <[EMAIL PROTECTED]> wrote:
Looks nice.
Stupid question again from me - any reason why you use ?1 syntax and not just ? or :name here ? (Just to keep the syntaxes for placeholders down at a minimum ,)
/max
> This is committed now. > To define a new function template you create an instance of > SQLFunctionTemplate which implements SQLFunction and register it in a > dialect as any other SQLFunction, e.g. > > registerFunction("locate", new > SQLFunctionTemplate(Hibernate.INTEGER, "locate(?1, ?2, ?3)")); > > By the spec, this locate function might have 2 or 3 parameters. So, > you define 3 in the template but can pass just 2. > > If the template is not found for a specific dialect when generating > SQL, the function will appear in the generated SQL as it appears in > the EJB/H-QL statement. I.e. it is how it worked before. > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> Alexey Loubyansky >> Sent: Wednesday, December 22, 2004 12:39 PM >> To: Max Andersen; Hibernate development >> Subject: RE: [Hibernate] new template-based hql functions >> >> > > concat(?1 || ?2) is parsed not as one argument but three, >> > since there >> > > are three tokens, i.e. ?1, || and ?2. >> > >> > oh - afraid of sounding stupid, but shouldn't that be parsed as a >> > functioncall(expression) ? >> > where expression is (x op y) in this case ? >> >> Yes, sorry, of course, it is parsed like this. >> I had a bug in creating an argument list. It works now. >> >> Thanks. >> >> >> ------------------------------------------------------- >> 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/ >> _______________________________________________ >> hibernate-devel mailing list >> hibernate-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/hibernate-devel >>
-- Max Rydahl Andersen callto://max.rydahl.andersen
Hibernate [EMAIL PROTECTED] http://hibernate.org
JBoss Inc [EMAIL PROTECTED] http://jboss.com
------------------------------------------------------- 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/ _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-- Max Rydahl Andersen callto://max.rydahl.andersen
Hibernate [EMAIL PROTECTED] http://hibernate.org
JBoss Inc [EMAIL PROTECTED] http://jboss.com
-------------------------------------------------------
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/
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
