aspose file tools*
The moose likes JDBC and the fly likes test JDBC transaction Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "test JDBC transaction" Watch "test JDBC transaction" New topic
Author

test JDBC transaction

Edward Chen
Ranch Hand

Joined: Dec 23, 2003
Posts: 798
I am testing the JDBC transaction. The below is coding. I force it to throw exception and roll back the result. But it doesn't work as we expected. The database is MySQL 4.

I don't know why.

Jyothi Lature
Ranch Hand

Joined: Oct 31, 2001
Posts: 60
Hi,

What is the problem you are facing in this code....?


Jyothi<br />Sun Certified Java Programmer<br />Brainbench Certified for Javascript
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
may be this is because of MySQL. i found MySQL and Access wiered sometimes. It doesn't support the transaction management. I have a good experience with Oracle, but not with MySQL. hope someones knows the actual cause.

but again i think MySQL sucks. I have heard something bad like the same about MySQL from ranchers.
Gil Li
Greenhorn

Joined: May 27, 2004
Posts: 15
Hi

I cant see any problem in this code.The thing is type of mySQL storage Engine. The default storage engine is myISAM.This does not support transcation management. You have to change the type of storage engine into InnoDB or BDB. Refer mySQL manual to change the storage engine type. That will work fine..


Regards,<br /> <br />GILLI
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: test JDBC transaction