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

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

1 posts in topic

Flat View

Thread View

Older Post First | Reply to Topic

TOPIC ACTIONS:

Print Topic

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.

Report | Quote This | Send private message | Reply | Print

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.

Report | Quote This | Send private message | Reply | Print