Select * from <имя схемы>.<имя вида1>

Select * from <имя схемы>.<имя вида2>

 public   class  DbConnector  implements  AppConnParams {
// в AppConnParams определны имя сервера, имя и пароль пользователя

	 public   static  Connection getConnection()  throws  SQLException {
		String url  = CONNECTION_URL;
		String user = CONNECTION_USER;
		String pass = CONNECTION_PASS;	
		 return  java.sql.DriverManager.getConnection(url, user, pass);	
	}
	
}

 protected   void  processRetrievingQuery(String id_field,  long  id)  throws  SQLException {
		Connection conn = DbConnector.getConnection();
		String src = schemaName + "." + tableName;
		 int  typeFiltrationParamNum =  0 ; 
		 int  systemFiltrationParamNum =  0 ;
		//Для подсистемы и блока
		 int  subsystemFiltrationParamNum =  0 ;
		 int  blockFiltrationParamNum =  0 ;
		
		StringBuilder query =  new  StringBuilder();
		query.append("SELECT * FROM " + src + " WHERE " + id_field + "=? ");

// тут разная фильтрация по параметрам 
		 int  curFiltrationParamNum =  1 ;
		 if  (typeFiltration) {
			typeFiltrationParamNum = ++curFiltrationParamNum;
			query.append("AND type_id=? ");
		}
		 if  (systemFiltration) {
			systemFiltrationParamNum = ++curFiltrationParamNum;
			query.append("AND system_id=? ");
		}
		//Для подсистемы и блока
		 if  (subsystemFiltration)
		{
			subsystemFiltrationParamNum = ++curFiltrationParamNum;
			query.append("AND subsystem_id=? ");
		}
		 if  (blockFiltration)
		{
			blockFiltrationParamNum = ++curFiltrationParamNum;
			query.append("AND block_id=? ");
		}
		
		PreparedStatement ps = conn.prepareStatement(query.toString());
		ps.setLong( 1 , id);
		 if  (typeFiltration) {
			ps.setLong(typeFiltrationParamNum, typeId);
		}
		 if  (systemFiltration) {
			ps.setLong(systemFiltrationParamNum, systemId);
		}
		//Для подсистемы и блока
		 if  (subsystemFiltration)
		{
			ps.setLong(subsystemFiltrationParamNum, subsystemId);
		}
		 if  (blockFiltration)
		{
			ps.setLong(blockFiltrationParamNum, blockId);
		}
// queryString - отладочная переменная, выдает строку запроса
		queryString = ps.toString();
		ResultSet rs = ps.executeQuery();
		setEquipmentList(rs);		
		conn.close();
}

 public   void  processHttpParams(Retriever retriever,  boolean  useHttpFiltrationParams)  throws  IOException, SQLException {
		// Extracting http-parameter values
		filtrationType = request.getParameter("filter");
		 if  (request.getParameter(SYSTEM) !=  null )
			filtrationSystem = request.getParameter(SYSTEM);
		 else 
			filtrationSystem = String.valueOf(request.getSession().getAttribute(SYSTEM));
		filtrationId = request.getParameter("id");
		//Блоки и подсистемы
		filtrationSubsystem = String.valueOf(request.getSession().getAttribute(SUBSYSTEM));
		filtrationBlock = String.valueOf(request.getSession().getAttribute(BLOCK));
		
		 boolean  aptParams = /*filtrationType != null &&*/ filtrationId !=  null ;
		aptParams = aptParams && filtrationId != "";
		
	
		eqstore.setSchemaName("\"Oborud\"");
		pumpsStore.setSchemaName("\"Oborud\"");
		//pumpsStore.setSchemaName("\"E_Nasos\"");
		//transformerStore.setSchemaName("\"TR\"");
		transformerStore.setSchemaName("\"Oborud\"");
			
		
		eqstore.setTableName("equipment");
		pumpsStore.setTableName("pumps_list");	
		transformerStore.setTableName("transformers_list");
		// разная фильтрация ... пропущено

		 try  {
			retriever.retrieveByIdParam(eqstore, id);
			retriever.retrieveByIdParam(pumpsStore, id);
			retriever.retrieveByIdParam(transformerStore, id);
		}  catch  (SQLException e) {
			ErrorProvider.ShowError(response, ErrorCodes.DB_ERROR);
		}
			
			
		PrintWriter out = response.getWriter(); 
		out.println("А теперь смотрим длину массивов ...<br>");
		out.println("В eqstore: "+ eqstore.length()+"<br>"); // 2319
		out.println("В pumpsStore: "+ pumpsStore.length()+"<br>"); //0
		out.println("В transformerStore: "+ transformerStore.length()+"<br>"); //0
						
			
		out.println("Смотрим строки запроса...<br>");
		out.println("В eqstore: "+ eqstore.getQueryString()+"<br>");
		out.println("В pumpsStore: "+ pumpsStore.getQueryString()+"<br>");
		out.println("В transformerStore: "+ transformerStore.getQueryString()+"<br>");
						
		Collections.sort(eqlist,  new  Comparator<EquipmentBean>(){
			 public   int  compare(EquipmentBean eq1, EquipmentBean eq2) {
				 return  EquipmentList.compare(eq1, eq2);
			}
		});
// формирование html-файла ... пропущено 		
	}

 public   interface  Retriever {

	 void  retrieveByIdParam(EquipmentStore store,  long  id)  throws  SQLException;
	
}