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.xmlfile I have seen that it is possible to set this value in the SqlMapConfig.xmlusing 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
