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.96) (envelope-from ) id 1wipCQ-000QpN-1T for pgsql-general@arkaria.postgresql.org; Sun, 12 Jul 2026 08:06:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wipCO-006Q9I-37 for pgsql-general@arkaria.postgresql.org; Sun, 12 Jul 2026 08:06:05 +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.96) (envelope-from ) id 1wip9A-006KYx-0s for pgsql-general@lists.postgresql.org; Sun, 12 Jul 2026 08:02:45 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wip98-00000000vNU-0Ate for pgsql-general@lists.postgresql.org; Sun, 12 Jul 2026 08:02:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1783843361; x=1784448161; i=shammat@gmx.net; bh=MYw3JY5bCyxyJfpuYRR/AYPoCcR5IqGVf8qBruMzr74=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=EyVIdLMVazfV6x6TkE52Gi700GOsXwhjHU1Dt3HYBMYr2fLw9AaCBzqPtP2MdMYx moImohPVX6KEZiQr6WpBzSGUylKWfQR6sfUUlCdUUgPUJrarxaNcqi4TaCWcHdBr4 JKnt6PDxAp7u5AIxdwr/sYFLW4ZPBgPVt+VMP4VyfhLKa05lMxD6Eik6Zhx/r1oLG UqR5eg6r8prgLb+nzCQ+RKRBAm45M+q0ICYIcLyzxPAioIRhMEnVWJz9EqD7lc1zZ kXJZ1Oe+8O10t/+JCY69Nnizvmovipj04FeBFI2q5HdX7rTZlJQZlePSE6yTjEvpt RURdZciQ+A6RSfLopA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MgvrB-1xGnam2UsX-00Zk12 for ; Sun, 12 Jul 2026 10:02:41 +0200 Message-ID: Date: Sun, 12 Jul 2026 10:02:40 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: JDBC issue To: pgsql-general@lists.postgresql.org References: <5cce543a-3589-4a82-a3df-b6943b21ce21@sdc.com.au> <249a6fb9-4d31-4640-a391-0b6e16798667@sdc.com.au> Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: <249a6fb9-4d31-4640-a391-0b6e16798667@sdc.com.au> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:Klkdqiotau6j43lI0/OfbHRObzc1hvSMoRX02Ad2VXWvI7KnuAI e0NI5SAuwvIbi0PxtEIPFPsxirqm/GqPRDq1ymcJb5z1SU2NEt2Oz2kJPcFiDFGhNz05/R+ ycVhjfJoBpNCi+Nh5b7axz69gWX4qDWZ/ztph3jyzbqcq4yz/zVte1OU7jHYhlCbJyweLOJ vQvGb2WzYBWzbz7tjKADQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:plMPeMlPw8s=;vw1HeB1cHDk0uBpuTs6ClfGUTZV FQCieJKB0QPPXFueWjwEEw8e8WiFrlTIvailUCd+oQRZ04GQI30qX/pIclgf6SNS6bevvatyD rPEb/em2wVVclciGQB3cbhJBknLcWcZ3gjT/eW0ooQGQxFcTB8FzjFgnNWMdUq+0x/waty9b/ nLjwGgk6GYFXZZi8he6bYlNoMa0GrBKZ0mTxknmWlSCXt7uXWNb4cwWHwrjOWRocVaBBf1WtU YP/405n6qXm5jBM0+KDKvHRys+uAg5NsHj2HdFw5yVVEj6jc2YQoB4/DrZIJkV8ZkQbS1g8wj PNjiloyNtyDyLM73lM6TNV9O9uIKs1/kKVpS+5ZFB7eTw3j8KqPX+gCy9U8bAgG8tDwf2wqqU 4JbDHKR5cKtTOiGF944fC3+7q728nFCR9vW05e909Sllm1GiZd5PnGfaCBhTrhC73fvMksxEL k7AJrru84W2koMG4ZOiZOS1Uyft4MnPyJMSQj3/6ciJoULcnDharmM97woTgs4cYJLBbhkH16 DA0TZ5OHqTViojRFbrcZn+Z5cVpnStujUEA8kgAe6eq/KTWMmeKNEodERe5r6Ll04qPnO07so yspv8hfQu8eHcegFhnYIEplQm7OXN/fv4ymQr9a0t/FQ4PW88IFmoAiMYYpmjMawmLfNO/jf3 d4Lzrrr5KX6qa+/b7jWdCdUbfSq+ycvR0berMd+6IaoRIvUjTuKy1LK8uvZ09uuhejOhUK3xd MbneYoMAKpPfIBQkX5ioLcz2WSTH07Ucqf5cATyzkqccxBQWWHL8cj7Nh3kA5//slilOZgUTB wlkIzgxHpqkIzHneoyHMeYGPenBWeChXeM6DnlDynQwrsLKPxMS/yUkkjnm0tvpKpLX8eTbHa IT70NPe1A0DjQNHwl/GbsPX1yVO0afzg2jJ6k3HXBlvoDyMV307Qz6Kag2TecTubB+IMDJRj5 LH7+CE6D8W2Ysi46cS+W+448P3SzcOB6oC4NH30LszZzT+ukSGWRntawSR0gdSzttDxKCikOa brwIBqoxMSb+DX7obm6w/va8s7itnuHnQH/6Y37J9XGTWOZashLI48f5j0jGdY1E5Ed/gStq9 R7+HdAUO7fuSZBxjGDRAefPaLzIFpNLiheFDpADt45LoFi0F4nDgFXMlZZJ3od8qnY15AzDiW jOMoJ/ADELNUsmEwFLLnu/V9nKyHiw/vEa/ShGqycKOaUS8CxDeoqEdPT12WrgVrSl0sUVUuP wKjI6QJfu+uZ5QDDnJGmU+fN15Qui92wr8NohReKMgyS/yYcQX3L+9fOtLqgKLsEAgY/grk1i 38Nt5pDhtWYPdZTTc7LqPMWmKb9vmmPeMALGnHsUwmIdKSiRmwjG/UKwJKKgjAfA9dc04R77a 5awBSFRPUznUqvUusKvpE1ZctqvyOcc8tzM4jtNREBbxKpd0y/euVOOBGamjjqQfkRA9ysChI 9AEnG6q8J/8235PjGkVzaYMvtaEmvTU36sM3L1jtffgySuKv5Mf0eo8BbeiFdoquVxf3uUtNs F4QfRg906r/Du09FNbsSElnIpslXAVruSp4800/BSRM1RKf09mwZg/NKjMtIlHn8wVnazS31/ IM1bMJkkhx1vMod+LxEeb+WM2VwLabd9U+bI23xNvNKslAGiAU/1vIse1V36oC9AODH8tJ9Jx jSPwyl+DZHAfzwrJze8xiMpjJz05hO7INQAjkFAP9/zv7ZIM7+xyUWT9m5zsfutl26/R7Bs5f n8rM7ksZSwTYi3MpVHIhlJtBBGhNpGVWHn7O8VMfUmt3Ga8Fhw45dhpgh3wNd8yBjnkh9HcHq MTD3H/g/EQylXcCab3Pr6RVCQbgNSbzY1kwOe1WwI9sI7BCjbvVspNcsk9iVBlIKHkx9y+TSP E5hJU8fkc/VViYBDOox3vVKpnJMlp7alRkbwndzWTXmpYdnyX4Rj5oL4ZOifXUq+XK0Xv3iO/ Wz3Gu0s+6yhcNi+ciIO3LHVa3+Z6KPOCviXcw8gICv2DczfNtm/abS2sjOZLSEigAX+2D6JDQ YCaBCUbkd7vrjH+mjSiXO6pdS6sQkVetUQwt+9VgsZ8sQkw0ykXXybkqmaPQhY0iOVdxMHLN9 JkiJhtvHzO2Woq52T2OpNEgDCQz7WTfs0HUZo0hviw6qotR8qXSSGKab3VkudYGqIMmRAHFCz kHRWexhPrlX2Gp0l8TqtG1Mfk/NQQRlzUawMENPPOmZtm4ngN/cdUUtxr6IRSMw3NLbKQ34Rf WRLpzxEIYoxMf9SW/LQEpqqvWkizhSrhy/KziaJRGQKC/kPJ95AraxxMK0xQVo3n8B/KHzzy7 olLPMKrB8OIr+Or6z/Kzi8k/vYCmZvXBq/BkrTyEjXnokqiy0pPD7K12AK3AyR5XzcYQZXJ8h BgTSL3gP+XFM/oilaOv6BtRG1NS199EUBgVA6ijP9K2o74/tZ+5alLq25g6UEn7+6txgGKUyB WMU8TIVRbduhyX+ADxAnUrIZyuj6ENuquU7RM7z2ziIs2MPAyhbz/S83N2rcgNqSiy7Xb+QFF 3gLpGEap8h7uN6yYjif6sdxTNz+BOFIYRFwXEnWNVvNT0JV4GSMH16MOM2MlldO4unEzak1We bgxZp9RQ5ApH6d/ezutma+sC8IdgyKdyOQ4EACwDguIvVlMSSeFh1Nja9DC5U3pme9tpYCk6D klE2y74dfeUzrCPIwqvX+Hm/qQDKzNNFsjpIJgirO3jSNMh6tUyd2+2w5URgvxsGo6D1E8gxL mW9RG0Vu7fz/L70gIL4eMW14uD8WPTKhN+GWRNLWhRw3rk1OpFghTLfuXrrok21UsLI9Zp822 3+PVpdYo+AoPTjlmzc53K+YCkz9bxEgBoxKhSm0pmF1tMDtMZ4Gbk+0BY+c4G7a4tRzlqD0S+ KCS/hzbFbQdV70BKpoug5gWc5/wr91sZBtOfXIZFM0CnVLH4O5+TPd5FIWNWcQjNxOKmrl3RB LJzapUx2pduopIIji8/J2Ons9GETupb7A8J4IC978yMF4iBwGEJhjjKTeJhnVqDax6frUBFHX QQyM0rhqzScvx5g93pPPoyqmfY8Hs/pOg6I4y/Ux7y+y5E97Djm81c2plY+S/8fZE8E3QqyYI P4aBqeU6JNHUEdvBaJDoV8HMYi9vtsw78FBU/x7DnM9KPFCmWW3K+0wXKZyDsHZqOYpiYHQ7w pHBBI11DDRd9ciG14rtil4mSabWJxY7vh2bTBa6EuvhX620mBiL4ClrNOdVbc4sBc5WVnmVg8 oSGCwLbR7Z7B9dOhvm7fR6mayl26VQVLfxbphNByiBxPsSs0LSmdy2gx9DUMLbK3m+DuagX1b qBqQvf6IfdD+v9CqeK2WaWroygRo+CWqg5jbGTsbvS/aOpDhHVl+cKd3Mk0RQPitpQN547cDE +Fogv3TC1cNK6J+pDjUUmWC+t+K3nG4m2oyD3fNrUlYxPpQ/VWbMfIC/a8WbZW1VMXTi2eUij XhTjLqOH+cZ0aet0c07mK/genwMQPyVe8xDR1i34XBGSEY3nUjiCbvjER/H01n3ZkvVCFHX2k KUYS4MNGAmThtcmUCcqRWlCRXRSp7hO1TJOuEvHWmbWtynyAwocyKTl2W8zIqXAcLkexdPFJ8 lB2bgXKIhHSXLm4Us8sLvjTr0IX0fM7n1HcsnUlQIpabN5mYpitKK/EB1uL5x9w8cQPvVXIm+ YqB+a3TC/URve4672O3Or8t6U6W3kra7PfRNFbprZ0l5iS8TGHwIybxYo9lALIUqinLW/2mev 66oSBRYo1FXULIt2+mKPwv/Kdp/SrH7Nktj0LpZx/wphMBeDPjagJggPlhHZc40Km2Erhh9C8 Wfgb2ggyeidwJXYWpWs6HcoJDWYqoTeJFicLxQlIIZCQq7ciAMepBrgAzc9K59UyNraDB1GJ+ a7JSXd4TuXyxLwoHTxgjYlrlkb2JXUYeBKfFFOWdOJyhFuCU2XUf0dz/hSc4GbQswdsu/fjCE lMRJ3viOXGjB7pgDsU6Cu3zqwUAHs16JoVBL1om6LmTIfeTxW/FP0w26w1eOagXMC6sg/1zZj eYh/BSAgDlqE1axY9pV/IMaX20nAdm43Z/i09/NeeO5BFtOZf9EmiNTKJjUlEuNRI8JOxXAmZ 0lBFX0hiH7UoAfnnEeBV56tIYZMbcWkxBqJvUjq+lW3e+rm9uohul8t9/tn4NruPIdPZm3wAn zw+NfSxcnFgLCUmSY77nde92vjyUiERZPiDxUzzoczxGY1T1MtuLK6ShHhyJrDk/aS4G5b7Eh ylo0mDDQTHpIShNZbehgPqAQd+r6PUSLrgchv5JUmdFbn3ejT6KIXRB2HXT+f5QNl1K1l5+Zk I91fKxaRE+PCFvGw6T/UZQsos138LW9R85e9TG3e0vtkYAyh/u4oYRy0iLs4KoiWLV24gF5Tl rL7y90ocGRLGxl8s1T74q0RXTXF7GxZWU7rlIGyKwFqG2JqWoPzQsyiHI+XxQ/+TnHcSLfp89 8rq5MSg2xkVDmswrpAzFSTd669qE/Mon4EdojpSJwDCALDKcrOaWuAhdDn+yK95ssWjCtnjzZ UJKWLZDE3ziodOA0CY7rlulQwVASADXN6SBEIJvUtP1r6vJGlRIViIuezgcyKdPcWuHZlGtNN /8DdrzNIfa3y58Fu3uyBbmdQs4q7VyjR4muEB9gp1X9GP6BWpg5tBNLWZAfrH7KA1lyyj+/+v qAtuL9wwmbuePcF0zxLkxXuNR3WvdqgSGWMi510Oa+VdKY1+NtjFz/BxnqXjW93AWxQY9XW4W 9plZ6/h/jI7ZQ5tZ4aconDtsSOcPWI4VAUi5qJMWxaxvsdSpozxbyRFAfGgW/r6SFwzJce4vE vWVZAj4CHmNJ00OFaOLgJZjzYIbp9pW88IKzPf9pXgtvQxJg8+kH283klLuQFL3V1WGt8OIZz ysPX8eMdzo2n+a2nRxvK2sf+54D1QotISove1HlA8L//MTGeCa4R92UWJKMhScH0Qj3R26Nff TNlsEoqLZvdZbtpa7h3VD0DapN/UhYimqpyLkH0FZfs7IYe1g64iuaRogNfOLvmhzS0c850cr wBckf/UDWCjEqm9paJcCiOivAwBkGOhnNAquFq+883Yho6V86Ps8xCudvyJ7fifEmS3ry1IwL em/9YbJ2G3eQkAsGKhR6s880ZKMl7rM0aOMn9q07MMfD+GL5W/t7gsTek/l9QJj5PpE1D6GSC wLx0Nw1mEToY3Bfm7aQ/bqrtAGiKsCFffKk77asV6mA3wxpiuJ94+EHOwIfElt6YtYmjjckRA AIkEUuBsyhcSxTHn4UBBAbxcmTM4v7pShmxWyYE2jX3WVW4hgO4dpOcH2iILa60GRl9jLExRU tzvDcFbNVvVNlT3n8HmsVImxJrfGNeEwQfBc3NcOX+pYdlZPNmMXsbTUKWmQT/hiZsTscR3Zy TCvakPuj/TTBVAS6+ycn5aPllNAeiNyLSpqdI3NRsAhEZLIkzx11o8SZq3tIYAQITi2TQzG1n PM1BOU8fASDvMnvfao5ZAZvPvZx415Xp6a1G3uawLFxUfa27CJrM8fnVc4YxCgSkh84gOl7RC juj0iw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 12.07.26 um 09:40 schrieb Stephen Davies: > Root Cause >=20 > java.lang.NullPointerException: Cannot invoke "java.sql.Statement.execut= eQuery(String)" because "st1" is null > =C2=A0=C2=A0=C2=A0=C2=A0org.apache.jsp.jsp.browsewineries_jsp._jspServi= ce(browsewineries_jsp.java:171) > =C2=A0=C2=A0=C2=A0=C2=A0org.apache.jasper.runtime.HttpJspBase.service(H= ttpJspBase.java:62) >=20 > Tells me nothing more. > The code has to go past the connection and statement lines to get to the= query line. > This code has been working for several years before today. There is a variable named "st1" in the servlet code which is NULL. This is not a Postgres error, but an error in your code. You need to check how st1 is populated in the Java code. If I had to guess: the code retrieves data from the database and receives = a NULL value that it does not expect and thus not check.