Databases
StackOverflow2013
Postsdbo
POLimitations of MySQL JDBC
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLimitations of MySQL JDBC
    primarykey
    data
    text
    <p>Problem:</p> <p>I get large ResultSet from DB(MySQL)(more than 1 000 000 rows) and handle each row about 40 seconds. Summary, i work with ResultSet more than 30 minutes, i get less records than really contain in database table аnd have no errors and no warrnings. If i count quantity of rows of that ResultSet, it's allright(quantity of ResultSet = quantity of DB).</p> <p>Is some limitations of mysql server or mysql jdbc driver or something else?</p> <p>My code. it works in spring framework :</p> <pre><code> public void query(String query, RowCallbackHandler rowCallbackHandler) throws SQLException { ResultSet rs = null; ResultSet rsCount = null; Statement stmt = null; Statement stmtCount = null; try { stmt = createStatmant(); rs = stmt.executeQuery(query); if (rs == null) { log.info("result set is null"); } stmtCount = createStatmant(); rsCount = stmtCount.executeQuery(query); int i = 0; while(rsCount.next()){ i++; } log.info("ResultSet size : "+i); int j = 0; rs.next(); do{ j++; rowCallbackHandler.processRow(rs); }while (rs.next()); log.info("ResultSet size real : "+i); log.info("ResultSet size fact : "+j); } catch (SQLException e) { throw new RuntimeException(e.getMessage()); }finally{ if(stmt!=null){ stmt.close(); } if(rs!=null){ rs.close(); } if(rsCount!=null){ rsCount.close(); } } } </code></pre> <p>createStatment :</p> <pre><code> private Statement createStatmant() throws SQLException { ((BasicDataSource)dataSource).setTimeBetweenEvictionRunsMillis(1000*60*60); Statement stmt = dataSource.getConnection().createStatement( ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); stmt.setFetchSize(fetchSize); stmt.setMaxRows(50000000-1); return stmt; } </code></pre> <p>datasource is global variable in class:</p> <pre><code> private javax.sql.DataSource dataSource; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJon Cram
    1. USSan4o
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLimitations of MySQL JDBC
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COPaste your code please so its easy to identify the issue.
      singulars
      1. POLimitations of MySQL JDBC
      1. USSudhanshu Umalkar
    2. COIt looks like a problem in your code.
      singulars
      1. POLimitations of MySQL JDBC
      1. USLuiggi Mendoza
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload