Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JTDS  RSS feed

 
Mariya Antony christopher
Ranch Hand
Posts: 49
Hibernate Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to perform connection pooling using JTDS

kindly Suggest the comments
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Saloon Keeper
Posts: 3564
77
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!