Solved

_STUPID_ Oracle problem

Posted on 2002-04-21
9
306 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
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!

 
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

Independent Software Vendors: 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

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

707 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