A wise old hermit known only as <[EMAIL PROTECTED]> once said:
> > 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.
Be gentle with him, Aslak. If you read on, you'll see he's already been
to the JBoss forums - they told him it's because it's running outside a
transaction. It's related to XDoclet because he needs to know the right
tags to make sure it uses a transaction, and his attempts with different
ejb.transaction values don't seem to make any difference.
Andrew.
> > 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()"
-------------------------------------------------------
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
