Miscellany

Code:

    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 = null;
	try {
	    rset = statement.executeQuery(query);
	}
	catch (Exception e) {

	    System.out.println("exception occured..");
	    e.printStackTrace();
	    throw new SQLException(e.toString());
	}
	System.out.println("Query executed...");

	return rset;
    }

Log output:

Jul 13, 2006 12:02:54 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 3030 ms
in bursh updateStyle(). getColor():green
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():green
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
Executing query2...