We use JBoss 3.2.5 and MySQL 4.0.21.
Our code creates database connections using the Driver class and the server.log shows:
<mbean code="org.jboss.resource.connectionmanager.TxConnectionManager" display-name="ConnectionManager for DataSource MySqlDS" name="jboss.jca:service=LocalTxCM,name=MySqlDS">truetrue<depends optional-attribute-name="ManagedConnectionPool"><mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" display-name="Connection Pool for DataSource MySqlDS" name="jboss.jca:service=ManagedConnectionPool,name=MySqlDS"><depends optional-attribute-name="ManagedConnectionFactoryName"><mbean code="org.jboss.resource.connectionmanager.RARDeployment" display-name="ManagedConnectionFactory for DataSource MySqlDS" name="jboss.jca:service=ManagedConnectionFactory,name=MySqlDS"><depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper<config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/lycea</config-property><config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property><config-property name="UserName" etc.
What is the difference between the ConnectionPooling used here vs. if we were to create a connection using a DataSource? Is tehre a performance difference?
Thank you.
Noga
