0 Replies Latest reply on Jan 18, 2006 1:27 PM by Noga Woronoff

    Connection pooling using Driver class vs. DataSource Class

    Noga Woronoff Newbie

      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