Hi, this is the way I used the JTDS driver in WAS 6.1 and 7 .
I copied the jtds jar to local dir - ex D:\IBM\WebSphere\AppServer\lib\jtds-1.2.5.jar
then I created the JDBC for it from Resources\JDBC Providers, choose the scope, type=defined by user, implementation name=net.sourceforge.jtds.jdbcx.JtdsDataSource, save and sync.
Get inside the JDBC and create a Data source, (from this point on you have 2 options, create a DataSource or a DataSource V4 - older version -), I use V4.
Define the JDNI that you will use, and leave all the rest default.
then once the data source is created, get inside the datasource, and click on custom properties, there if you chose the V4 DS you have to add the following properties:
databaseName
portNumber
serverName
if you chose the Datasource (without V4) you will have a list of the properties that you can use, so you just look for these 3 properties and fill out the value field.
Once you finish you can
test the connnection.
Hope it helps!
Adrian -