[JBoss-user] [Persistence & CMP/JBoss] - Re: finderMethod only works with a few result Elements (smal
You would better choose eager-load-group so that on-find page-size is not used ;) The on-find page-size is used only to preload (on-load kind) fields that were not preloaded on-find. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835851#3835851 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835851 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: finderMethod only works with a few result Elements (smal
"ironbird" wrote : | ...But why are you using the on-load option ? With the number of beans you are loading, on-find is better I think. | You can put also this read-ahead tag within the query tag of your finder if you want using on-find just for the finder. | Thanks a lot, it seems to work :) Last Question: But can you recommend a good value for the "on-find" page size or depends this on the Collections size (which is between 1 and up to 1500 entries sometimes) ? Thorsten View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835848#3835848 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835848 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: finderMethod only works with a few result Elements (smal
After a look at your descriptors, We can say that you are not using the XA driver. Try to cut out the | 2 | 20 | tags. You are already using a read-ahead opion: | on-load | 1000 | * | | But why are you using the on-load option ? With the number of beans you are loading, on-find is better I think. You can put also this read-ahead tag within the query tag of your finder if you want using on-find just for the finder. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835755#3835755 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835755 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: finderMethod only works with a few result Elements (smal
Hi again, You should use XDoclet to generate the descriptors. The tag is : anonymous wrote : | @jboss.read-ahead | strategy="on-find" | page-size= | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835747#3835747 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835747 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: finderMethod only works with a few result Elements (smal
Hi westmeier, You comfort me because my account also got lost, so I was asking myself if I was running on a third dimension (like in a bad movie but so real ;-). So, You says that you are using the 3.2.4 version. I have seen other recent topics (but some are destroyed now) about the 3.2.4 version problems. Do you try the 3.2.3 version ? I confirm that it works fine with 1000 elements in a collection retreived from a finder usins the XA driver. Normally, the "SelectMethod=Cursor" is the default if you do not change it in the -ds file. I think also that specifying read-ahead option with a fixed page-size on version 3.2.4 can help, because there is some differences between two versions on this subject. Alex (loubyansky), the JBoss CMP guru says on the previous topic that the version 3.2.3 was bugged for on-find read-ahead option for single object finder. But for both topics, everything works fine with 3.2.3 version, and is ugly or crashes with 3.2.4 version. So, conclude yourself. Iron, the metallic bird from Atlantica. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835743#3835743 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835743 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: finderMethod only works with a few result Elements (smal
Thanks for your tips! 1) I cannot use the old Version 3.2.3, because of another bug in this version, which is fixed in my 3.2.4 RC1, but I will try the new 3.2.4 RC2 this evening. May'be this helps! 2) I use the SelectMethod=Cursor in my connection String, this would not be the solution :( 3. + 4.) JDBC XA and read-ahead with fixed page-size: I'm relatively new to JBoss and don't know exactly what you mean by these things. I use the SQL Server 2000 SP3a and JDBC Driver SP2. Are there any further entries in the configuration files needed? My configuration-files are: --- datasource: MSSQLDS jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ProMtDB;SelectMethod=Cursor com.microsoft.jdbc.sqlserver.SQLServerDriver PmDBUser xyzyx 2 20 standardjaws.xml: java:/MSSQLDS MS SQLSERVER2000 standardjbosscmp-jdbc.xml: java:/MSSQLDS MS SQLSERVER2000 true false false 30 false true false foreign-key on-load 1000 * 1000 UUIDKeyGeneratorFactory java.lang.String VARCHAR VARCHAR(32) View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835739#3835739 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835739 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: finderMethod only works with a few result Elements (smal
Here the first answers, before the thread got lost: Part of my Error Message: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Die Datenbank hat ein unspezifizierter Fehler zurückgegeben First answer: sorry lost authors nameQ Transation type not required ? Do you try with JBoss 3.2.3 (3.2.4 series not stable for me) ? Try also to specify read-ahead option with a fixed page-size. Posts: acoliver Posted: Sun May 23, 2004 12:47 PM It says teh database has given an unspecified error. I think the read-ahead with pagesize might help. Also, I think you're using the XA datasource version of the driver. Give the NON-XA version a try if you're not using distributed transactions (and if you don't know if you are then you probably aren't). Writing good XA drivers is hard, I highly doubt Microsoft's fairly new driver for Java is a very successful implementation. Andrew C. Oliver Mail Services Lead JBoss, Inc. Posts: ironbird Posted: Sun May 23, 2004 14:04 PM It works fine for me under JBoss 3.2.3 with a collection of 1000 elements (with the MSSQL XA driver). So for me 3 solutions: 1) JDBC XA procedures perhaps not installed 2) CMP engine for JBoss 3.2.4 bugged (other topics in this forum seems to prove that). 3) Use read-ahead with fixed page size to prevent the CMP engine making its own choices. Posts: gorano Posted: Sun May 23, 2004 17:36 PM Did you add "SelectMethod=Cursor" in your connection string to MSSql? Using the jdbc driver from MS do not using cursors for larger resultsets if this parameter is not specified, and it fails. /Goran View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835734#3835734 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835734 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id149&alloc_id?66&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
