output problem

Hi,    i have made stored procedure in oracle and try to run the output in the store procedure through IBATIS. The problem is i am having two output parameters and i want to execute it in the IBATIS I am calling my procedure as <

iBatis batch executing same performance as Jdbc - Thanks!

I found out that all the problems I was having with OutOfMemoryErrors was related directly to the Java Proxy in my own code and not iBatis...my apologies. Outside of that...thanks for the help. I was able to do a successful batch implementation. When I excluded the startTransaction/commitTransa

Re: sql map via Java API

The advantages would be parameter mapping, resource management, and result mapping. The disadvantages are the increased potential for sql injection, a slight loss of performance, and potentially less concrete results (if you are putting them into a Map). Larry On 6/22/06, Yusuf <[EMAIL PROTECT

RE: sql map via Java API

just my opinion, but what's the point of using iBatis if you wanted to build a statement at runtime? maybe you can just use simple jdbc? yusuf -Original Message- From: Edwin Lukaweski [mailto:[EMAIL PROTECTED] Sent: Friday, June 23, 2006 3:28 AM To: user-java@ibatis.apache.org Subject: R

Re: Unsubscribe my mail ID from Ibatis forums...

Harinder, it's important that you understand this:We do not maintain the mailing lists.  YOU DO. Send an email to [EMAIL PROTECTED] to unsubscribe from each of the lists that you subscribed to.  For example:[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED]...It's pretty mu

Unsubscribe my mail ID from Ibatis forums...

Please unsubscribe my mail ID from iBatis mailing/forum list. Thank you, Harinder Nandyala http://www.ashakiran.org "The more you strive for humanity, the more civilized you become" -ASHA

Re: sql map via Java API

Yes - good one!!! However, just to carry this a bit further, ideally, I would like to have iBatis prepare this once and then use the prepared statement. As I understand it, 'remapResults=true' will force a lot of work due to examining the result set meta data. Also, I would imagine that

Re: sql map via Java API

Yeah, it's risky, but life is about risks, right? :-) $generatedSqlStatement$ Larry On 6/22/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote: Hi: Is there any way of submitting a new . SQL Map snippet via the Java API. Or, alternatively, is there a way of contructing an object, from i

sql map via Java API

Hi:       Is there any way of submitting a new . SQL Map snippet via the Java API. Or, alternatively, is there a way of contructing an object, from iBatis, that accomplishes the same thing?     What I am trying to do is build a SELECT statement at execution time, based on parameters ente

Re: Websphere 6 + iBatis + DB2 iSeries problem

Hi Jeff, Thanks for the link. I am almost sure that our code is working well ... before using iBatis we used it for applications using JDBC only and we had no problems even for applications with similar size. I am not 100% sure that our problem is not related with iBatis. Our opinion is that our

Re: Websphere 6 + iBatis + DB2 iSeries problem

No - the iBATIS configuration does not change anything about how the WebSphere connection pool or transactions work.  What I am saying is that if you go outside of iBATIS for some of your selects, then you need to make sure that your JDBC code is correct for the environment in which you are running

Re: Websphere 6 + iBatis + DB2 iSeries problem

Hi Jeff, My application does not create additional Thread. About JTA, you are saying if we are setting iBatis to use JTA, we also have to change our JDBC code? We are using Select + Scrollable ResultSet in order to move the cursoer to a specific position in the ResultSet ... this couldn't be han

Re: Websphere 6 + iBatis + DB2 iSeries problem

Hi, After logging out all users (600) of the application becomes very very fast, thread pool is almost empty, all Connections that were marked as "IN USE" now are "FREE" ... it is like we had many thread/connections locked. Any clue? Thank you, Cornel > Hi Jeff, > > We have the folowing probl

Re: Websphere 6 + iBatis + DB2 iSeries problem

This sounds like a different problem than what you first reported.  The thread pool being 100% utilized implies theoretically infinite response time.  In performance theory, the response time multiplier is 1/(1 - Utilization) - so there's a real problem with 100% utilization!   Is your application

Re: Websphere 6 + iBatis + DB2 iSeries problem

Hi Jeff, We have the folowing problem: - WAS Thread Pool is at 100% - WAS Connection Pool is at 66% and do not increase. The system runs very slow ... I have the feeling that many Threads are stucked as well as the Connections. There are very few Threads handling requests (from IE browser). One

Re: Websphere 6 + iBatis + DB2 iSeries problem

Hi, We will do it in the next 30 minutes and let you now! I forgot to tell you that we are using also lazyLoadingEnabled="false" Thanks a lot, Cornel > Please give it a try with the transaction configuration I sent previously. > > EXTERNAL will not work unless there are EJBs - the transacti

Re: Websphere 6 + iBatis + DB2 iSeries problem

Please give it a try with the transaction configuration I sent previously.   EXTERNAL will not work unless there are EJBs - the transactions are never being committed and that's why WebSphere is holding on to them.   JDBC should work, but I'm certain that JTA will work because that's what we use in

Re: Antwort: Re: Websphere 6 + iBatis + DB2 iSeries problem

Hi, reapTime=180 Unsed Timeout=1800 Aged Timeout=0 Regarding Aged Timeout, if the connection is considered as "in transaction", WAS never close it ... here is the info related to each connection that is in pool considered at in use but it is stucked: [EMAIL PROTECTED];RUNNING; MCWrapper id 29ae

Antwort: Re: Websphere 6 + iBatis + DB2 iSeries problem

What are the Reap Time, Aged Timeout and Unused Timeout settings for your application server? Maybe WAS never releases the connections [EMAIL PROTECTED] schrieb am 22.06.2006 16:19:37: > Hi, > > We are not using EJB but we have tested with: > - transaction manager type="JDBC" and type="EXTERNA

Re: Websphere 6 + iBatis + DB2 iSeries problem

Hi, We are not using EJB but we have tested with: - transaction manager type="JDBC" and type="EXTERNAL" but we have same problem ... after a while, the connection pool becomes full, nothing is executed on database. Websphere says all the connection are IN USE ... In our code, usually it stops w

Re: Websphere 6 + iBatis + DB2 iSeries problem

Unscribe this user group From: "Jeff Butler" <[EMAIL PROTECTED]> Reply-To: user-java@ibatis.apache.org To: user-java@ibatis.apache.org Subject: Re: Websphere 6 + iBatis + DB2 iSeries problem Date: Thu, 22 Jun 2006 08:32:49 -0500 I doubt this is an iBATIS issue. We have a large appliation usin

Re: Websphere 6 + iBatis + DB2 iSeries problem

I doubt this is an iBATIS issue.  We have a large appliation using WAS6, DB2, iBATIS and don't see these problems.   With your transaction configuration you are relying on WebSphere to commit the transactions.  To me, this implies you are using EJBs - so I would check the EJB configuration first to

Websphere 6 + iBatis + DB2 iSeries problem

Hi, We are facing a very big problem with WAS6 + iBatis 2.1.5 + DB3 iSeries (V%R3M0). We are performing the stressing test and after a while (usually 30-60 minutes) af activity, the connection pool from Websphere become full (100 connections allocated from 100) and everything is stucked. This hap

[datasource] [weblogic 9]

Hi,   I want to know if it’s possible to connect ibatis to a datasource with the sql-map configuration file ?   I’ve seen something like that :                dataSource>   but it doe

RE : RE : RE : RE : RE : RE : "invalid column type'

Ok, thank you very much !       -Message d'origine- De : Jeff Butler [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21 juin 2006 17:57 À : user-java@ibatis.apache.org Objet : Re: RE : RE : RE : RE : RE : "invalid column type'   I'll get it fixed