----- Original Message -----
From: Schneider <[EMAIL PROTECTED]>
Date: Thursday, October 3, 2002 11:32 am
Subject: [Xdoclet-user] run method in a transaction?
> Hi
>
> I have some troubles with the performance of my finder query.
>
Then I suggest you go to the JBoss forums. I don't see how finder
performance on JBoss is related to XDoclet.
Aslak
> When call the method findAllAccounts (listed below) jboss exectute
> followingSQL-queries:
>
> SELECT AccountId, AccountText FROM ACCOUNT WHERE (AccountId=0) OR
> AccountId=1) OR (AccountId=2) OR (AccountId=3)
> SELECT AccountId, AccountText FROM ACCOUNT WHERE (AccountId=0) OR
> AccountId=1)OR (AccountId=2)
> SELECT AccountId, AccountText FROM ACCOUNT WHERE (AccountId=0) OR
> AccountId=1)
> SELECT AccountId, AccountText FROM ACCOUNT WHERE (AccountId=0)
>
> as you can see an absolut performance disaster.
> I read in the JBossCMP document that this is normal if the method
> don't run
> in a transaction. After that i tried to change the ejb.transaction
> type for
> the method findAllAccounts to RequiresNew, but without any effect.
> I also tried to add the same to the ejb.finder, nothing happend.
>
> Now I absolutly don't know what i should do to solve this problem.
>
> I am using JBoss 3.0.3; XDoclet CVS-Version two weeks ago.
>
> thanks in advance,
> rudi
>
> /**
> * @ejb.transaction type="RequiresNew"
> * @ejb.interface-method view-type="both"
> **/
> public ArrayList findAllAccounts()
> {
> AccountLocalHome accountHome;
> ArrayList result;
>
> try
> {
> accountHome = AccountUtil.getLocalHome();
> result =
> AccountUtil.convertFromEntityBeanListToAccountValueListLocal
(accountHome.findAll());
> ......
>
> signature of findAll-Finder:
> @ejb.finder signature="java.util.Collection findAll()"
>
> --
> +++ GMX - Mail, Messaging & more http://www.gmx.net +++
> NEU: Mit GMX ins Internet. Günstige DSL- & Modem/ISDN-Tarife!
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Xdoclet-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/xdoclet-user
>
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Xdoclet-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/xdoclet-user
