Data Source, Connection Pooling

[DMoy]

Hello All,
Could some one please explain the data-sources.xml file/usage other then
the rudimentary documentation on the web site.

For instance, how does one setup a connection pool?  Is it enough to use
the example and point your data source object to the JNDI location
specified in the data-sources.xml

I have tried this with both iNet's Opta Driver for SQL server and Hit
Softwares JDBC driver.  I can get a single connection using iNet and the
JNDI location "jdbc/PLDS"  but the Connection Pool does not work at all
when I reference "jdbcPLPooledDS".  I get a class cast exception.

Is there something I am missing,  do I need to use another class for the
connection pool, other then com.evermind.sql.ConnectionDataSource.



     <data-source
          class="com.evermind.sql.ConnectionDataSource"
          location="jdbc/PLDS"
          pooled-location="jdbc/PLPooledDS"
          xa-location="jdbc/PLXADS"
          ejb-location="jdbc/PLEJBDS"
          name="PL data-source"
          url="jdbc:inetdae:146.146.146.146:1433"
          connection-driver="com.inet.tds.TdsDriver"
          username="sa"
          password=""
     />