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=""
/>
