PL/SQL Cartridge Stateless ?

From: <larry_xu_at_ibm.net>
Date: Sat, 5 Jun 1999 17:06:06 -0400
Message-ID: <375994cf_at_news1.us.ibm.net>

Hi

I'm looking for a forum for Oracle Application Server. Can anybody with hands-on experience on PL/SQL Cartridge to clarify some of the concept regarding the PL/SQL cartridge.

1. Is PL/SQL cartridge stateless by definition? Even you try to set min instance > 0 and you won't actually have a session.
2. If point 1 is correct then, Is following description of PL/SQL cartridge TRUE?

Once WRB dispatched the request to PL/SQL Cartridge, Cartridge located the DAD and did :

1. Connect the database
2. Exec the procedure and generate the HTML
3. DISCONNECT FROM DATABASE IMMEDIATELY

That simply means every request need at least a pair of Connection/disconnection. Will this overload the server ?

Two OAS books and Oracle document did not explain this clearly. some web sit even explain it in just opposite
http://www.customdb.com/ora_cartridge_facts.html ) "PL/SQL cartridge provides declarative transactions, persistent connections where packages can hold a state, cursors remain open"

Any comment ?

Larry Received on Sat Jun 05 1999 - 23:06:06 CEST