Help! I am writing a Flex/Java app. In a nutshell, it polls a backend (Java Dao) every so often. This java method, in turn, fetched information from a database.
Its a thing of beauty which will allows (will) to monitor obscenely complex processes; makes for a sweet demo. I'm stumped at Flex opening a db connection for every request. Before long, I have 100+ open connections :( Looking at connections in MySQL workbench, I see all these 'sleeping' connections which Bazeds won't drop unless I cycle the service. If my app dies, it gives 'org.hibernate.exception.jdbcconnectionexception: cannot open connection'. If I manually kill a few connections in MySQL workbench, all is well again (until I run out of connections again). I thought I was mismanaging my connections in Hibernate but no changes in cfg (even with c3p0) bear fruit. Calling method form eclipse does not do this; only when called from flex app. Has anyone run into anything similar? Any bits of wisdom? ThanksÂ… Mario
