Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Ive requested an updatable ResultSet and my driver supports them, but I still don get an updatable ResultSet. Why?

April 26, 2017driver requested ResultSet supports Updatable

0

Posted

Ive requested an updatable ResultSet and my driver supports them, but I still don get an updatable ResultSet. Why?

1 Answer

0

Posted

Location: http://www.jguru.com/faq/view.jsp?EID=411928 Created: Apr 28, 2001 Author: Joe Sam Shirah (http://www.jguru.com/guru/viewbio.jsp?EID=42100) Aside from driver bugs, some queries cannot be updatable due to identification, integrity or DB limitation issues. For that reason, ResultSet.getConcurrency() generally should be invoked to determine if an updatable ResultSet was returned. For more information and a list of guidelines that should return an updatable ResultSet, see 5.1.17 Queries That Produce Updatable Result Sets.