https://sourceforge.net/p/squirrel-sql/bugs/1513/2023-03-27T07:43:54.625000ZRecent changes to 1513: NullPointerException on SessionProperties:SQLResults:Text2023-03-27T07:43:54.625000Z2023-03-27T07:43:54.625000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.netd1e895c4621ea98b78e6c9cdce4b6adff511f5fd

<div class="markdown_content"><p>Fixed in our GIT repository, will be available in future snapshots and versions.</p></div>

2023-03-27T06:18:27.589000Z2023-03-27T06:18:27.589000ZKlemens Kreindlhttps://sourceforge.net/u/cky01/https://sourceforge.net06ea2454121e69e180acc117e43f81af59f0ce6b

<div class="markdown_content"><p>When setting the value of SQLResults to "Text" in Menu Session:SessionProperties a NPE occurrs when executing a SQL. Using the Default setting "Table" works fine, also the tab "Results as text" is shown with no problems.</p> <p>"Log-Window"-Squirrel<br/> java.lang.NullPointerException<br/> Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total: 0,029, SQL query: 0,028, Reading results: 0,001</p> <p>Extracted Log</p> <div class="codehilite"><pre><span></span><code><span class="mf">2023</span><span class="o">-</span><span class="mf">03</span><span class="o">-</span><span class="mf">27</span><span class="w"> </span><span class="mf">08</span><span class="p">:</span><span class="mf">03</span><span class="p">:</span><span class="mf">38</span><span class="p">:</span><span class="mf">926</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">ERROR</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">messagepanel</span><span class="mf">.</span><span class="n">MessagePanel</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">privateShowMessage</span><span class="p">:</span><span class="w"> </span><span class="n">Exception</span><span class="w"> </span><span class="n">was</span><span class="p">:</span><span class="w"> </span><span class="n">null</span> <span class="n">java</span><span class="mf">.</span><span class="n">lang</span><span class="mf">.</span><span class="n">NullPointerException</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">fw</span><span class="mf">.</span><span class="kd">data</span><span class="n">setviewer</span><span class="mf">.</span><span class="n">textdataset</span><span class="mf">.</span><span class="kd">Data</span><span class="n">SetTextAreaController</span><span class="mf">.</span><span class="kr">get</span><span class="n">RowCount</span><span class="p">(</span><span class="kd">Data</span><span class="n">SetTextAreaController</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">79</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">fw</span><span class="mf">.</span><span class="kd">data</span><span class="n">setviewer</span><span class="mf">.</span><span class="kd">Data</span><span class="n">SetViewerTextPanel</span><span class="mf">.</span><span class="kr">get</span><span class="n">RowCount</span><span class="p">(</span><span class="kd">Data</span><span class="n">SetViewerTextPanel</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">112</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">rowcolandsum</span><span class="mf">.</span><span class="n">RowColAndSumController</span><span class="mf">.</span><span class="kr">on</span><span class="n">RowColSelectionChanged</span><span class="p">(</span><span class="n">RowColAndSumController</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">141</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">rowcolandsum</span><span class="mf">.</span><span class="n">RowColAndSumController</span><span class="mf">.</span><span class="n">callSelectionChanged</span><span class="p">(</span><span class="n">RowColAndSumController</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">113</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">rowcolandsum</span><span class="mf">.</span><span class="n">RowColAndSumController</span><span class="mf">.</span><span class="n">setDataSetViewer</span><span class="p">(</span><span class="n">RowColAndSumController</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">134</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">ResultTab</span><span class="mf">.</span><span class="n">init</span><span class="p">(</span><span class="n">ResultTab</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">208</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">ResultTab</span><span class="mf">.</span><span class="o">&lt;</span><span class="n">init</span><span class="o">&gt;</span><span class="p">(</span><span class="n">ResultTab</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">162</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">ResultTabFactory</span><span class="mf">.</span><span class="n">createResultTab</span><span class="p">(</span><span class="n">ResultTabFactory</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">30</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">SQLResultExecuterPanel</span><span class="mf">.</span><span class="kr">on</span><span class="n">AddResultsTab</span><span class="p">(</span><span class="n">SQLResultExecuterPanel</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">667</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">SQLResultExecuterPanel$</span><span class="mf">2.</span><span class="n">lambda$addResultsTab$</span><span class="mf">0</span><span class="p">(</span><span class="n">SQLResultExecuterPanel</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">300</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">event</span><span class="mf">.</span><span class="n">InvocationEvent</span><span class="mf">.</span><span class="n">dispatch</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventQueue</span><span class="mf">.</span><span class="n">dispatchEventImpl</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventQueue$</span><span class="mf">4.</span><span class="kr">run</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventQueue$</span><span class="mf">4.</span><span class="kr">run</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">base</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">security</span><span class="mf">.</span><span class="n">AccessController</span><span class="mf">.</span><span class="n">doPrivileged</span><span class="p">(</span><span class="n">Native</span><span class="w"> </span><span class="n">Method</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">base</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">security</span><span class="mf">.</span><span class="n">ProtectionDomain$JavaSecurityAccessImpl</span><span class="mf">.</span><span class="n">doIntersectionPrivilege</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventQueue</span><span class="mf">.</span><span class="n">dispatchEvent</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">Main$</span><span class="mf">1.</span><span class="n">dispatchEvent</span><span class="p">(</span><span class="n">Main</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">103</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventDispatchThread</span><span class="mf">.</span><span class="n">pumpOneEventForFilters</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventDispatchThread</span><span class="mf">.</span><span class="n">pumpEventsForFilter</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventDispatchThread</span><span class="mf">.</span><span class="n">pumpEventsForHierarchy</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventDispatchThread</span><span class="mf">.</span><span class="n">pumpEvents</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventDispatchThread</span><span class="mf">.</span><span class="n">pumpEvents</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">desktop</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">awt</span><span class="mf">.</span><span class="n">EventDispatchThread</span><span class="mf">.</span><span class="kr">run</span><span class="p">(</span><span class="n">Unknown</span><span class="w"> </span><span class="n">Source</span><span class="p">)</span> </code></pre></div> <p>Tested with 4.4.0 and 4.5.1 </p></div>