From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM autolearn=ham autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,7179b046d1b6799f X-Google-Attributes: gid103376,public X-Google-ArrivalTime: 2003-12-20 10:35:56 PST Path: archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.mathworks.com!wn14feed!worldnet.att.net!216.166.71.14!border3.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Sat, 20 Dec 2003 12:35:54 -0600 Date: Sat, 20 Dec 2003 13:35:53 -0500 From: "Robert I. Eachus" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.lang.ada Subject: Re: GNADE insert problem References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: NNTP-Posting-Host: 24.34.214.193 X-Trace: sv3-RO1rRgStm4zbXz+v6J6vEQAlB1SHLRBOwP65t0bs1YOBmB7QUl5vyky1aPmfphpfC+BDPYaiZ8cTyvd!RIgza5ANNJhhscaCiEiD5NT2YzfH7cdwYpFXN22sdXwO/x/0NSSLWNrtxTxJjg== X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: archiver1.google.com comp.lang.ada:3635 Date: 2003-12-20T13:35:53-05:00 List-Id: Jano wrote: > I've workaround it disconnecting from the DB after each insert. Since I > insert a record per minute and the db is local, it can hold that way > until I get into the package you have suggested. As an aside, this problem is why I quickly get headaches mixing Ada and SQL. SQL has this concept of an implicit cursor, and you have to be very careful that every Ada thread containing SQL maintains its own cursor correctly. How you do that depends on the database, the interface language (i.e. whether it is compiled or embedded SQL) and what you are doing. But when you have to think in SQL while working in Ada, it is very painful. Having an explicit cusor parameter for each SQL call is neither Ada or pure SQL. But when possible, it eliminates a lot of headaches. -- Robert I. Eachus "The war on terror is a different kind of war, waged capture by capture, cell by cell, and victory by victory. Our security is assured by our perseverance and by our sure belief in the success of liberty." -- George W. Bush