MyBatis Oracle Java.sql.SQLException: Stream has been turned off issue

Source: Internet
Author: User

/** * Value by page number (starting from Current_page page, page_size per page) * @param key * @param params * @param current_page * @param page_size * @retur n */public <T> pagination getpaginationbypage (String key, Object params,int current_page,int page_size) {int count< c0/>= (  Integer) getsqlsession (). SelectOne (key+ "_count", params); list<object> list     =  getsqlsession (). SelectList (Key, Params,new rowbounds ((current_page-1) * page_size , page_size)); pagination pagination =  new pagination ();p agination.paging (Current_page, Page_size, Count);p agination.setlist ( list); return pagination;  }

Java.sql.SQLException frequently occurs when paging queries are executed: The stream has been closed.

The table field in the Oracle Library in an isolated project uses a long type instead of number, changing the number to the normal amount.

The ResultSet interface provides a GET method for getting column values from the current row (Getboolean, Getlong, and so on). You can use the index number of a column or the name of a column to get a value.

In general, the use of column indexes is more efficient. The column is numbered starting at 1. For maximum portability, the result set columns in each row should be read in left-to-right order, and each column can be read only once.

MyBatis Oracle Java.sql.SQLException: Stream has been turned off issue

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.