What sort of locks does a Streaming ResultSet produce?
Posted by: Daniel Schneller
Date: April 29, 2005 06:20PM

Hello!

I ran some simple tests with streaming resultsets to find out, what kinds of locks I would get (according to the manual all tables used in a streaming resultset will be locked).

I wrote a simple test case that opens a connection and executes a SELECT * FROM table statement with the streaming mode flags set.
While that statement was running (I put a delay in the loop getting all the rows) I tried to select and insert from and into that same table without any problems, both from a command line and another Java client.

I am using InnoDb tables. Could someone enlighten me, what kinds of locks are to be expected and in what situations?

Thanks,
Daniel

Options: ReplyQuote


Subject
Written By
Posted
What sort of locks does a Streaming ResultSet produce?
April 29, 2005 06:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.