Thank you for your attention.
I am going to set the value I want in XML and I look forward the next release which will remove these artificial limits. Giuseppe ________________________________ Da: Clinton Begin [mailto:[EMAIL PROTECTED] Inviato: martedì 5 giugno 2007 23.23 A: [email protected] Oggetto: Re: R: maxTransactions DefaultValue You can set these values in XML.....however you cannot set them after the fact with code as you have. It's too late by that point, as everything is pooled. Regardless...you shouldn't mess with this anyway. Just use the defaults. There's absolutely no way you're running 32 simultaneous transactions on one box. :-) If you are, I want stock in your database software provider. Also, these artificial limits will go away soon anyway, while they are a performance benefit most of the time, they cause confusion and take the responsibility away from the app server or database -- where it should be. Clinton On 6/4/07, De Gaetano Giuseppe <[EMAIL PROTECTED]> wrote: Thank you for your response. I am sorry If didn't regret in advance. I changed my code in this way sqlMap. delegate.setMaxTransactions(75); Now the output is the value I setted, but the maximum number of connection created is 32. I guess that in case there is no setting in the SqlMapConfig.xml the default value is 32. Can anybody confirm my guessing. Thank you in advance Giuseppe ________________________________ Da: Niels Beekman [mailto:[EMAIL PROTECTED] Inviato: venerdì 1 giugno 2007 19.41 A: [email protected] Oggetto: RE: maxTransactions DefaultValue maxSessions != maxTransactions, try setMaxTransactions(). But anyway, I don't know if settings these values after construction is even supported. You'd better put them in your 'newprops' variable, and then referencing them in the sqlmap-config. Niels ________________________________ From: De Gaetano Giuseppe [mailto:[EMAIL PROTECTED] Sent: vrijdag 1 juni 2007 18:51 To: [email protected] Subject: maxTransactions DefaultValue Hi everybody , I would like to know if it is possible to set the default value of the variable maxTransaction, without doing any setting in the SqlMapConfig.xml file I have seen that it is possible to set this value in the SqlMapConfig.xml using the tag settings. In case you don't use this setting the default value is 32 This is a code sample of what I am trying to do. SqlMapClientImpl sqlMap = (SqlMapClientImpl) SqlMapClientBuilder. buildSqlMapClient(reader,newprops); sqlMap. delegate.setMaxSessions(75); System. out.println( "*** MAXTRANSACTIONS = " + ((SqlMapClientImpl)sqlMap). delegate.getMaxTransactions()); The output is MAXTRANSACTIONS = 32 or the value extracted in the SqlMapConfig.xml file For example < settings lazyLoadingEnabled =" true " maxTransactions =" 50 "/> Instead I expected an output like this MAXTRANSACTIONS = 75 Thank you in advance. Giuseppe
