Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2006
    Posts
    5

    Unanswered: Error Code 1062 and 1053

    hello,

    you may know about MySQL Error Codes 1062 (ER_DUP_ENTRY) and 1053 (ER_SERVER_SHUTDOWN).

    i want to find out the corresponding error codes in Oracle and MS SQL. what are they?

    thanks for your quick response.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I use Oracle, but I have no idea what "ER_DUP_ENTRY" or "ER_SERVER_SHUTDOWN" might be. Also, if you were too lazy to describe those errors, I must admit that I'm too lazy to search through MySQL error database in order to give you possible corresponding error codes in Oracle.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i agree

    and this was the wrong forum, too

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    well what you could do is write some SQL that cuases these faults, then run that SQL on an Oracle DB and trap for the Oracel error Messages. Mind you you could make this into an evolving open source project.... use the same crappy code and run it against say DB2, SQL Server or any other SQL db and report back the error messages.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sql that causes a server shutdown????

    got any samples, healdem?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by r937
    sql that causes a server shutdown????

    got any samples, healdem?


    oooh I dunno... how about deleting all the system objects.. that might do the trick, removing all rights to all objects except for a specific userID, killing a superuser / system userid.


    Hey its not my speciality... I like my servers & applcations to be available at all times, but each to their own.....
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    It is quite easy to cause something like this on Oracle - login as SYS and issue

    DROP TABLE dual;

    That'll do.

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by r937
    sql that causes a server shutdown????

    got any samples, healdem?

    SQL Server makes this easy. Just use SHUTDOWN.

    -PatP

Posting Permissions

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