ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: R: maxTransactions DefaultValue
Date Wed, 06 Jun 2007 08:57:48 GMT
Did you even try the solution I posted earlier in this thread? But anyway, as Clinton says,
it'll probably be removed, so don't bother.





From: De Gaetano Giuseppe [mailto:degaetano@PITAGORA.IT] 
Sent: woensdag 6 juni 2007 9:08
To: user-java@ibatis.apache.org
Subject: R: R: maxTransactions DefaultValue


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.





Da: Clinton Begin [mailto:clinton.begin@gmail.com] 
Inviato: martedì 5 giugno 2007 23.23
A: user-java@ibatis.apache.org
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.  


On 6/4/07, De Gaetano Giuseppe <degaetano@pitagora.it> 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






Da: Niels Beekman [mailto:n.beekman@wis.nl] 
Inviato: venerdì 1 giugno 2007 19.41
A: user-java@ibatis.apache.org
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.





From: De Gaetano Giuseppe [mailto:degaetano@PITAGORA.IT] 
Sent: vrijdag 1 juni 2007 18:51
To: user-java@ibatis.apache.org
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.






View raw message