"Daniel Ferrante" <[EMAIL PROTECTED]> writes:
> I am trying to debug why my application constantly dies (or hangs)
> after 100 connections are created. I have made sure that I am
> closing all the connections to the database in my code (that is
> anywhere I make a direct connection to the database not using the
> entity beans).
I am not sure what the limits of your mysql/jdbc-driver combo are wrt
concurrent connections. There could be OS limitations as well.
You can make a direct connection to the database by getting the
DataSource via JNDI and then use it just like with BMP. There is an
example of that in the JBoss docs IIRC. You could drop the entity
bean stuff entirely and just access the DB from session beans. In
some cases this is quite desirable, as I found out.
> I understand since Blocking is set to true that it waits for a new
> connection. Is this a problem with CMP, mySQL, or do you see
> anything in the XADataSourceLoader.
In the first place I'd check my OS limitations for concurrent network
connections and then the database and make sure that the driver
doesn't bomb out. It's quite unlikely that it's XADataSourceLoader.
Try setting the max value to 200 and see whether the problem persists.
Posting your OS info as well as your mysql and jdbc driver versions
can help as well.
--
Nicolai P Guba http://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
