Re: Logging Query Execution Time

2008-08-08 Thread Ian Zabel
Hey, what'ya know! haha At this point in time, I'm not using Spring w/ iBATIS. Just using my own DAO objects, and tomcat's JNDI connection. I've been considering moving to use Spring, but I'm not sure what it actually gets me (other than more XML to configure for all my DAOs, heh)... Is using Spri

Re: Logging Query Execution Time

2008-08-08 Thread Larry Meadors
Hey, I wrote that... It should be easy to use Spring AOP to do the same thing. If you don't want to, I may do it this weekend - I have a pet project I'm doing iB2+Spring on. If I do, I'll put up a new lesson on it. Larry On Fri, Aug 8, 2008 at 1:35 PM, Ian Zabel <[EMAIL PROTECTED]> wrote: > A

Logging Query Execution Time

2008-08-08 Thread Ian Zabel
Afternoon, all. I'd like to easily enable logging of the time it takes to run iBATIS queries. I found this article which is the basic idea http://www.learntechnology.net/content/misc/aop_oldskool.jsp But, it's written to use the deprecated iBATIS DAO. Is there any built-in way to enable this now

Re: Connection Pool Logging

2008-08-08 Thread Clinton Begin
Then it's completely up to the datasource provider. I think with WebLogic there was a connection pool stats feature, and I'd assume other app servers have something similar. Clinton On Fri, Aug 8, 2008 at 10:32 AM, Michael Schall <[EMAIL PROTECTED]> wrote: > We are using jndi. > > On Fri, Aug 8,

Re: Connection Pool Logging

2008-08-08 Thread Michael Schall
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 you're using SImpleDataSource, then y

Re: Connection Pool Logging

2008-08-08 Thread Michael Schall
We are using jndi. On Fri, Aug 8, 2008 at 11:30 AM, Clinton Begin <[EMAIL PROTECTED]>wrote: > If you're using SImpleDataSource, then yes. You can cast the > datasource into a simpledatasource and you'll find a method called > getStatus() > > public String getStatus() { >StringBuffer buffer =

Re: Connection Pool Logging

2008-08-08 Thread Clinton Begin
If you're using SImpleDataSource, then yes. You can cast the datasource into a simpledatasource and you'll find a method called getStatus() public String getStatus() { StringBuffer buffer = new StringBuffer(); buffer.append("\n

Connection Pool Logging

2008-08-08 Thread Michael Schall
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

Re: Close Connection after use?

2008-08-08 Thread Clinton Begin
Certainly not... :-) We'll need more information about your configuration: Which transaction manager are you using? Which data source? Which database driver Are you using Spring or EJB? Clinton On Fri, Aug 8, 2008 at 9:20 AM, SonyRaymond <[EMAIL PROTECTED]> wrote: > > Hi, > > I experience t

Re: Performance metrics between iBatis and Hibernate 3.2, or 3.x and above

2008-08-08 Thread Clinton Begin
I think we stopped comparing performance metrics about 4 years ago. :-) Generally speaking: * iBATIS has better query and load performance, from SQL to Object. * Hibernate has a better caching subsystem made possible by the additional information it has about the table/class mappings. Both

Close Connection after use?

2008-08-08 Thread SonyRaymond
Hi, I experience the following situation when using iBatis 2.2 with WebSphere 5.1 JNDI datasource, closing database connection after use will make the next getConnection() call gives error exception? (Connection is closed!) Is it normal? Thanks, Raymond -- View this message in context: http:

Performance metrics between iBatis and Hibernate 3.2, or 3.x and above

2008-08-08 Thread mule_user
Is any metrics avialble on performance comparisons between iBatis and Hibernate 3.2, or 3.x and above? -- View this message in context: http://www.nabble.com/Performance-metrics-between-iBatis-and-Hibernate-3.2%2C-or-3.x-and-above-tp18893258p18893258.html Sent from the iBATIS - User - Java maili

Re: 2.3.3 and Spring? Good to go?

2008-08-08 Thread Tom Duffey
On Aug 8, 2008, at 8:42 AM, Ian Zabel wrote: I've seen some recent traffic on this list saying that Spring is incompatible with iBatis 2.3.x. Is this still the case, or have these issues been resolved? Working for me: iBATIS 2.3.3 build# 720 Spring 2.5.6 nightly build + lots of other crap :)

Re: 2.3.3 and Spring? Good to go?

2008-08-08 Thread Ingmar Lötzsch
I'am using iBatis 2.3.0.677 with Spring 2.5.2. spring.jar (2008-03-01) aspectjweaver.jar (v. 1.5.4 I think) cglib-nodep-2.1_3.jar Ian Zabel schrieb: I've seen some recent traffic on this list saying that Spring is incompatible with iBatis 2.3.x. Is this still the case, or have these issues been

RE: Thread starvation - pool / Throttle issue?

2008-08-08 Thread Brian Parkinson
HI Clinton: Looks like the issue has been resolved - been running the server for some time now, and no starvation issues seen (knocks wood loudly). I made 3 changes: 1. Refactored some code to remove a possible contention/deadlock issue. 2. Upgrade to iBatis 2.3.3.720. Everything looks great

RE: 2.3.3 and Spring? Good to go?

2008-08-08 Thread Brian Parkinson
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

2.3.3 and Spring? Good to go?

2008-08-08 Thread Ian Zabel
I've seen some recent traffic on this list saying that Spring is incompatible with iBatis 2.3.x. Is this still the case, or have these issues been resolved? Thanks! Ian.

resultClass, properties not set

2008-08-08 Thread Ingmar Lötzsch
Hallo, I'am using Ibatis 2.3.0.677. Under certain circumstances properties of the result class are not set, although contained in the result map. This happens, when the only property of a result map is mapped to a result map. The essence is, that does not work, because the property t

Re: SQL DESCRIBE command with iBatis

2008-08-08 Thread Jeff Butler
If you look in the DB2 information center under the DESCRIBE command, you will see this: This statement can be embedded only in an application program. It is an executable statement that cannot be dynamically prepared. This means that you cannot run DESCRIBE with iBATIS. If you want to get col

SQL DESCRIBE command with iBatis

2008-08-08 Thread Gregor Cremosnik
Hi, I have tried to execute an SQL DESCRIBE command to get the table definition with iBatis. But I get always an error. Command in the XML file: <>result property="sqlLen" column="sqllen"/> resultMap> DESCRIBE OUTPUT SELECT * FROM FC017713.IUMOREP StackTra