Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 16427 invoked from network); 6 Jun 2007 07:08:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Jun 2007 07:08:46 -0000 Received: (qmail 53871 invoked by uid 500); 6 Jun 2007 07:08:47 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 53612 invoked by uid 500); 6 Jun 2007 07:08:46 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 53599 invoked by uid 99); 6 Jun 2007 07:08:46 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jun 2007 00:08:45 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of degaetano@pitagora.it designates 151.9.129.69 as permitted sender) Received: from [151.9.129.69] (HELO allserv.pitagora.it) (151.9.129.69) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jun 2007 00:08:39 -0700 Received: from pegaso.pitagora.it (pegaso.pitagora.it [10.99.1.31]) by allserv.pitagora.it (8.12.11.20060308/8.12.11) with SMTP id l56781f7014016 for ; Wed, 6 Jun 2007 09:08:08 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7A809.909F3E18" Subject: R: R: maxTransactions DefaultValue Date: Wed, 6 Jun 2007 09:07:56 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: R: maxTransactions DefaultValue Thread-Index: Acent9kdVbjrIU3ETOS4fHQpTYI/ogAUQZBA References: <50CA25BD6EEA954FA592C097399942E31915AB8E@CM1.wis.local> <16178eb10706051423i271d8648l22c0415576ca08a5@mail.gmail.com> From: "De Gaetano Giuseppe" To: X-Spam-Checker-Version: SpamAssassin 3.1.7 (2006-10-05) on allserv.pitagora.it X-Virus-Scanned: ClamAV 0.90/3367/Wed Jun 6 07:14:43 2007 on allserv.pitagora.it X-Virus-Status: Clean X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, score=-4.4 required=5.5 tests=ALL_TRUSTED,BAYES_00, HTML_MESSAGE autolearn=ham version=3.1.7 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7A809.909F3E18 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you for your attention. =20 I am going to set the value I want in XML and I look forward the next = release which will remove these artificial limits. =20 Giuseppe =20 ________________________________ Da: Clinton Begin [mailto:clinton.begin@gmail.com]=20 Inviato: marted=EC 5 giugno 2007 23.23 A: user-java@ibatis.apache.org Oggetto: Re: R: maxTransactions DefaultValue =20 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. :-)=20 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. =20 Clinton On 6/4/07, De Gaetano Giuseppe wrote: Thank you for your response. I am sorry If didn't regret in advance. =20 I changed my code in this way=20 =20 sqlMap. delegate.setMaxTransactions(75); =20 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. =20 Thank you in advance Giuseppe =20 =20 =20 ________________________________ Da: Niels Beekman [mailto:n.beekman@wis.nl]=20 Inviato: venerd=EC 1 giugno 2007 19.41 A: user-java@ibatis.apache.org Oggetto: RE: maxTransactions DefaultValue =20 maxSessions !=3D 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. =20 Niels =20 ________________________________ From: De Gaetano Giuseppe [mailto:degaetano@PITAGORA.IT]=20 Sent: vrijdag 1 juni 2007 18:51 To: user-java@ibatis.apache.org Subject: maxTransactions DefaultValue =20 Hi everybody , =20 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 =20 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 =20 This is a code sample of what I am trying to do. =20 SqlMapClientImpl sqlMap =3D (SqlMapClientImpl) SqlMapClientBuilder. = buildSqlMapClient(reader,newprops); sqlMap. delegate.setMaxSessions(75);=20 =20 =20 System. out.println( "*** MAXTRANSACTIONS =3D " + = ((SqlMapClientImpl)sqlMap). delegate.getMaxTransactions());=20 =20 =20 The output is MAXTRANSACTIONS =3D 32 or the value extracted in the = SqlMapConfig.xml file=20 For example < settings lazyLoadingEnabled =3D" true " maxTransactions = =3D" 50 "/> =20 Instead I expected an output like this MAXTRANSACTIONS =3D 75 =20 =20 =20 Thank you in advance. =20 Giuseppe =20 =20 =20 ------_=_NextPart_001_01C7A809.909F3E18 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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=EC 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=EC 1 = giugno 2007 19.41
A: user-java@ibatis.apache.org
Oggetto: RE: = maxTransactions DefaultValue

 

maxSessions !=3D 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 =3D (SqlMapClientImpl) SqlMapClientBuilder. = buildSqlMapClient(reader,newprops);

sqlMap. = delegate.setMaxSessions(75);

 

 

System. = out.println( "*** MAXTRANSACTIONS =3D = " + = ((SqlMapClientImpl)sqlMap). delegate.getMaxTransactions());

 

 

The = output is MAXTRANSACTIONS =3D 32 or the value extracted in the SqlMapConfig.xml = file

For = example < = settings = lazyLoadingEnabled = =3D" true " = maxTransactions = =3D" 50 = "/>

 

Instead I expected an output like this MAXTRANSACTIONS =3D = 75

 

 

 

Thank you in advance.

 

Giuseppe

 

 

 

------_=_NextPart_001_01C7A809.909F3E18--