public static List<comision> ConsultaComision() throws SQLException
	{
		conexion con = null;
		PreparedStatement statement = null;
		ResultSet rs = null;
		Connection connection = null;

		try 
		{

			con = new conexion();
			connection =  con.getConexion();
			statement = connection.prepareStatement("select * from info.ks_commission");
			rs = statement.executeQuery();


			List<comision> ListadoComision = new ArrayList<comision>();


			while (rs.next()){

				comision Comision = new comision(); 

				Comision.setCnt_cuenta_id(rs.getString("cnt_cuenta_id"));
				Comision.setCommission_id(rs.getString("commission_id"));
				Comision.setInfo_from(rs.getString("info_from"));
				Comision.setNetsuite_import(rs.getString("netsuite_import"));
				Comision.setGpc_grupo_comision_id(rs.getString("gpc_grupo_comision_id"));
				Comision.setGpc_descripcion(rs.getString("gpc_descripcion"));
				Comision.setGpc_tipo(rs.getString("gpc_tipo"));
				Comision.setGpc_estado(rs.getString("gpc_estado"));
				Comision.setCms_comision_id(rs.getString("cms_comision_id"));
				Comision.setCms_comision_maxima(rs.getString("cms_comision_maxima"));
				Comision.setCms_comision_minima(rs.getString("cms_comision_minima"));
				Comision.setCms_comision_plana(rs.getString("cms_comision_plana"));
				Comision.setCms_comision_porcentual(rs.getString("cms_comision_porcentual"));
				Comision.setCms_descripcion(rs.getString("cms_descripcion"));
				Comision.setCms_estado(rs.getString("cms_estado"));
				Comision.setCms_fecha_creacion(rs.getString("cms_fecha_creacion"));
				Comision.setCms_medio_pago(rs.getString("cms_medio_pago"));
				Comision.setCms_moneda_iso_4217(rs.getString("cms_moneda_iso_4217"));
				Comision.setCms_pais_iso_3166(rs.getString("cms_pais_iso_3166"));
				Comision.setCms_tipo_operacion(rs.getString("cms_tipo_operacion"));
				Comision.setCnt_usuario_id(rs.getString("cnt_usuario_id"));


				ListadoComision.add(Comision);

			}

			con.cerrarConexion();

			return ListadoComision ; 
		}

		catch ( Exception e ){

			System.out.println(e.getMessage());
			return null;
		}

		finally {
			if (rs != null) try { rs.close(); } catch (SQLException ignore) {}
			if (statement != null) try { statement.close(); } catch (SQLException ignore) {}
			if (connection != null)
				connection.close();
		}

		//	return Consulta("select DISTINCT ON (usr_documento) usr_documento , * from info_transaction_users limit 3;");

	}