Re: Web application using jdbc driver an OEM application?

Kim,

jTDS is thread safe at the Connection level. Different Connection
instances have no relationship to one another whatsoever so that's
going to be safe anyway.

Also, a Connection instance is thread safe as long as Statements are
not shared between threads, i.e. you can share a Connection between 10
threads, each using a separate Statement created from that Connection.
I wouldn't recommend this, however, because requests and responses have
to be serialized over a single TCP/IP connection and this will affect
performance.

So basically yes, it's completely safe to use jTDS within a web
application. At least as safe as with any other driver.

Alin,
The jTDS Project.

.

Relevant Pages

  • Re: Connection pooling help
    ... The method below is safe for multi-threading with respect to connection ... so each invocation will get it's own ... It would not have been safe if the connection variable was a global shared ... object is not thread safe in a shared function (even though it was ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Passing DB connection object between 2 Process
    ... I think you would need a custom marsheller and ... ODBC itself is thread safe. ... However due to other issues such as Firehose Cursors ... and take advantage of Connection Pooling. ...
    (microsoft.public.vc.mfc)
  • Re: Anybody understand this?
    ... to accept connection requests from other computers. ... Your computer is safe. ... > CFD.exe is part of the client software for your broadband network ...
    (sci.med.transcription)
  • Re: Closing Connection
    ... Make sure the connection pooling is ... If you see a big ugly assertion box ... that I make an assumption about just to be safe. ... > something with the database file, it says the database file is still in ...
    (microsoft.public.dotnet.framework.adonet)
  • Optimizing performance
    ... We are currently evaluating MS JDBC against jTDS and i-net Una regarding performance. ... Connection conn; ... Statement stmt; ...
    (microsoft.public.sqlserver.jdbcdriver)