Solved

_STUPID_ Oracle problem

Posted on 2002-04-21
9
299 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi Firemonkey Need Sample for Online Shopping Example. 2 193
Convert a string into a TDateTime 5 72
enhance the following code 3 42
Broadcast a message using ICS 2 28
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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