Re: commit problem

Thank you again Prassad, and Dilip.

Re: commit problem

Thank you Prassad, and Dilip for your reply. Prasad, i wiil be pleased if u answer to my query, how i can convert my tables to Innodb? Thank You, regards, bala

commit problem

Hi, I have a problem with 'commit'. My database contain non transaction tables. When ever i do something wrong on DB, i am unable to rollback. I am setting set sutocommit off, but the result is same, no rollback is happening. Please help me! regards, bala

Mysql Commit Problem

HI I am using java. i am fireing the following query ,after and insert or update in Mysql through Java int returnValue = backend.setQueryResult("commit"); where setQueryResult(String sql) is method that updates data in database. i have set the connection.setAutoCommit(false). The "returValue

set auto commit problem

Hi, I'm tring to make connection.setAutoCommit(false) with "org.gjt.mm.mysql.Driver" driver, I recieve an exception that says : "cannot disable AUTOCOMMIT " . Is it the driver, should I use different driver, and suggestion ? Thanks a lot einav. Einav Lavi-Pdut software engineer [EMAIL PROTECTED]