Hi, just a quick feedback then I will come back with more details.
Following your instructions and replacing the pom with: ------------------------------------------ /<project xmlns="http://maven.apache.org/POM/4.0.0"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd";> <modelVersion>4.0.0</modelVersion> <groupId>com.test</groupId> <artifactId>TestApp</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>war</packaging> <description>To test tomee pooling when XA driver</description> <dependencies> <dependency> * <groupId>org.apache.tomee</groupId> <artifactId>apache-tomee</artifactId> <version>7.0.0-SNAPSHOT</version>* <scope>provided</scope> </dependency> </dependencies> <build> <plugins> <plugin> <artifactId>maven-compiler-plugin</artifactId> <version>3.3</version> <configuration> <source>1.7</source> <target>1.7</target> </configuration> </plugin> <plugin> <artifactId>maven-war-plugin</artifactId> <version>2.6</version> <configuration> <warSourceDirectory>${project.basedir}/WebContent</warSourceDirectory> <failOnMissingWebXml>true</failOnMissingWebXml> </configuration> </plugin> <plugin> * <groupId>org.apache.tomee.maven</groupId> <artifactId>tomee-maven-plugin</artifactId> <version>7.0.0-SNAPSHOT</version>* <configuration> *<tomeeVersion>7.0.0-SNAPSHOT</tomeeVersion>* <tomeeClassifier>plus</tomeeClassifier> <port>8080</port> <debug>false</debug> <debugPort>5005</debugPort> <args>-Dfoo=bar</args> <config>${project.basedir}/src/test/resources</config> <libs> <lib>mysql:mysql-connector-java:5.1.35</lib> </libs> <reloadOnUpdate>true</reloadOnUpdate> </configuration> </plugin> </plugins> </build> * <repositories> <repository> <id>my-repo1</id> <name>your custom repo</name> <url>https://repository.apache.org/content/groups/snapshots/</url> </repository> </repositories>* * <pluginRepositories> <pluginRepository> <id>my-plugin-repo</id> <name>Maven Plugin Repository</name> <url>https://repository.apache.org/content/groups/snapshots/</url> <layout>default</layout> <snapshots> <enabled>true</enabled> </snapshots> <releases> <updatePolicy>never</updatePolicy> </releases> </pluginRepository> </pluginRepositories>* </project>/ ------------------------------------------ the *connections leaking is gone*. And if I also replace MaxActive with MaxTotal (I guess newer versions relies on a different pool manager) I can also control the maximum number of connections opened towards MySql. I guess that maybe also other parameters in the resource definition will need to be renamed (i.e. the shrinking of the pool doesn't occur every 40 seconds only for connections older than 25 seconds, but nearly instantaneously). One thing I noticed though is that all my "System.out"s in my test code do not show up anymore (although the application is evidently running). It is not in maven console and not in catalina logs. I also see that the newer SNAPSHOT version relies on Tomcat 8. The reason behind my testing is to go in prod with tomee 1.7.x relatively soon with an application (coming from websphere) which uses distributed XA quite heavily. I got stuck on the db XA pooling and still missing testing of jms XA pooling and effectiveness of db+jms XA. So now I am a bit puzzled about how to progress. Suggestions are welcome? :) -- View this message in context: http://tomee-openejb.979440.n4.nabble.com/org-apache-openejb-resource-jdbc-dbcp-BasicManagedDataSource-allocating-more-than-MaxActive-connectis-tp4676508p4676617.html Sent from the TomEE Users mailing list archive at Nabble.com.
