Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

_STUPID_ Oracle problem

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
Stuart_Johnson
Asked:
Stuart_Johnson
  • 6
  • 3
1 Solution
 
kretzschmarCommented:
set the autocommit-feature-property at the bde-alias to true or do an explecit commit after each post

meikl ;-)
0
 
kretzschmarCommented:
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
 
Stuart_JohnsonAuthor Commented:
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!

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

meikl ;-)
0
 
Stuart_JohnsonAuthor Commented:
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
 
kretzschmarCommented:
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
 
Stuart_JohnsonAuthor Commented:
Meikl, as always, you've just out shone yourself again.  Truely brilliant!

Thank you SO much!

Stu
0
 
kretzschmarCommented:
well,
glad to helped you,
and also glad you got it work

meikl ;-)
0
 
kretzschmarCommented:
was a pleasure for me ;-)
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now