RE: Spring with IBatis and Transaction Manager Helps.

. Brian Parkinson. --- x8 snip SqlMapConfig contains: Spring transactions: Spring datasource: com/ecobee/foundation/dao/ibatis/SqlMapConfig.xml

RE: Re : Question: "Connection.close has already been closed"

s.doGetConnection(dataSource)); So my understanding would be that you need to encapsulate the datasource in a TransactionAwareDataSourceProxy and inject it in the SqlMapClientFactoryBean. I hope this helps! Regards Gilles - Message d'origine De : Brian Parkinson <[EMAIL PROTE

RE: Question: "Connection.close has already been closed"

picked up from spring. I've got this up and running now - hopefully this will fix the Connection.close() issue. Thanks a bunch. Regards, Brian Parkinson --- x8 snip iBatis: .. etc. Spring: com/ecobee/foundation/dao/iba

RE: Question: "Connection.close has already been closed"

g bean (id="dataSource") into the SqlMapConfig file (under the transactionManager) element? Any advice on best practices appreciated - the configuraiton of the datasource, spring, transaction manager, etc. isn't completely clear to me. Cheers, Brian Parkinson... _

Okay, for the last time: Connection.close() has already been closed.

Thanks. Brian Parkinson --- x8 snip ERROR 15:45:16:428 Error selecting user from dataabase. {foundation.schedule.DbConnectionPing.executeTask} Message: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.MySQLNonTra

Question: "Connection.close has already been closed"

Thanks. Brian Parkinson --- x8 snip ERROR 15:45:16:428 Error selecting user from dataabase. {foundation.schedule.DbConnectionPing.executeTask} Message: Could not open JDBC Connectio

RE: Manual for Ibatis

Thanks. Brian Parkinson --- x8 snip ERROR 15:45:16:428 Error selecting user from dataabase. {foundation.schedule.DbConnectionPing.executeTask} Message: Could not open JDBC Connectio

RE: Thread starvation - pool / Throttle issue?

statements are technically correct. I look forward to seeing the results of the new test. Cheers, Clinton On Wed, Aug 6, 2008 at 9:21 AM, Brian Parkinson <[EMAIL PROTECTED]> wrote: Hi Clinton - Just for clarification 1. Using Spring for transa

RE: 2.3.3 and Spring? Good to go?

