FreeTDS Development Group

["Christian Amann" <c.amann AT ac-multimedia.de>]

Hello Friends,

did anybody ever tried Poolman (www.codestudio.com) with freeTDS? Everything
works, for example, with JdbcOdbc-Bridge from Sun, but not with freeTDS.
Here is a snippet of my poolman.xml:

<dbname>testdb</dbname>
<jndiName>jndi-testdb</jndiName>
<driver>com.internetcds.jdbc.tds.Driver</driver>
<url>jdbc:freetds:sqlserver://192.168.0.6/mytestdb</url>
<username>testuser</username>
<password>mypassword</password>


...and a snippet of my code:


Connection con = null;
DataSource ds = PoolMan.findDataSource("jndi-testdb");
try {
        con = ds.getConnection();
}
catch (SQLException e) {
        out.println(e.getMessage());
}


... this causes the following exception:


SQLException occurred in JDBCPool: java.sql.SQLException params:
com.internetcds.jdbc.tds.Driver,
jdbc:freetds:sqlserver://192.168.0.6/mytestdb. Please check your username,
password and other connectivity info.

Any Ideas?


Kind Regards,

Christian Amann