All pastes #87090 Raw Edit

Stuff

public text v1 · immutable
·published 2006-07-13 16:43 UTC
rendered paste body
    ResultSet fetchData2D() throws SQLException {

	Connection dbServer;

	dbServer = getConnection();

	// getting the data from the table

	Statement statement = dbServer.createStatement(ResultSet.TYPE_FORWARD_ONLY,
						       ResultSet.CONCUR_READ_ONLY);
	statement.setFetchSize(40000);

	String query = "SELECT "+getXColumnName()+","+getYColumnName()+" FROM "+getTableName()+
	    getQueryRestrictions();

	log(query);


	System.out.println("Executing query2...");
	ResultSet rset = statement.executeQuery(query);
	System.out.println("Query executed...");

	return rset;
    }