Hi,
We have a good solution here using Delphi 1 (soon to be 5) and oracle 8. It
uses native oracle drivers and the BDE to connect to oracle. Currently all
queries are performed using the TQuery object within Delphi and all
transactions are performed within Oracle stored procedures. We use an
application call T.O.A.D. This enables debugging of the PL/SQL stored procs
(other tools like this that are cheaper exist too I think).
The main disadvantage of this method is that it is still basically a 2 tier
architecture and there is at least one connection per client. Oracle
databases tend to take a while to connect to so having a middle tier that
pools connections is a far more efficient method. I am also thinking of the
possibility of using the loadFromFile method of TQuery and store all the
queries as text files (to get them out of the client).
Also I recommend not to drop TQueries and TStoredProc objects onto the forms
but instead create them dynamically in the source. It's easier to support
afterwards.
This application is now over 5 years old and it is going to be around for a
few more years yet. I am in the process of upgrading the application to
Delphi 5 and add threads to enable the users to terminate queries if they
take to long (currently they have to kill the app).
Cheers Ant
________________________________________________________
Antony Gardiner (IT Specialist)
Clear Communications Ltd
One of the Intranet, NRS, CPS, & NMS wannabes
*+64 9 912 4746) Zone 1534
-----Original Message-----
From: Jeremy Coulter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 2 March 2000 08:56
To: Multiple recipients of list delphi
Subject: [DUG]: Oracle and Delphi
HI all.
We are looking at POSSIBLY providing a solution for an Oracle database.
Currently we use Interbase for all our solutions.
Has anyone used Oracle via Delphi before...or currently....and if so, did
you use some of the 3rd party Oracle tools availble, or how did you connect
to it?
Cheers, Jeremy Coulter
Software Manager
Triton Commercial Systems Ltd
6a Burdale Street
Riccarton
Christchurch
pH 348 3973 fax 343 1613
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
