1 Reply Latest reply on Nov 12, 2003 3:31 AM by hergaty

    design help needed - large cmp import - array sorting...

    wunderkind

      Hello helpers,

      i would be really thankful if you'd help me considering this design problem:

      I use a SessionFacade (stateless) to provide a coarse grained method for database import. It contains a collection with aprox. 36.000 members. This collection has
      to be sorted to build up correct value objects for
      the generation of the entity ejbs. This results into a transaction timeout at the moment...

      My question is: Is there a nicer way to ensure sorting
      within a transaction other than increasing transaction timeout?

      thank you all -

      sven alias wunderkind

        • 1. Re: design help needed - large cmp import - array sorting...
          hergaty

          Hi sven,

          you can do sorting before enter a transactioned method of the session bean. Write another method with the transaction attribute "NotSupported", do the sorting in it and then call the transactioned import-method on the SessionContext with ((YourLocalInterface) ctx.getLocalObject()).import(...);

          Hope that helps,
          Thomas