Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRqTa-003Ldz-4V for pgsql-jdbc@arkaria.postgresql.org; Fri, 04 Aug 2023 08:48:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qRqTY-005WvA-Lm for pgsql-jdbc@arkaria.postgresql.org; Fri, 04 Aug 2023 08:48:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRqTY-005Wv2-Ee for pgsql-jdbc@lists.postgresql.org; Fri, 04 Aug 2023 08:48:00 +0000 Received: from rpt-cro-asav2.external.tpg.com.au ([60.241.0.38]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qRqTQ-000Vlb-6u for pgsql-jdbc@postgresql.org; Fri, 04 Aug 2023 08:47:59 +0000 IronPort-SDR: 64ccbb31_sJvpmEyHn8qYrN1O6G/7VN81S5ezemvdMyMvNkEn7y7u4wB wyWIrB9KvIZN/teu1PNYsvnhscF73nLGmXXeVHw== X-IPAS-Result: =?us-ascii?q?A2EDAACgusxk/w8FpnMNTRsBAQEBAQEBAQUBAQESAQEBA?= =?us-ascii?q?wMBAQFACYEyBgEBAQsBgyeGLogdiT4DgROXDIQEgVaBfg8BAwEBAQEBQgsEA?= =?us-ascii?q?QEDBIR/AoZJJjQJDgEBAQQBAQEBAQIFAQEBAQEBAwEBAQUBAgEBAQQFAQEBA?= =?us-ascii?q?oEZhWiCRCkBdYEIAQEBAQEBAQEBAQEBHQINeQEBAQMjZgsYAgImAgJXBgGDE?= =?us-ascii?q?YJwrF16gTKBAYNoQU6wEgaBFS0Bh2YaAQVgZoN4hDVCgg2BFTaCPTg+hCyDc?= =?us-ascii?q?4JnBIcKgmRmgkCCJgcygRcMCYsgCiGBCAhPD4FiDD0CDVULC2OBF4JIAgIRJ?= =?us-ascii?q?xMNBwVFcxsDBwOBBRAvBwQyHQcGCRgYFyUGUQctJAkTFUAEgXiBVgqBAz8VD?= =?us-ascii?q?hGCTiICBzY4G0uCagkVDDVQeBAuBBQYgRQESyYfGh49ERIZDQUIfx0CESQ8A?= =?us-ascii?q?wUDBDgKFQ0LIQYVHQMZKx1AAwtwPTUUGywgJ513A3KCI4EBWYECAUqTfrFdg?= =?us-ascii?q?gaCD4pagSOVU4NuE5NZkgGSX4VJII1AlR0ThxWCFmyDPE4DKJcoineBHwIHC?= =?us-ascii?q?wEBAwmLSAEB?= IronPort-PHdr: A9a23:YL6GmB9+Jtb28f9uWUy7ngc9DxPPW53KNwIYoqAql6hJOvz6uci4Y gqPub410hfgZsby07p8ke3YsqTtCyQrwK2qlzQ8SqFKTAIPks4MngYtU4avAEz/K+P2PWRhR JwRHFBq8GumPkdLBc3we0PdomGo7T4VBx7zKRd5Kv76F4LMjsm7zeO/9pLcbwlUhTe2fK9/I gixoQjNrMcdnJFsKrw2yhvHo3tIf/pZyGZ1Ll+NnBjy+9m98od7/ytfp/wu+chAUb7nf6sjV rxXEC4mM2Eu68L1sxTIUBaC6WEdUmUSlRpIHhTF4RTnVZr/rif2quxw0zSBMMboUb47Ryit7 6ZzSB/pligHMSI58HrKgcB0la5XvQ6tqwB6z4PSfYqbNudxfrnFcN0ZWGRPXthfWSJDDYOyc 4QBAOQOMulDoonhvlsDtweyCRW2Ce7tzDJDm3/43bc90+QkCQzGxgsgEMkTu3TPsNX1M6ESX v6ox6TPwzXDa/RW2S386IjQaB8hu/aMUqlrfMrN0UkvGBnJgUmXqYzgJT+azPkNvnGd4uF9W u2hl3QppBttojiz2MgskI/Ji5oIxl3K9Ch0wok7KcG8RUJlfNKpEoVcujyHO4doTM0sTWFlt SQ0x7MJpJO2eDQGxIgnyhLBa/GKb5WF7xz9WOifJzpzmXxreLW6hxmo8EigzPXxVtGz0FZRs ipFncPMuW4W1xzK7siLUPx9/l2u2TuJygvd6flELFgpmabGK5Mt2KM8m5sSvEjZHiL6glj6g a+Qe0454Oan8f7nba/jppKEMo90jRzxPbo2l8ykBOQ4LhAOX2+G+eSgzLHj/VP2QLFNjvAul qbVrZTXKdoBqqKkAgJY0Zwv5wulAzu7zNgVkn8IIEpEeBKBkYfpJ0nDLO3lAfq/mVigjTZmy vHcMrDhGJnBM3jOnK/kfbln6k5czAQzzcpY55JRErwBLvbzWkjrtNzZFh82KRa0w+H8B9hmy oMeQW2PDrWFP6PVtF+E/PggI/SUaI8ToznyM+Il6OL2jX8lhV8derGk0YUPZHCiAvtmO1mZY WbrgtoZCWcFpAQ/Q/LuiFGYTz5ceW2yULw45jE8FoKrFojDRoW3j7yA2Ce3BIFZZmdDClyUC 3fna52EW+sQaCKVOsJhijMEVaO4S48lzB2uthL1xKF7IefP4i0Ysonj1MR65+3Jix4y7iV0D 8CH32GKVWF0kTBAezhj5KlgrEg19FqY3Kx/nbQMDdVM6vcPTAohOJrb0cR1DtnzXkTKedLfD B6CQ866SWUpQckox5oMb0x2M82llQzMxSexGrtTkKaEUs8a6KXZimL2LY5m13HA2eF1gV0hW MpXPHehjIZj7weVDInM1UyEwfX5PZ8A1TLAoT/QhVGFu1tVBUspCf2tYA== IronPort-Data: A9a23:r9q/yqlIILMf+gp/nwu/w6Ho5gxJIERdPkR7XQ2eYbSJt1+Wr1Gzt xIeXGyEPv6LZDGjet8kOoiz9BsPv5OGztA1QQA9qi49Qy4T+ZvOCP2ndUqhZCn6wu8v7a5EA 2fyTvGacajYm1eF/k/F3oDJ9CU6j+fRLlbFILasEjhrQgN5QzsWhxtmmuoo6qZlmtHR7zml4 LsemOWBfgf8s9JIGjhMsfnb+Esz5K2aVA4w5zTSW9gb5DcyqFFIVPrzFYnpR1PkT49dGPKNR uqr5NlVKUuAon/Bovv8+lrKWhViroz6ZGBiuVIPM0SWuSWukwRpukoN2FjwXm8M49mBt4gZJ Nxl6cfqEV9xVkHGsLx1vxJwS0mSMUDakVNuzLfWXcG7liX7n3XQL/pGKkUEM49J9L9NOWQQz 9cGJikkfh/aiLfjqF67YrEEasULH5C6ZsVG5CEmlHeAVaoTKXzBa/yTuJkBgml224YXQJ4yZ OJAAdZrRBrEZAdOIl4ND5gWgP+nwHL4dntRtTp5oIJtvDiInF0hj+SF3Nz9QYyxZOhYkGGhm k329E3wGzYEZYe71m/Qmp6rrqqV9c/hY6oKHaK18rh0jUaewmsNIBITXFq/5/K+jyaWQ91EM khR+CYkpoAq81e3QcPwRAS85nmesXYht8F4SrRnrVjTlO+Jpl/EQHQcQT8HY9sj8sYrLdA36 mK0cxrSLWQHmNWopbi1qt94dBviZ3JHHnxIfiIeUwoO7v/qpYx53FqFTc9uHOTxxpf5EC35i WLC5iUvpaQhvehS3YWC/HfDn22NoLrNRVUL/Qn5ZD+uwT54Q4+HXLaWz2bnw8xOFrvEcWnZj kM4w5CfyMssEaCykDe8RbRRPbOxuNeAHj7uoX9uOJgDrz+C8GOSJ9FMxDRQfWZoLcc2Vjv7a 2DDuQ5qxcFyPVn7SYRVco6OG8AR4qy4LuvcV9fQdctoXph9UCSl7RNeTxec8E61mXd9jJxlH 4mQdPidKEozCINl/WKQfPgc27p6/RIO7zrfar6jxiv2zIfEQmCeTIoEF168buoZyqegiyeN+ vZ9M/q68TluYNfcUAL2r7FKdUsrKEIlD6/Ys8ZUL+6PAjR3EVEbVsP+/+kTRJxHrY90yMH4p mqwS21J+mrZ3HfnEziHWlpnSbHoXKt8k04FADwRDQ6o9kUnMKmS7/Y5VpoofLMY2vRp4txqQ tIkJciRIPR9ZQ7W2jYabJXdhopGcTK1jznTPyaeQSMeeqR4TFfj4e7UfQrI9QgPABGotMA4n aaS6wPDTbcHRCVgFMzzas/z/2iuvHMYpv1+b3HILvZXZk/o1opgcA71sdMaPOAOLk/l6gaB9 gPLHyodm/bBk7U1/PbNm6qAiYWjSMl6P0hCGljk/aSEDjbb8kWj0L1/fr6xJx6Fb1zN+YKme elx5NP/OqdenF917qxNI4wyxqc6v9bSt7tWyzp/J0rybnOpNOJEAmKH1sxxpKFy1udnmQ+pa HmupPheG5u0Yf3ALnBABTAYftyi1O4VkAb89f4aAlv3zw4p8aulUXd9BQitiitcE6lYbaYkn fcHusELzjfjmj8GCNqnjz9VxUuIPHcvQ6UqjbBEIY7J2y4A6EBOXozYMQDyuKqwUtRrNlI6B wOuiI7ppaVu9mCbf1UdTXHyjPdg37IQsxV0/Xo+DlWumPPep/pqwiBUzys7fj5VwjpDzeh3H GphbG9xBKeWpzxuusxndEL0EiFjACypwGDA+2Erpkb4EXbxDnfsKVcjM9mj5EoaqmJQXgZK9 YGilVrKb2zYQ9HT7AATB2tF8vDtdIkkvEmK0sWqBN+MEJQGcCLoyP3mL3YBrxz8R9g9ngvbr O1t5/x9crD/KTVWmaAgFo2Gzv4FfXho/oCZrS1Jp8vl1l0wtN1/NfZi5qxxlg5wyyT2zHKF IronPort-HdrOrdr: A9a23:WqBbDqM1tZPRWMBcTtSjsMiBIKoaSvp037BN7TETdfU1SKylfq +V88jzuSWYtN9VYh8dcLO7Scy9qBHnnqKdiLN5VYtKHjOGhILCFutfBOXZrwEIVxeOlNJg6Q == X-Talos-CUID: =?us-ascii?q?9a23=3ARZcNDmuzmjOH0oNf6ubL5cHj6IsDdk/TzibeenW?= =?us-ascii?q?ADDhTY6ObUHaA9/prxp8=3D?= X-Talos-MUID: 9a23:UbsXXQV6elDo4GXq/AS8vxBPOclP2piBOEskmIwhpZjfETMlbg== X-IronPort-Anti-Spam-Filtered: true X-IronPort-AV: E=Sophos;i="6.01,254,1684764000"; d="scan'208";a="278389874" Received: from 115-166-5-15.tpgi.com.au (HELO [192.168.1.104]) ([115.166.5.15]) by rpt-cro-asav2.external.tpg.com.au with ESMTP; 04 Aug 2023 18:47:45 +1000 Message-ID: Subject: Re: PGConnection.getNotifications(0) doesn't block From: rob stone To: Pawel Veselov , List Date: Fri, 04 Aug 2023 18:47:43 +1000 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4-1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, On Thu, 2023-08-03 at 16:04 +0200, Pawel Veselov wrote: > Hello. >=20 > I'm implementing a bit that is expected to wait for published channel > notifications, > and once there are any - process them. >=20 > I'm using PGConnection.getNotifications(0), but that immediately > returns an empty > array, and doesn't block like JavaDoc says it should. >=20 > I'm on 42.6.0. >=20 > What am I missing? >=20 > Thank you. >=20 >=20 Have you read the JDBC docs https://jdbc.postgresql.org/documentation/server-prepare=20 which has a section about Listen/Notify? HTH