one time hit database connection.

From: bigbinc (bigbinc_at_hotmail.com)
Date: 12/28/03

  • Next message: dedmike: "HSQLDB: Availability of hsqldb v.1.7.2RC1" 
    Date: 28 Dec 2003 10:04:43 -0800

    I dont know what the type of connection is called, but I know it is
    the worst kind. Through a servlet, lets say I open a oracle 9.2
    connection, run the query and then close the connection, will this
    hurt the oracle server in terms of performance. I know this is the
    least efficient way to run oracle queries but everybody does it. I
    read somewhere that you can open the database connection at the start
    of a session and then close the connection at the end of the session.

    So the question, how much am I hurting the oracle server by the
    one-time-hit-connection, if I have 10-20 users on the servlet hours at
    a time. I have been doing it in asp for years.

    pseduo-code:

    goConnection() {

    conn
     try {
      openconnection()
      runquery();
      getdata();
      conn.close();
     } catch() {

      conn.close();
     } finally() {
      conn.close();
     }

    }

  • Next message: dedmike: "HSQLDB: Availability of hsqldb v.1.7.2RC1"

    Relevant Pages

    • Re: IIS connects to Oracle : only ONE session active at any time
      ... like Oracle or IIS is queuing requests rather than multi-threading them. ... The application programmers think the> ADO connection is defined on application scope. ... >>> We have an IIS-server using ASP and connecting to an Oracle 7.3.4>>> database. ... >>> What happens is that a certain session is active for a while. ...
      (microsoft.public.inetserver.iis)
    • Re: How to simulate ORA-03114 "Not connected to Oracle" in a test application?
      ... An Oracle client application of ours that connects to Oracle via OCI, sometimes faces loss of connection, for example when a lap to goes into hibernation or the network is unstable. ... We do this in form of unit tests, so the unit test application will simply run for a short or long span of time without user interaction and protocol what happened, for example how many of the tests succeeded and how many failed. ... One way is to use OEM and manually KILL the session at the appropriate point of time and see what the application will do. ...
      (comp.databases.oracle.tools)
    • RE: ADO.Net Connection Pooling Problem with Oracle
      ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
      (microsoft.public.dotnet.framework.adonet)
    • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
      ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
      (microsoft.public.dotnet.framework.aspnet)
    • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
      ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
      (microsoft.public.dotnet.framework.adonet)