What's new in CsvJdbc 1.0.24
May 16, 2015
- Allow case-insensitve SQL function names for java methods
- Helpful error message when SQL has subquery
New in CsvJdbc 1.0.23 (Mar 24, 2015)
- Bugs 107, SELECT DISTINCT with table alias not working 108, SELECT sample.id FROM sample not accepted 110, Connection.isValid() returns false for valid connections 111, COUNT with GROUP BY incorrectly counts NULL values
- Feature Requests 60, Add CASE ... WHEN tests for simple lookup tables 89, Implement DatabaseMetaData.getIdentifierQuoteString
New in CsvJdbc 1.0.22 (Dec 30, 2014)
- Bugs 106, Parentheses not accepted in WHERE clause
- Feature Requests
- 75, Add SUBSTRING function for unpacking encoded fields
- 86, Add support for /* comments */
- 87, Allow empty quotechar to disable quoting in CSV file
New in CsvJdbc 1.0.21 (Sep 9, 2014)
- Bugs:
- 104 Connection.close() not closing all Statements
- 105 Detecting missing or invalid column values
- Feature Requests:
- 81 Add || for string concatenation in SQL
- 82 Allow user to define extra SQL functions
- 83 Add ANSI SQL COALESCE function to handle SQL NULL
- Support Requests:
- 39 Report line number when CSV file has wrong number of columns
New in CsvJdbc 1.0.20 (May 24, 2014)
- Bugs:
- 100, Escaping underscore in LIKE expression does not work
- 101, Date fields containing month names not read correctly
- 102, milliseconds values lost when parsing times with "HH:mm:ss.SSS"
- 103, Unchecked ArithmeticException thrown for divide by zero in SQL
- Feature Requests:
- 26, separator as a String
- 78, Add SQL TRIM function
- 79, commentChar as a String
New in CsvJdbc 1.0.19 (Apr 22, 2014)
- Bugs:
- 99, unit test TestCsvDriver.testTimestampFormat fails when locale is German
- Feature Requests:
- 74, Add arithmetic modulo for sampling large dataset
- 77, Enable CsvJdbc messages to be localized
- Patches:
- 22, Read fixed width files with comma separated header
New in CsvJdbc 1.0.17 (Oct 22, 2013)
- Wrong strings read from DBF file with ISO-8859-1 extended chars
- Allow double-quoted column names, column aliases, table names
- Add DAYOFMONTH(), MONTH(), YEAR() for extracting parts of dates
- Add HOUROFDAY(), MINUTE(), SECOND() for extracting parts of times
New in CsvJdbc 1.0.16 (Oct 14, 2013)
- ResultSet.getBoolean() incorrectly returns false for '1' column values
- ResultSet.getString() returns value for closed result set
- NullPointerException calling ResultSet.getInt(), getLong() for DBF file
- PreparedStatement with "Name LIKE ?" throws SQLException
- Reading Date field from DBF with getDate() gives ClassCastException
- Reading Date column with getTimestamp() gives ClassCastException
- Provide main class for use as command line program
- Allow multiple SQL statements in Statement.execute()
New in CsvJdbc 1.0.15 (Sep 2, 2013)
- BETWEEN with Date column returns true for all values
- ResultSet.getMetaData() throws NullPointerException when columnTypes empty
- ResultSet.getString() returns null when used before first row
- Feature Requests:
- Add comparison of dates, times, timestamps
- Add NULLIF(a, b) for converting empty values to NULL
- Allow DISTINCT in aggregate functions in SQL SELECT
- Add CURRENT_TIME constant for easy timing of SQL statements
New in CsvJdbc 1.0.13 (Apr 19, 2013)
- Bugs:
- 3608195, NullPointerException using PreparedStatement.setDouble()
- 3607707, Connection.createStatement() no check for closed connection
- 3607089, ResultSet.findColumn() should throw exception for bad column
- 3607094, CsvJdbc does not compile with Java 1.7
- 3607811, Statement.executeQuery() no check for closed statement
- 3609162, Enable use as JNDI DataSource in Tomcat
- 3609382, SQLException when calling ResultSet.wasNull()
- Feature Requests:
- 3608402, Add LENGTH SQL function
- 3608846, Add META-INF java.sql.Driver file so driver always available
- 3609557, Implement ResultSet.getFetchDirection()
- 3609821, Connection.prepareStatement methods missing
- 3605695, Implement ResultSet.getRow(), it currently throws Exception
New in CsvJdbc 1.0.11 (Nov 19, 2012)
- Using expressions in WHERE clause results in SQLException
- 3558599 Brackets [ ] added in column name
- 3586794 SQL ORDER BY fails with java.lang.OutOfMemoryError
- 3554940 Usage with SQL Explorer
New in CsvJdbc 1.0.10 (Jun 19, 2012)
- Fixed-Width File Processing
- Implement Statement.setFetchSize(), getFetchSize()
- Expand scope of raiseUnsupportedOperationException prop
New in CsvJdbc 1.0.8 (Mar 12, 2012)
- Bugs:
- 3453397 No Maven coordinates for CSV-JDBC
- Feature Requests:
- 3491162 Add SELECT COUNT(column) aggregate function
- 3489556 Allow column expressions without alias
- 3470365 added ROUND SQL function
- Support Requests:
- 3480985 syntax for property in jdbc URL
New in CsvJdbc 1.0.7 (Jan 6, 2012)
- 3458207 CsvPreparedStatement class missing
- 3449526 Newline in SQL not accepted: SELECT *\nfrom sample5
- 3448470 Expression 1 + N * 2 evaluated incorrectly in SQL statement
- 3443417 Creating statements in a loop results in OutOfMemoryError
- 3441792 Throw SQLException when CsvResultSet already closed
- 3433690 select id, null from sample gives NullPointerException
- 3431180 ClassCastException when using IS NULL in WHERE clause
- 3431044 ClassCastException when using LIKE in WHERE clause
- 3429822 Wrong column types for expressions in ResultSetMetadata
- 3428347 Bad column names are accepted in queries without error
- 3428341 Bad column name in WHERE causes NullPointerException
- 3426549 Querying file with only comment lines gives NullPointerExcep
- 3426028 Running unit tests with ant results in many ZipExceptions
- 3424815 Column type "Integer" causes exception in meta.getColumnType
- 3424489 Values in "columnTypes" connection property not checked
- 3420422 Literal string column value is converted to uppercase
- 3419747 NullPointerException in CsvConnection.prepareStatement
- 3419063 Date parsing functions wrong, unit test fails
- 3327239 Inputstream needs reset on CsvRawReader
- 3110371 Too many open files
- 3102466 Double quote - java special character causes exception
- 3080535 Quote in value causes problem