Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JTDS

 
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: 3320
61
  • 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
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!