{{theTime}}

Search This Blog

Total Pageviews

How to create Scrollable ResultSet?

How to create Scrollable ResultSet?

Use ResultSetType Constant in createStatement(), prepareStatement() or prepareCall()
TYPE_FORWARD_ONLY -- Forward only scrollable, update-insensitive
TYPE_SCROLL_INSENSITIVE -- Bi-directionally scrollable, update-insensitive
TYPE_SCROLL_SENSITIVE -- Bi-directionally scrollable, update-sensitive.

No comments:

Mysql - java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed

Add allowPublicKeyRetrieval=true to the JDBC URL. jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false