Re: sqlserver.jdbcdriver Thread safe?
- From: Joe Weinstein <joeNOSPAM@xxxxxxx>
- Date: Wed, 17 May 2006 12:26:09 -0700
Dan Rychlik wrote:
Good afternnon,
I have been developing an application in Java that will connect to multiple modems at one time, push update files, and then remotely execute the right script to perform the update into the remote database... I am curious about streamlining this process and making multiple connections to all of the databases at once for each server.
Each server has its own IP address and different logon credentials... My question is it possible to use this library to establish different database connections for each server at the same time or simply, is jdbcdriver thread safe.... I have hundreds of remote databases that I have to keep updated on a monthly basis and would like to use java threads to do each server.
I have done this job using PERL and simply remotely executing the right script after I upload the data that I need, but if jdbcdriver is thread safe then their is no need for the remote execute of scripts, I can simply update the tables that I need on the fly.
Thanks guys, Dan Rychlik
Yes it is. Watch the JDBC spec though. It doesn't give you much scope
at all for multiple threads simultaneously using a given connection or
any of it's subobjects. If you write your code to ensure that only one
thread uses any connection at one time, you should be just fine with an
application creating and using lots of connections to lots of DBMSes.
Joe Weinstein at BEA Systems
.
- Prev by Date: Re: Integrated Authentication
- Next by Date: Re: Cannot open user default database.
- Previous by thread: Cannot open user default database.
- Next by thread: Driver corrupts prepared statements in pool.
- Index(es):
Relevant Pages
|
