JsonNode rootNode = mapper.createObjectNode(); // will be of type ObjectNode
ArrayNode jSONrecords = ((ObjectNode)rootNode).putArray("ProgramRecord");
try {
Connection conn = null;
DriverManager.registerDriver(new AppEngineDriver());
conn = DriverManager.getConnection("jdbc:google:rdbms://pcni.org:openhmis:openciss/compass");
String stmt = "SELECT program_key, program_name, agency_name, program_type, site_geocode, target_pop_a_name, update_time_stamp, units_total, units_available, units_occupied, contact_name, contact_phone, program_address, program_city, program_zip, program_address_full FROM compass.program_profile_info WHERE program_key=?";
PreparedStatement pstmt = (PreparedStatement)conn.prepareStatement(stmt);
// try {
// System.out.println("value=[" + idStr + "]; bytes=" + Arrays.toString(idStr.getBytes("UTF-8")));