0 Replies Latest reply on Feb 24, 2003 2:48 PM by mekatoka

    Problem while fetching records from EB using SB

    mekatoka Newbie


      I am using JBoss 3.0.4 and CMP 2.0 presently.


      --> I have a SLSB accessing an CMP EB, the EB has a composite PK with 3 fields, all of them are java.net.InetAddress.

      --> I am using the default hypersonic database that ships with the JBoss.

      --> I have noticed that i can create any number of entries for the CMP EB, but when i try to fetch the records from the EB, i can only fetch 32 records at a time. If i try to fetch more than 32, the transaction rolls back.

      I have gone through alot of forums, for instance the following

      http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ post suggests BMP, and some say increase the transaction-timeout in the standardjboss.xml or increase the cache size and so on.

      But none really work out, cuz,

      (1) The cache size in the jboss 3.0.4 is 1000,000
      (2) I want to avoid BMP as much as possible

      What is the solution for such kind of situation ?

      Also i have the following post, which i think will help alot in this situation ?

      http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ Toka