I think he's talking about getting JBossCMP to generate a 'CREATE INDEX' 
statement at the time of table creation, to optimize the database end of 
the finder.

speculation, but that's something I'd want. Except that it never occured 
to me and I always just added the indexes manually. Oh, well.

hth,
danch

Anthony Geoghegan wrote:
> EJBQL (CMP 2.0) does not support ORDER BY statements.
> Thus, I don't believe you can index a finder method in standard EJBQL.
> The various JBoss specific QL overrides though support it (e.g.. JBossQL).
> Is this what you mean?
> 
> Best Regards,
> Anthony Geoghegan.
> J2EE Developer
> CPS Ireland Ltd.
> ----- Original Message -----
> From: "Kevin Conner" <[EMAIL PROTECTED]>
> To: "'jboss users'" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 10, 2002 5:20 PM
> Subject: [JBoss-user] RE: Indexing of finders
> 
> 
> 
>>>I have a simple question which I hope will have a simple answer :-)
>>>
>>>I have been going through the jboss 3.0.2 source to try and find out
>>>if there is any way to enable indexing for finder methods.  So far I
>>>have been unable to find any mechanism for achieving this.
>>>
>>>Can anyone tell me if this is possible and, if so, what I have missed
>>>in enabling it?
>>
>>Sorry, forgot to add that this is for CMP entity beans with finders
> 
> written
> 
>>in EJBQL.
>>
>>Thanks,
>>Kev
>>
>>Kevin Conner
>>Orchard Information Systems Limited
>>Newcastle Technopole, Kings Manor
>>Newcastle Upon Tyne, NE1 6PA. United Kingdom
>>Registered in England, Number 1900078
>>Tel: +44 (0) 191-2032536  Fax: +44 (0) 191 2302515
>>
>>
>>-------------------------------------------------------
>>This sf.net email is sponsored by: OSDN - Tired of that same old
>>cell phone?  Get a new here for FREE!
>>https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
>>_______________________________________________
>>JBoss-user mailing list
>>[EMAIL PROTECTED]
>>https://lists.sourceforge.net/lists/listinfo/jboss-user
>>
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone?  Get a new here for FREE!
> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user





-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to