Hi
I have some troubles with the performance of my finder query.
When call the method findAllAccounts (listed below) jboss exectute following
SQL-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
