Bugs item #615320, was opened at 2002-09-26 20:42 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=615320&group_id=22866
Category: JBossCMP Group: v3.1 >Status: Closed >Resolution: Out of Date Priority: 7 Submitted By: Peter Luttrell (objec) Assigned to: Dain Sundstrom (dsundstrom) Summary: Read-Ahead settings ignored Initial Comment: JBoss does not honor the read-ahead or fetch-size settings in the defaultjbosscmp-jdbc.xml file, nor the jbosscmp-jdbc.xml file under either the default or entity nodes. When you put it under the default node in either, it just appears to be ignored. I base this on the fact that I set it to fetch-size=1, readonly.strategy=none and the sql that the cmp engine generates based on a call to get<anything> on a bean results in a query such as this: 2002-09-26 20:35:30,834 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma nd.PersonalTrades] Executing SQL: select id, ....<all fields> from MYTABLE where (id=?) OR (id=?) OR (id=?)...there are 255 ORs, which i beleive is the default read only size. Now when you put the readonly element under the entity element in the jbosscmp-jdbc.xml file in the order required, deployment fails with a SAXParseException claiming that the read-only element is not allowed under entity. However i verified with ie's built in xml validator, that the xml is valid based on the dtd included with the 3.0.2 release ---------------------------------------------------------------------- >Comment By: Dain Sundstrom (dsundstrom) Date: 2002-09-26 23:51 Message: Logged In: YES user_id=251431 First off it is not defaultjbosscmp-jdbc.xml, but standardjbosscmp-jdbc.xml (I'm that is just a typo). I already fixed the read ahead problem (yesterday) in bug [ 594978 ] default page-size. This will be included in 3.0.3. As for fetch-size, I think you are confused about what it means. Fetch size is not page size. Fetch size simply calls setFetchSize on the database statement. Page size on the other hand determines number of entities that are loaded in a single opperation. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=615320&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
