-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ashoknan,
On 5/6/2009 5:43 PM, ashoknan wrote: > This app was running fine in Weblogic but after migrating to Tomcat > 6+ DBCP we are seeing the below exception. Which version of TC 6 are you using? Are you using the stock DBCP or Filip's new-fangled DBCP? > We also looked our code base for any threading or concurrency issues..we > were not able spot any issues. Famous last words. > I have observed one more thing..why checkOpen in DelegatingPreparedStatement > didn't catch this but OracleStatement thinks the statement is closed. What makes you say that DelegatingPreparedStatement.checkOpen is being called and seeing an incorrect state? I suspect you (or the Spring folks?) are unwrapping the pooled statement at some point to expose its Oracle-ness, and then you are (incorrectly) closing the underlying statement instead of closing the wrapping (pooled) statement as you should be. > org.springframework.jdbc.object.SqlUpdate.update(SqlUpdate.java:168) > at > com.dao.DealXAuditTrailDaoBase.insertDealXAuditTrailVoBase(Unknown Source) This code (yours?) is calling SqlUpdate.update. What does your code look like around here? Are you using any transactions? > at com.deal.DealTO.insertAuditTrail(DealTO.java:183) > at com.deal.DealTO.processAuditTrail(DealTO.java:168) > at com.deal.DealTO.update(DealTO.java:110) The code around here might be useful to see, too. > validationQuery="select count(*) from dual"/> That's a weird one. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkoCRHkACgkQ9CaO5/Lv0PD01gCdH7IHL1q8iXbTmRp9HVyciRNi wJQAnjvN+vEcyoW7TWOGnD0G04506cCO =aFGJ -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
