Re: commit problem

Thank you again Prassad, and Dilip.

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

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

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]