How can i delete records of Oracle table!_NEWLINE_!with help jdbc
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   prince_sethi
Posted On:   Thursday, February 28, 2002 06:47 AM

Hello


to all friends


I want to delete all records of Oracle's
table . For this i try


st.executeUpdate("Delete from mytable");


but this statement hang my java application . If anyone know then please help me.

Re: How can i delete records of Oracle table!_NEWLINE_!with help jdbc

Posted By:   Lakshmanan_Sakthivel  
Posted On:   Thursday, February 28, 2002 01:57 PM

May be it is due to Database LOCK. Normally oracle LOCKS the table when you do update or delete. The LOCK will be released only after the commit. So don't forget to use commit after updating the table, otherwise you can set the autocommit property to true before you do any update on the table.
About | Sitemap | Contact