thanks for defending me andrew.
you must excuse me, i am developing with jboss and xdoclet for
just a few weeks.
i solved problem in the meanwhile (it just works, if i use a read-ahead
strategy).
nice greetings,
rudi
>
> 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()"
--
+++ 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
