SPONSORS:






User Tag List

Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Jul 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DB_ commands: don\'t tell me they each do an automatic commit?!

    I am trying to write a database transaction -- deleting all rows from one table, then copying the rows from another table into the first. I did so, and then coded a DB_ExecuteSql( "COMMIT") statement, since I noticed that Silk didn't have a separate DB_Commit statement. (shoulda known right there that there would be problems!) Anyway, I had a extraneous close-paren in the INSERT command, which raised an exception. When I looked at the database through Toad, I saw that all the rows had been deleted from the first table!

    Is it what I fear? Does Silk commit after each issuance of a DB_ command?

    ------------------
    a software developer interested in quality software
    a software developer interested in quality software

  2. #2
    Senior Member
    Join Date
    Aug 1999
    Location
    Cambridge, UK
    Posts
    470
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_ commands: don\'t tell me they each do an automatic commit?!

    Yes it does.

    ------------------

  3. #3
    Senior Member
    Join Date
    Jun 1999
    Location
    Fremont, CA, USA
    Posts
    355
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_ commands: don\'t tell me they each do an automatic commit?!

    Silk does not commit after each SQL statement. The ODBC driver (Oracles) does the commit for you.



    ------------------
    David Genrich
    david.genrich@e2open.com
    david@linuxpuppy.net

  4. #4
    Junior Member
    Join Date
    Jul 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_ commands: don\'t tell me they each do an automatic commit?!

    hmmm. ODBC does the commit? how do i turn it off? there's nothing in the Admin Tools tabs that allows you to set it.

    ------------------
    a software developer interested in quality software
    a software developer interested in quality software

  5. #5
    Senior Member
    Join Date
    Jun 1999
    Location
    Fremont, CA, USA
    Posts
    355
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_ commands: don\'t tell me they each do an automatic commit?!

    I don't think you can turn it off (at least, not easily).

    You could always use SYS_Execute and call sqlplus to execute your statement. You then have control over the commit statement.



    ------------------
    David Genrich
    david.genrich@e2open.com
    david@linuxpuppy.net

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 07:38 AM.

Copyright BetaSoft Inc.