Recent changes to bugshttps://sourceforge.net/p/csvjdbc/bugs/2021-04-14T17:27:28.846000ZRecent changes to bugs#132 Avoid deprecated Double(double), Integer(int) constructors2021-04-14T17:27:28.846000Z2021-04-14T17:27:28.846000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.netecaecba9e5522e5fb93e5d3da030daed71b666e8<div class="markdown_content"><ul>
<li><strong>status</strong>: pending --> closed</li>
</ul></div>#132 Avoid deprecated Double(double), Integer(int) constructors2020-08-30T13:13:30.666000Z2020-08-30T13:13:30.666000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.netc3518e38e98527ee9e596987bcfe3247aadc6600<div class="markdown_content"><ul>
<li><strong>status</strong>: open --> pending</li>
<li><strong>Group</strong>: --> </li>
</ul></div>Fix test testTimestampFormatGermany in Java 112020-08-30T13:03:52.763000Z2020-08-30T13:03:52.763000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.netb98da482f43ed95570f2f44c727c55e26e26d166<div class="markdown_content"><p>Fix unit test TestCsvDriver.testTimestampFormatGermany that succeeded in Java 1.8 but fails in Java 11. Stack trace is:</p>
<p>java.lang.NullPointerException<br/>
at java.base/java.util.Calendar.setTime(Calendar.java:1800)<br/>
at java.base/java.text.SimpleDateFormat.format(SimpleDateFormat.java:974)<br/>
at java.base/java.text.SimpleDateFormat.format(SimpleDateFormat.java:967)<br/>
at java.base/java.text.DateFormat.format(DateFormat.java:374)<br/>
at org.relique.jdbc.csv.TestCsvDriver.testTimestampFormatGermany(TestCsvDriver.java:3869)</p></div>Avoid deprecated Double(double), Integer(int) constructors2020-08-30T10:27:29.202000Z2020-08-30T10:27:29.202000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.net2ed43f8aef2ac1e8d72f0869b1f89a0eeaa542f7<div class="markdown_content"><p>Avoid Double(double), Double(String) and Integer(int) constructors in CsvJdc source code that are deprecated in Java 9.</p>
<p>Static valueOf() methods should be used instead.</p></div>Avoid deprecated Double(double), Integer(int) constructors2020-08-30T10:27:29.202000Z2020-08-30T10:27:29.202000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.net5bab2606eb06c00b9dbc59309e1984c6725ea28d<div class="markdown_content"><p>Ticket 132 has been modified: Avoid deprecated Double(double), Integer(int) constructors<br/>
Edited By: Simon Chenery (simoc)<br/>
Status updated: u'open' => u'pending'</p></div>Avoid deprecated Double(double), Integer(int) constructors2020-08-30T10:27:29.202000Z2020-08-30T10:27:29.202000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.nete5d721d19aa633e5c11408d3ac3b66318e440c70<div class="markdown_content"><p>Ticket 132 has been modified: Avoid deprecated Double(double), Integer(int) constructors<br/>
Edited By: Simon Chenery (simoc)<br/>
Status updated: 'pending' => 'closed'</p></div>#131 Query on CSV files with no newline on last line not working with indexedFiles=true, fileTailPrepend=true2019-11-30T14:40:02.243000Z2019-11-30T14:40:02.243000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.net1ca00a5e0188e3b23f7c3b8154bdb2e035cc93f7<div class="markdown_content"><ul>
<li><strong>status</strong>: pending --> closed</li>
</ul></div>#131 Query on CSV files with no newline on last line not working with indexedFiles=true, fileTailPrepend=true2019-11-23T11:56:19.477000Z2019-11-23T11:56:19.477000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.netea46e1554a35cb6a763487a998a53818381650fa<div class="markdown_content"><ul>
<li><strong>status</strong>: open --> pending</li>
<li><strong>Group</strong>: --> </li>
</ul></div>#131 Query on CSV files with no newline on last line not working with indexedFiles=true, fileTailPrepend=true2019-11-16T10:48:09.166000Z2019-11-16T10:48:09.166000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.net455f290e8819c39d16b7edebdea42bfb6e25a2be<div class="markdown_content"><p>A workaround is to set fileTailPrepend=false. Then the additional fields from the filename are added to the end of the line, not the start, and the SQL query is successful.</p></div>#131 Query on CSV files with no newline on last line not working with indexedFiles=true, fileTailPrepend=true2019-11-16T10:40:37.478000Z2019-11-16T10:40:37.478000ZSimon Cheneryhttps://sourceforge.net/u/simoc/https://sourceforge.net0885cc0713f3e77ab6e7df82ecf9248b0c30d3a4<div class="markdown_content"><p>Adding a System.out.println() in method CsvRawReader.getNextDataLine(), I see that the first line of the second file is appended to the last line of the first file:</p>
<div class="codehilite"><pre><span></span><span class="n">f3</span><span class="p">,</span><span class="n">f4</span><span class="p">,</span><span class="n">column1</span><span class="p">,</span><span class="n">column2</span>
<span class="mi">333</span><span class="p">,</span><span class="mi">444</span><span class="p">,</span><span class="n">abc</span><span class="p">,</span><span class="n">def</span>
<span class="mi">333</span><span class="p">,</span><span class="mi">444</span><span class="p">,</span><span class="n">ghi</span><span class="p">,</span><span class="n">jkl555</span><span class="p">,</span><span class="mi">666</span><span class="n">mno</span><span class="p">,</span><span class="n">qrs</span>
</pre></div>
</div>