?
Solved

_STUPID_ Oracle problem

Posted on 2002-04-21
9
Medium Priority
?
309 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 400 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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month11 days, 8 hours left to enroll

752 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