Solved

_STUPID_ Oracle problem

Posted on 2002-04-21
9
290 Views
Last Modified: 2010-04-04
We've just encountered a really stupid error which is only happening on Oracle, and for only one of our Oracle customers.  Our customer is using Oracle 8.1.6.  The application is written in Delphi 5 Enterprise.  Connection to Oracle is via the BDE.

Scenario:
Person 1 logs into our system.  Person 2 logs into our system.  Person one begins a job.  Person 2 begins a job.  Person 1 saves the job, Person 2 locks up and will stay that way until Person 1 quits the application.

I really hope some one can help me out with this.  It's driving everyone here nuts :)

Stu
0
Comment
Question by:Stuart_Johnson
  • 6
  • 3
9 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6958838
set the autocommit-feature-property at the bde-alias to true or do an explecit commit after each post

meikl ;-)
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6958882
appendix,

the bde-oracle-native-driver, which comes with d5 enterprise has a bug associated with the autocommit-feature

get the bugfix at www.borland.com/devsupport/bde (a dll replacement) or
get there the latest bde-update

meikl ;-)
0
 
LVL 6

Author Comment

by:Stuart_Johnson
ID: 6958935
Hi meikl,

Thanks very much for the info!  I'll download the DLL now and give it a go.

The autocommit feature you meantioned...I don't seem to have a property with that name.  However, the SQLPASSTHRUMODE property has SHARED AUTOCOMMIT as an option.  Is that what you were refering too?

Stu
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 27

Expert Comment

by:kretzschmar
ID: 6958959
>SHARED AUTOCOMMIT
yep, this should it be, set it to true,
if you don't like to control the transactions byself

meikl ;-)
0
 
LVL 6

Author Comment

by:Stuart_Johnson
ID: 6958990
Meikl,

The options for SQLPASSTHRUMODE are:
   NOT SHARED
   SHARED AUTOCOMMIT
   SHARED NOAUTOCOMMIT

I'm guessing that you want me to set SQLPASSTHRUMODE to SHARED AUTOCOMMIT?

Also, just checked that link you sent.  Do we need to download the whole BDE to get this fixed?  We're currently running BDE 5.01 and that's the version we've "certified OK" for our product.  Using to BDE 5.2 would mean our testing department would be run off their feet testing the entire product again.

Do you know the name of the single DLL we need?  Perhaps I can download the new BDE and extract just the required DLL (or won't this work)?

Thanks again mate.

Stu
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 100 total points
ID: 6959010
look at
http://www.borland.com/devsupport/bde/oldver.html

Updated Oracle 8 SQL Links Driver (197,269 bytes) This update applies to BDE 5.1 only. It was created specifically to address the following problems:

Explicit transaction rollback will rollback all the inserts/updates/deletes done prior to the start of the transaction.
If SQLPASSTHRU MODE is SHARED AUTOCOMMIT posts are not commited until the database is closed.
Installation instructions are included in the ZIP file.

http://www.borland.com/devsupport/bde/oldver.html

meikl ;-)
0
 
LVL 6

Author Comment

by:Stuart_Johnson
ID: 6959056
Meikl, as always, you've just out shone yourself again.  Truely brilliant!

Thank you SO much!

Stu
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6959070
well,
glad to helped you,
and also glad you got it work

meikl ;-)
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6959495
was a pleasure for me ;-)
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Newbie Thread Programming 1 151
Controlled Assessment GCSE - desperate help needed 4 84
SUM 2 INTEGER ARRAYS INTO 1 10 100
Slow Restore if incremental backups using RDiff.exe 4 19
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question