Prepared Statement trouble

I apologize in advance if I did not post this in the correct forum. I'm having trouble getting my prepared statement to execute properly. I have tried creating the SELECT query many different ways this is just one of them. When this method is called it prints out string from System.out.println("BEfore DB call. " + pg + " " + perPg); in my console then drops out with no data returned. In fact it appears my code cannot reach System.out.println("After DB call. "); output. I cannot get the query to execute properly.

Any help would be greatly appreciated.

public static synchronized ArrayList pcResourceQuery(Connection connection, String pgNum, String linksPerPg)
	throws SQLException{
		
		int pg = Integer.parseInt(pgNum);
		int perPg = Integer.parseInt(linksPerPg);
		int pgMultiplier = pg;// * perPg;
		Integer zero = 0;
		ArrayList queriedData = new ArrayList();
		System.out.println("BEfore DB call. " + pg + " " + perPg);
		String query = "SELECT * FROM resource_db WHERE is_registered = 0 LIMIT ?, ?";
		
		//String exec = "EXECUTE stmt_name USING '" + set1 + "'," + set2;
		PreparedStatement pstatement = null;
		pstatement = connection.prepareStatement(query);
		pstatement.setInt(1, pg);
		pstatement.setInt(2, perPg);
		//Statement statement = connection.createStatement();
		ResultSet results = pstatement.executeQuery(query);
		
		PCResourceBean storePCResources = new PCResourceBean();
		
		String id;
		String title;
		String submitBy;
		String description;
		String submitDate;
		System.out.println("After DB call. ");
		while(results.next()){
			id = results.getString("resource_id");
			title = results.getString("resource_title");
			submitBy = results.getString("resource_props");
			description = results.getString("resource_description");
			submitDate = results.getString("date_added");
			storePCResources = new PCResourceBean(id, title, submitBy, description);
			queriedData.add(storePCResources);
		}
		
		results.close();
		pstatement.close();
		
		return queriedData;
	}

Your code is throwing a SQLException. What is it.?

Hmm. I see no SQLException in my eclispe console it only returns test data System.out.. . The method call returns to a servlet. When I test in my browser it drops back to servlet (http://localhost/servlet/coreservlets.WebAppsServlet?pages=1&linksPerPage=5) and displays blank screen. It should return the data to servlet and depening on what it contains redirect to one of two JSP pages.

Your method throws SQLException so somewhere in your stack, it's eating it. I suggest you catch SQLException and log the error. Or you can check your log files.

have you tried writing the query in an SQL client first?

You can bind variables into a query. The parameters you pass to the LIMIT clause aren't variables. They cannot be bound.