[jboss-user] [JCA/JBoss] - Re: Message DB + Oracle database connection count problems

[adrian@jboss.org]

Lots of random assertions with no real evidence.
If you really want some help, then use "READ THIS FIRST" to gather that evidence.

The only thing we know for certain is that something is marking a transaction
for rollback (this isn't necessarily a transaction timeout - but it is most likely)
and that your application is leaking connections probably when errors occur.

There hasn't been a single bug found in the JCA connection pooling code
since this horrible bug (3 years ago).
http://viewvc.jboss.org/cgi-bin/viewvc.cgi/jbossas?view=rev&revision=22057
(That's not say to one still doesn't exist, just nobody has been clever
enough or unlucky enough to find it :-)

In this case, your not in an EJB or servlet context, so you aren't going to
get much help from the appserver checking you closed things properly.

anonymous wrote : 
  | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)
  | at com.mobilgw.sam.common.cp.celcom.WFCelcomComponentFactory.(WFCelcomComponentFactory.java:120)
  | at com.mobilgw.sam.plugin.celcom.CheckAllowBlacklist.checkSubscriberForAllowBlackList(CheckAllowBlacklist.java:159)
  | at com.mobilgw.sam.plugin.celcom.CheckAllowBlacklist.execute(CheckAllowBlacklist.java:80)
  | at com.mobilgw.sam.executionengine.adapter.JavaAdapterHandler.execute(JavaAdapterHandler.java:84)
  | at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:575)
  | at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:460)
  | at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:586)
  | at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:460)
  | at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:455)
  | at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:361)
  | at com.mobilgw.sam.executionengine.queue.SmsService.run(SmsService.java:575)
  | at java.lang.Thread.run(Thread.java:534) 
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4066637#4066637

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4066637