RE: Transactions

2005-05-26 Thread James, Steven
I usually keep my dao very fine grained (they look after a singular table). Ie each method of the dao only does one thing a singular insert, delete, select. my course grain service layer provides the exposed buiness logic which is made up of calls to the different dao required to perform that

FW: ibatis and global transactions

2005-05-23 Thread James, Steven
thanks brandon and rafiq. this is the route i will now explore. Ibatis is a fine product but the support on the forums here makes it something else. top job. Steve.. -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Fri 5/20/2005 6:33 PM To: James, Steven

ibatis and global transactions

2005-05-20 Thread James, Steven
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

sqlmapclients

2005-05-20 Thread James, Steven
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

RE: sqlmapclients

2005-05-20 Thread James, Steven
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] Inviato: venerdì 20 maggio 2005 12.52

session transaction

2005-04-01 Thread James, Steven
does anyone how to use ibatis to have a global transaction for a session. I am not using J2ee and the database is mysql 4.1.10. I have had a simple go at starting the transaction at the begining of a gui session and then not commiting but the database did not rollback. The jdbc is j-conector

RE: execute SQL statement that are not in a map

2005-03-23 Thread James, Steven
(id) values (1)); THX, steve. -Original Message- From: James, Steven [mailto:[EMAIL PROTECTED] Sent: 22 March 2005 17:00 To: ibatis-user-java@incubator.apache.org Subject: RE: execute SQL statement that are not in a map create a generic statement in a sqlmap statement id=Execute

RE: execute SQL statement that are not in a map

2005-03-22 Thread James, Steven
create a generic statement in a sqlmap statement id=Execute parameterClass=string #string /statement -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Tue 3/22/2005 3:16 PM To: 'ibatis-user-java@incubator.apache.org' Subject: execute SQL statement that are not

implimentation

2005-03-22 Thread James, Steven
Hi group, just looking for some opinions on this problem. I have a system which comprises of a number of application the applications access one of 2 databases (mysql, hsqldb) the 2 databases both have the same structure ie the tables are the same. They are replicated from mysql to hsqldb (the

RE: Getting the generate primary key

2005-03-17 Thread James, Steven
you need to add the selectKey resultClass=int keyProperty=id select LAST_INSERT_ID() /selectKey above is for mysql just change to olacle specific code. etc steve -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Thu

RE: Need help!!

2005-03-16 Thread James, Steven
I think i had this error and you need the optional xml jar files from your ibatis download. Steve -Original Message- From: Swati Singhal [mailto:[EMAIL PROTECTED] Sent: Wed 3/16/2005 9:36 AM To: ibatis-user-java@incubator.apache.org Subject: Need help!! Hi, I'm new to iBATIS and am

RE: Several dumb questions

2005-03-15 Thread James, Steven
Your idea of mapping students to courses is correct, although you do not have to have a pk in the mapping table if a studentid and course id row are unique which by the sounds of it they are. The pk is a composite. But if you want a pk key then you can. As to updating these mappings then if a

RE: Questions on N+1 and ParameterMap

2005-03-10 Thread James, Steven
hi Marty, Your query is not in the right context and is doing what you ask. You are doing a join and as you have to records in the sub table that meet the requirments of your join ie WHERE A.ALERT_ID=AC.ALERT_ID then two rows are returned. This is only good for N:1 situations. You have a N:M

RE: Questions on N+1 and ParameterMap

2005-03-10 Thread James, Steven
hi Marty, Your query is not in the right context and is doing what you ask. You are doing a join and as you have to records in the sub table that meet the requirments of your join ie WHERE A.ALERT_ID=AC.ALERT_ID then two rows are returned. This is only good for N:1 situations. You have a N:M

RE: cacheModel still hitting database

2005-02-22 Thread James, Steven
I have to agree with mark. I have been unable as yet to get this to work. I have tried using a select and statement. In both refering to the cacheModel, but if i change the underlying database vi client then the change is reflected in next select in the program. my DAO is persisting so in

RE: cacheModel still hitting database

2005-02-22 Thread James, Steven
Yes my settings are settings cacheModelsEnabled=true enhancementEnabled=true maxSessions=64 maxTransactions=8 maxRequests=128 / inmy sql.xml file cachemodel is set like this cacheModel id=tnodes-cache type=MEMORY flushInterval seconds= 360/