File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JTDS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JTDS" Watch "JTDS" New topic
Author

JTDS

Mariya Antony christopher
Ranch Hand

Joined: Jan 24, 2012
Posts: 49

How to perform connection pooling using JTDS

kindly Suggest the comments
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

I don't think connection pooling is in any way related to the driver you are using.
So any where you find information about connection pooling will be relevant.
Tim Moores
Rancher

Joined: Sep 21, 2011
Posts: 2408
jTDS supports ConnectionPoolDataSource if memory serves, if you want to hook it into a servlet container or app server. I'm sure you can find the class name of the pooled connection class in the documentation.

Alternatively, Apache Commons DBCP is a common choice for the pool implementation.
nishant vaishnaw
Greenhorn

Joined: Feb 27, 2013
Posts: 22
Do i need to write JAVA code also to estiblish the connection using JTDS from shell script, as my below code is giving error :
# script for testing jtds using perl script
#!/usr/bin/perl -w


"jdbc:jtds:sqlserver://wsdb0200:3176/RADTI;user=radadmin;password=telstra1";


Error:
jtds_testing.pl: jdbc:jtds:sqlserver://wsdb0200:3176/RADTI;user=radadmin;password=telstra1: not found
 
Consider Paul's rocket mass heater.
 
subject: JTDS
 
Similar Threads
Is there such a thing as a free SQL Server JDBC driver on windows?
Using a Datasource to connect to database
JDBC driver for MS SQL-Server 7.0
Update query
Problem in connecting to SQL server using jtds driver