I am using iBatis 2.3.3.720 and Spring 2.5.1. Works for me. Brian... -Original Message- From: Ian Zabel [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2008 9:43 AM To: user-java@ibatis.apache.org Subject: 2.3.3 and Spring? Good to go? I've seen some recent traffic on this list say

RE: Thread starvation - pool / Throttle issue?

ake care of resource allocation. But your statement was: "but my understanding is that the DBCP connection pool handles all that for me (?)", which is not the case. Clinton On Wed, Aug 6, 2008 at 7:57 AM, Brian Parkinson <[EMAIL PROTECTED]> wrote: > > HI Clinton: > &

RE: Thread starvation - pool / Throttle issue?

connections, or a DB deadlock. Clinton On Wed, Aug 6, 2008 at 7:18 AM, Brian Parkinson <[EMAIL PROTECTED]> wrote: HI Nicholoz - looked at that thread - thx. A key issue seems to be not closing connections, but my understanding is that the DBCP con

RE: Thread starvation - pool / Throttle issue?

arvation - pool / Throttle issue? Have a look at this thread: http://www.mail-archive.com/user-java@ibatis.apache.org/msg11828.html Good luck On Wed, Aug 6, 2008 at 4:47 PM, Brian Parkinson <[EMAIL PROTECTED]> wrote: Hello: So, I have things up and running under

Thread starvation - pool / Throttle issue?

Hello: So, I have things up and running under Java and iBATIS, but running into some starvation issue, and my server is locking up. When I dump threads, I see a bunch that are waiting for the connnection pool (see output #1 below) and as well, a bunch that are waiting on Throttle.increment (see ou

Question(s) about DAO setup - possible Throttle deadlock?

ppreciated - regards, Brian Parkinson Avaning Inc. [EMAIL PROTECTED] --- x8 snip com/ecobee/foundation/dao/ibatis/SqlMapConfig.xml

Performance question

very long time to update the rows. The overall size of the BLOB is about 2K or so (not that big). Any hints or suggestions appreciated - I'm not a DB guy. Regards, Brian Parkinson Avaning Inc.

Question about replication and such things

Hello: Likely this is a little off-topic for this forum, but wondering if there is anyone with some advice. I'm using iBATIS with Spring Transations on MySQL 5.0.X and it's completely great - all working fine. Aside note - imho one issue that makes iBATIS (and Spring) so lovely to use is that wh

RE: Safe to replace valueObject in RowHandler?

Seconded - great book. parki... From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 11:36 AM To: user-java@ibatis.apache.org Subject: Re: Safe to replace valueObject in RowHandler? Or you can buy iBATIS in Action... http://www.

RE: Performance question

Thanks Christopher! I'll rip out the startTransaction, commit and endTransaction stuff from the code (now that Spring is taking care of this). One final question if you don't mind: I wasn't quite sure in your answer whether the startBatch/executeBatch should work properly under the setup I have

RE: Performance question

ation was new for Spring 2.0. So you'll see a different style for any older examples. This new way is better, so ignore the old ones. Cheers, Chris On 1/9/08 3:43 PM, "Brian Parkinson" <[EMAIL PROTECTED]> wrote: > Thanks Christoper - it's end of day here (frustrating o

RE: Performance question

ent style for any older examples. This new way is better, so ignore the old ones. Cheers, Chris On 1/9/08 3:43 PM, "Brian Parkinson" <[EMAIL PROTECTED]> wrote: > Thanks Christoper - it's end of day here (frustrating one :-) and so > I'll tackle these tomorrow - appr

RE: Performance question

ion management going on. Try throwing an new RuntimeException("Forcing transaction rollback") halfway through that method. See if everything before the exception is throw is actually handled and rolled back. Cheers, Chris On 1/9/08 3:16 PM, "Brian Parkinson" <[EMAIL PROTECTE

RE: way to get resultSet as a list w/out putting data in class

rieve results in the java code. w/ hashMap we can just do map.get(\"propertyName\"); On 12/18/07, Brian Parkinson <[EMAIL PROTECTED]> wrote: Hi - > > One may might be to implement a row handler. > > parki... > > > -Original Message- > From: > Sent: M

RE: way to get resultSet as a list w/out putting data in class

Hi - One may might be to implement a row handler. parki... -Original Message- From: bhaarat Sharma [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 3:44 PM To: user-java@ibatis.apache.org Subject: way to get resultSet as a list w/out putting data in class Hello, I am trying

RE: Newbie tries to solve the N+1 selects problem and cries for help

Subject: RE: Newbie tries to solve the N+1 selects problem and cries for help In this case, you have to implement a row handler. Christian From: Brian Parkinson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 12:14 PM To: user-java

RE: QueryforList and Generics

Hi Stefano: Just put that magic line right above the method that is complaining, and the warning will go away. parki... From: Stefano Tranquillini [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 12:37 PM To: user-java@ibatis.apache.org Sub

Newbie tries to solve the N+1 selects problem and cries for help

Hello: I am having a problem with the ol' N+1 selects problem - wondering if someone can help. I have a Status object, which contains a list of StatusEquipment objects, as well as a list of StatusZone objects. I want, in one select statement, to retrieve the one Status object, and populate

RE: MySQL related question - constraint violation

, huh?! parki... -Original Message- From: Toby Thain [mailto:[EMAIL PROTECTED] Sent: Thursday, December 06, 2007 3:15 PM To: user-java@ibatis.apache.org Subject: Re: MySQL related question - constraint violation On 6-Dec-07, at 11:46 AM, Brian Parkinson wrote: > Hello - > > Won

MySQL related question - constraint violation

Hello - Wondering if someone out there has some MySQL experience - running into a weird issue, and I'm stumped. This is perhaps not exactly an iBATIS issue, but I received no response over at the MySQL forums, so it's worth a shot: I have a very simple data model working in iBATIS (getting famili

RE: A couple newbie questions

Hi Larry: I wasn't going to use column indexes (fragile) but this solution is perfect. Thanks. parki... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Wednesday, December 05, 2007 11:06 PM To: user-java@ibatis.apache.org Subject: R

RE: A couple newbie questions

THER_BORK from ... 2. Batches are only for inserts, updates, deletes. They do not apply for selects. Jeff Butler On Dec 5, 2007 3:57 PM, Brian Parkinson <[EMAIL PROTECTED]> wrote: Hello! I'm new to iBATIS, but loving it so far - decided to go with iBATIS as opposed to H

A couple newbie questions

Hello! I'm new to iBATIS, but loving it so far - decided to go with iBATIS as opposed to Hibernate for simplicity, and to have arguably more control over the SQL. I have a couple questions (apologies if these are covered in hthe FAQ, but I couldn't find): 1. I have a pretty complex join, an