Question understanding Connection/Statement

From: Saad Malik (SimFox3_at_yahoo.com)
Date: 08/20/04

  • Next message: Laura P: "Geometery access via JDBC" 
    Date: 20 Aug 2004 01:01:27 -0700

    Hi There,
    Just had a quick question. Assume that we made a singleton class which
    would return the reference to an already existing Connection (made
    using DriverManager.. no connection pooling).

    I would assume, that calling createStatements in a server/client
    application would fail because a connection encapsulates the database
    server and client information (IP ADDRESSES). So multiple clients with
    different ip addresses would not be able to use someone's else
    connection object... is this right?

    Now, what if in a multi-threaded environment there is only one client
    and one server... There is stil only one connection object (created by
    the client). Calling createStatement should work everytime, right? Now
    what about cuncurrency issues... if two statements are created then
    they execute excuteUpdate() at the same time, will the connection
    object simultaneously execute the queries, or will it queue them up?

    Thanks..

  • Next message: Laura P: "Geometery access via JDBC"

    Relevant Pages

    • Re: Connection lost at same time every hour (sometimes)
      ... After making the two following alterations on the server the problem seems ... After analyze your ipconfig on SBS and client, ... Then, other connection is good, ...
      (microsoft.public.windows.server.sbs)
    • Re: server disconnection - very often
      ... Reason of permanent popups is VMware server aplication on clients. ... Run CEICW to configure the network of SBS: ... Two network adapters - manual router connection to broadband ... Uninstall VMware on client. ...
      (microsoft.public.windows.server.sbs)
    • Re: Lan setup 2 nic
      ... The external nic only has TCP/IP enabled. ... Ipconfig of the server is looking good, but the client is still missing the ... > connection so we have a 2 nic with router setup now. ...
      (microsoft.public.windows.server.sbs)
    • Re: Regular disconnections from remote web workplace
      ... I can connect to office server and all office clients from home at all times ... be physically working right up until the connection is lost. ... If I enter http://companyip from a client I receive the login screen for the ... Click Services tab and select Hide All Microsoft Services and Disable ...
      (microsoft.public.windows.server.sbs)
    • [PATCH 0/5] [RFC] AF_RXRPC socket family implementation [try #3]
      ... These patches together supply secure client-side RxRPC connectivity as a Linux ... kernel socket family. ... presentation side is left to the client. ... Each connection goes to a particular "service". ...
      (Linux-Kernel)