- Query plan is different for the same query in sql vs prepared Statement.
- Red Hat JBoss Data Virtualization (DV) 6.4
- Prepared Statement with criteria as parameters:
sql = "select * from " + "Inventory_Detail" + " WHERE SEARCH = and ITEM_ID in OFFSET 0 ROWS FETCH NEXT 500 ROWS ONLY"; PreparedStatement preparedStatement = conn.prepareStatement(sql); preparedStatement.setString(1,"FALSE"); preparedStatement.setString(2,"1005014161091"); ResultSet rs = null;
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.