wood burning stoves*
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
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: JTDS