ibatis and global transactions

Hi I working on an application where the services and buisness domain objects are sitting on a server with ibatis providing the data access layer support. The clients which are swt client connect to the server and via rpc calls. Our customer want us to rollback all db changes during a user logi

R: A really bad N+1 solution

That's nothing ridicule in solving a problem, Mark.   That's why we're payed for. :) Da: Mark Bennett [mailto:[EMAIL PROTECTED] Inviato: giovedì 19 maggio 2005 20.28A: ibatis-user-java@incubator.apache.orgOggetto: A really bad N+1 solution For your enjoyment here is how I solved the N+1 p

sqlmapclients

For each gui client connecting to a server is it better to have a sqlmapclient for each or a shared client for all. steve.. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to

R: sqlmapclients

Since each SqlMapClient instance is related to a single database, but can support many client requests (see cfg file), I think you'd not have to provide an instance for each client, until they use the same db. Fabrizio -Messaggio originale- Da: James, Steven [mailto:[EMAIL PROTECTED] Inv

RE: sqlmapclients

Thanks for the reply i think i need to futher explain i think. My gui connect to a rpc server which has an ibatis layer and one sqlclient. All the clients that can concurrently connect to the db share the same sqlmapclient. SWT GUI Clients --> rcp persisted middle ware -> ibatis Does mean i

RE: [HELP] I can't not type < sign in my sqlmap xml file

Use <   Mansour J   From: Pham Anh Tuan [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 5:06 AM To: ibatis-user-java@incubator.apache.org Subject: [HELP] I can't not type < sign in my sqlmap xml file   Hi,   I can't not type < sign in sql definition xml

Re: How to obtain results looking for a NULL

I want that: #1 if ParameterClass: object.setA(""); object.setB("VALUE B"); then Statement: SELECT * FROM TABLE WHERE A="" AND B="VALUE B" #2 if ParameterClass: //object.setA("");

iBATIS + Websphere 5.1?

Hello all, We're considering to take iBATIS as the data mapper for our new projects, but it would be necessary to use JTA transactions to integrate it with CICS and MQ too. Following the iBATIS documentation, I've set the transaction manager as "JTA" and I've added a "UserTrans

Re: Iterate problem

Yeah i know what is going on. File a JIRA issue and i'll be sure to get to it. Brandon On 5/20/05, Niels Beekman <[EMAIL PROTECTED]> wrote: > Hi, > > Latest one, 2.1.0. > I looked in ConditionalTagHandler.java and it uses some Probe-instance > to find the property, as soon as this Probe encounte

Re: How to obtain results looking for a NULL

Ok good example. Here is how I would acomplish this. select * from table_name A = #A# A is null B = #B# B is null This statement will give you 4 differ

Re: ibatis and global transactions

You can manage your transactions with EXTERNAL of JTA. I believe that EXTERNAL is the better route to go in this case. This means that you will need to configure and manually start and stop your transactions outside of ibatis. Search the DAO pdf doc and the SQL Maps pdf doc for external to get more

Re: sqlmapclients

Each call that goes into the server is it's own thread. So, there should be no issue. It's the same as though you were accessing via a servlet based front end. With the web you have a bunch of users calling only one sqlmap client. I don't see where this would be a problem. Are you running into some

Re: iBATIS + Websphere 5.1?

can you please provide us with your JNDI configuration, dao.xml and sqlmapconfig.xml? That will give us the full context of your configuration. Then we will be more equipped to assist you. Brandon On 5/20/05, Santamaria Franco, Inaki <[EMAIL PROTECTED]> wrote: > > Hello all, > >

R: sqlmapclients

As far I know, this is the way iBATIS works with a single database. It's not slow, because each request has its own separate thread. Furthermore, since iBATIS is running on the server side of your system, there's no difference (from its point of view) if the caller is a swing client or a web fron

RE: ibatis and global transactions

Brandon, [ ... The JTA option in ibatis is tied to a single datasource. ...] In my project, I am using a JTA transaction manager and have multiple data sources (using XA-drivers). So far, I have not seen anything unusual. Is there something I need to be aware of when using JTA and distributed tra

RE: Iterate problem

Ok, done: http://issues.apache.org/jira/browse/IBATIS-131 Niels -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: vrijdag 20 mei 2005 15:09 To: ibatis-user-java@incubator.apache.org Subject: Re: Iterate problem Yeah i know what is going on. File a JIRA issue and i'

Re: sqlmapclients

The SqlMapClient is thread safe. You singleton class should simply retrieve a single instance of the SqlMapClient. A single SqlMapClient will handle mutliple threads without issue or collision. The SqlMapClient internally makes use of ThreadLocal for storing thread specific information. Brandon O

Re: ibatis and global transactions

Sorry, I should be more clear. You would have a separate sqlmap for each datasource. Your sqlmap would be tied to the datasource via JNDI. You would also have your global transaction specified as a JNDI context as well. So each datasource has a sqlmap, each sqlmap has a SINGLE JNDI specified data

Re: iBATIS + Websphere 5.1?

Also try EXTERNAL as a transaction manager type instead of JTA.  The the difference is that iBATIS will allow WebSphere fully control the transaction...which is generally better with any IBM product. Cheers, Clinton On 5/20/05, Santamaria Franco, Inaki <[EMAIL PROTECTED]> wrote: Hello all

iBatis 2.0.9 Dynamic Statement Problem

Title: iBatis 2.0.9 Dynamic Statement Problem I'm not sure if this came through the first time or not, so I'm resending it. I apologize in advance if this is a double post. All, I'm using 2.0.9 w/ a dynamic statement (passing in a Map), but it doesn't appear to be building the Prepare

RE: ibatis and global transactions

Thanks for clarifying. Yes, we do have two separate sqlmaps for each datasource. -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 12:48 PM To: ibatis-user-java@incubator.apache.org Subject: Re: ibatis and global transactions Sorry, I should be

Re: iBatis 2.0.9 Dynamic Statement Problem

Not sure if this will fix your problem but you should always declare your parameter class if possible, for performance reasons.  In your case parameterClass="map" should be enough.NathanOn May 20, 2005, at 2:05 PM, Jerry Jalenak wrote: I'm not sure if this came through the first time or not, so I'

iBatis 2.0.9 Dynamic Statement Problem?

All, I'm using 2.0.9 w/ a dynamic statement (passing in a Map), but it doesn't appear to be building the PreparedStatement completely.     public void getUserInfo(UserInfo ui)         throws SQLException     {         Map m = new HashMap();         m.put("lastName", ui.getLastName() + "%");    

Re: iBatis 2.0.9 Dynamic Statement Problem

Jerry,You might also try isNotNull instead of isNotEmpty.NathanOn May 20, 2005, at 2:05 PM, Jerry Jalenak wrote: I'm not sure if this came through the first time or not, so I'm resending it. I apologize in advance if this is a double post. All, I'm using 2.0.9 w/ a dynamic statement (passing

Re: Re: Future releases

All iBATIS resources are listed here: http://www.ibatis.com/resources.html Clinton On 5/19/05, Chipomho <[EMAIL PROTECTED]> wrote: can i have the URL where i can post my ideas.>> From: Brandon Goodin <[EMAIL PROTECTED]>> Date: 2005/05/20 Fri PM 02:26:10 GMT+12:00> To: ibatis-user-java@incubator.