Watch the first change in the release.txt from version 2.3.1
o Removed maxTransactions, maxRequests, maxSessions from configuration, all
are now controlled by the resource providers
We were (unknowingly) relying on these throttles and had a couple of tense
days figuring out how to have the conta
nt(columnName);
> }
> So the actual Integer creation is done by the driver.
> On Thu, Mar 4, 2010 at 11:53 AM, Michael Schall
> wrote:
>>
>> I have been doing some performance tuning and looking a heap dumps.
>> The number of Integer objects in memory is staggering. Loo
I have been doing some performance tuning and looking a heap dumps.
The number of Integer objects in memory is staggering. Looking at the
1.5 java docs, using Integer.valueOf should help.
http://java.sun.com/j2se/1.5.0/docs/api/java/lang/Integer.html#valueOf(int)
This could be extended to most of
Anyway to just tell the webservers (I assume JNDI) to drop all prepared
statements?
On Tue, Jul 21, 2009 at 4:09 PM, Glenn Barnard wrote:
> restart your webservers!
>
>
> On Tue, Jul 21, 2009 at 5:00 PM, Michael Schall wrote:
>
>> We run are running iBATIS within WebSphere
We run are running iBATIS within WebSphere 6.1 on Windows using JNDI against
a DB2 database. During a performance tuning session we found a query using
an index that did not have a vital column. We added the missing column to
the end of the index on a test database and using a db2 query analyzer
I would like to run multiple queries within a single select statement using
IBATIS connecting to DB2 UDB.
Following the suggestion from
http://www.mail-archive.com/d...@ibatis.apache.org/msg02858.html. I tried to
add the allowMultiQueries setting on the connection URL but I still get an
error
Are you really using all 200,000 data points in your graphs or are you
summarizing? Can you use SQL to generate summery information and graph that?
On Tue, Oct 21, 2008 at 9:45 AM, Larry Meadors <[EMAIL PROTECTED]>wrote:
> Why do you think queryForList in a loop will work better?
>
> Larry
>
>
>
> something not working with what's in the WIKI?
>
> Jeff Butler
>
>
>
> On Wed, Aug 27, 2008 at 2:07 PM, Michael Schall <[EMAIL PROTECTED]>wrote:
>
>> Is there anyone out there using iBATIS with JNDI within WebSphere without
>> EJBs that is willing
e internals and
> I don't know the answer for sure.
>
> As to whether one is better than the other in your specific case, I can't
> say. If it's not broke, don't fix it. If it is broke, give JTA a try to
> see if it makes a difference. Then you'll know.
We are using iBATIS in a large application that does not use EJBs and it
works great. We are seeing some issues where we are using more connections
than we think we should be. We are wondering if we have some issues with
connections/transactions not closing as fast as we would like them to. Our
This is our transactionManager node
On Fri, Aug 8, 2008 at 11:32 AM, Michael Schall <[EMAIL PROTECTED]>wrote:
> We are using jndi.
>
>
> On Fri, Aug 8, 2008 at 11:30 AM, Clinton Begin <[EMAIL PROTECTED]>wrote:
>
>> If yo
buffer.append("\n averageOverdueCheckoutTime " +
> getAverageOverdueCheckoutTime());
>buffer.append("\n hadToWait " +
> getHadToWaitCount());
>buffer.append("\n averageWaitTime" +
> getAverageWaitTime());
>buffer.a
Is there a way to know when a connection is retrieved from the pool and
returned to the pool and how long the request for a connection takes? I
have looked at the ConnectionLogProxy, but I assume this is too late in the
game. We already have the connection at that point?
The problem I'm tring to
Lance -
I'm pretty sure this is only a proposed feature for 3.0. Jason's example is
the only way of mapping columns to properties that I'm aware of in 2.x.
http://opensource.atlassian.com/confluence/oss/display/IBATIS/iBATIS+3.0+Whiteboard#iBATIS3.0Whiteboard-SomePossibleConfigurationOptions
Mi
Production Environment:
We are using a JNDI datasource in WS 6.1 (fixpack 15) to connect to a DB2
9.1 (fixpack 2) database on a separate cluster.
We recently upgraded our Java version of iBATIS after falling way behind
from 2.0.9 to the latest release 2.3.1.
The dev and test environment showed no
I think you will have to escape the # in #temp
So references to your temp table would be ##temp. In some databases ##
means something, but if trace what is actually sent to the database and it
should be a single #. If you need ## sent to the database, you will have
double each so you would have
For the record, the .Net version has the same sql/include concept. It also
has the extends attribute. I have not used "extend" to extend statements,
but is is very nice to extend parameter and result maps.
On Wed, May 21, 2008 at 2:49 PM, Josh Joy <[EMAIL PROTECTED]> wrote:
> Cool...even better
Sorry... Sent the message while formating my xml...
We have recently moved to using JNDI through WebSphere as our JDBC
transaction manager while connecting to a DB2 9.1 database.
Below is my transactionManager and settings elements from my
sqlmap-config.xml file.
I am wondering if the following
We have recently moved to using JNDI as our JDBC transaction manager.
I'm attempting to perform two statements within a single insert. We are
using DB2 and I thought ; was the separator, but I get SQLSTATE: 42601. I
have tried several possible solutions with no luck. Has anyone seen this or
able to offer an idea? Is this even possible?
Thanks
Mike
I am happy to report that switching over to JDNI has removed the excessive
rollbacks. Thanks for all you help.
Mike
On Wed, Mar 5, 2008 at 1:50 PM, Michael Schall <[EMAIL PROTECTED]>
wrote:
> We have the commitRequired="false" so the code does not explicitly call
> roll
>
> For example (pseudocode):
>
>
>
> int n = select count(*) from categories;
>
> List list = select * from categories;
>
>
>
> n == list.size() is only guaranteed if both statements were run in an
> isolated transaction scope.
>
>
>
> Clinto
I saw the commitRequired, but why are we creating the transaction in the
first place? Or is this a Sybase requirement that the rest of us have had to
live with?
On Wed, Mar 5, 2008 at 11:44 AM, Christopher Lamey <[EMAIL PROTECTED]>
wrote:
> Doh! Forgot about "commitRequired" - been using Spring
I would like to make this configurable by adding a property and code
something like the following...
Thoughts?
Mike
public List queryForList(SessionScope sessionScope, String id, Object
paramObject, int skip, int max) throws SQLException {
List list = null;
MappedStatement ms = get
24 matches
Mail list logo
