Re: What's wrong in this transaction?


"Furious George" <bugme_69@xxxxxxxxxxx> wrote in message
news:1163118105.210327.164230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Rhino wrote:
"Furious George" <bugme_69@xxxxxxxxxxx> wrote in message
news:1163034598.253815.66160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Rhino wrote:
"gbattine" <gbattine@xxxxxxxx> wrote in message
news:1163006489.058818.35250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Oliver Wong ha scritto:

Have you read this?
http://dev.mysql.com/doc/refman/5.0/en/commit.html

yes i've read it but it seems like my code...now i've added

int x=conn.TRANSACTION_NONE;

System.out.println("Support for transactions "+x);

and it gives me 0!!!!!!!
What does mean?
Transactions are not supported?
Please help me...


All you have done is print the value of a Field (constant) named
Connection.TRANSACTION_NONE and found out that its value is 0. Don't
you
understand the difference between a Field and a Method? If not, you
desperately need a basic Java course before you start writing database
code - or any other code, for that matter!

If you are trying to figure out if your database supports
transactions,
get
a DatabaseMetaData object and then use the supportsTransactions()
method.
If
the result is a boolean true, your database supports transactions.

OK, you have mastered the basic Java course, but you obviously have no
real working experience in the field.

Obviously?? I've been using relational databases - and teaching them
professionally - for over 20 years. Now don't you feel foolish?

Actually, no. I was just nitpicking one statement. Don't take it
personally.

Gee, how could I possibly be offended at you dismissing me as a rank newbie
when I have been working with databases for 20+ years?


Otherwise you would know that if
the supportsTransactions() method returns true, your database claims
transaction support. You would know the difference between claiming
transaction support and supporting transactions.

Actually I _do_ know the difference between claiming support and actually
providing it. I just haven't come across that many instances where
vendors
claimed support that wasn't there. I made the assumption that MySQL was
being truthful in its claims. If you know that MySQL is lying (or
exaggerating) about supporting transactions, I will stand corrected. But
just the fact that some vendors occasionally fudge the truth about some
features of their systems does NOT prove that supportsTransactions() is
false in _this_ case.

I believe MySQL is trustworthy in this respect.

Sorry, for any offense given.

Okay.

--
Rhino


.

Relevant Pages

  • Re: Whats wrong in this transaction?
    ... If you are trying to figure out if your database supports transactions, ... a DatabaseMetaData object and then use the supportsTransactions() method. ... the result is a boolean true, ...
    (comp.lang.java.programmer)
  • Re: Whats wrong in this transaction?
    ... If you are trying to figure out if your database supports transactions, ... a DatabaseMetaData object and then use the supportsTransactions() method. ... I made the assumption that MySQL was ...
    (comp.lang.java.programmer)
  • Re: Whats wrong in this transaction?
    ... Rhino wrote: ... If you are trying to figure out if your database supports transactions, ... a DatabaseMetaData object and then use the supportsTransactions() method. ...
    (comp.lang.java.programmer)
  • Re: Whats wrong in this transaction?
    ... int x=conn.TRANSACTION_NONE; ... If you are trying to figure out if your database supports transactions, ... a DatabaseMetaData object and then use the supportsTransactions() method. ...
    (comp.lang.java.programmer)
  • Re: Do Transactions guard against corruption?
    ... when the database is opened and closed. ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
    (microsoft.public.access.modulesdaovba)