Wouldn't it be better to be EJB-QL compliant and leave the query to the app
server? It would make the code more portable, but maybe less efficient,
since the app server would do the query, and not the rdbms. -And I guess
JBoss doesn't support it yet, but it should. What I mean is something like
query="select * from order where ctry = ?1.code"
(I really hope my Lotus Notes email doesn't look too bad on the mailing
list :)
:aslak
|--------+------------------------->
| | "Vincent Harcq"|
| | <vincent_harcq@|
| | yahoo.com> |
| | |
| | 17.08.2001 |
| | 07:54 |
| | Please respond |
| | to |
| | vincent.harcq |
| | |
|--------+------------------------->
>-----------------------------------------------------------------------------------------------------------------------|
|
|
| To: "Dmitri Colebatch" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
|
| cc: <[EMAIL PROTECTED]>
|
| Subject: RE: [Xdoclet-devel] request: sql generation
|
>-----------------------------------------------------------------------------------------------------------------------|
Hi,
>this could also include mass data queries, done via jdbc rather
> than ejbFinder, and should be a lot cheaper... not sure if this is
> relevant though.
Do you want to create these methods inside the Bean ?
In a Home method ?
Something like @ejb:catalog name="catalogByCountry(Country ctry)"
type="OrderDetail" query="select * from order where ctry = {1}.getCode()"
That create a Home method ejbHomeCatalogAll()
And use the jboss:column-name (hum...) to do the mapping automatically to
the "type" detail object ? And return a Collection of these Detail
Object...
Just an idea, but that would be nice...
Then complete DAO support for BMP Bean would be nice also...
>
> cheers
> dim
>
Vincent
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
_______________________________________________
Xdoclet-devel mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/xdoclet-devel
