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.

 

Niels

 

________________________________

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.

 

Giuseppe

 

________________________________

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.  

Clinton

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

Giuseppe

 

 

 

________________________________

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.

 

Niels

 

________________________________

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.

 

Giuseppe

 

 

 


Mime
View raw message