Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP 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
Bartender
Posts: 2891
46
  • 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