Issue Details (XML | Word | Printable)

Key: JDBC-294
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Jaybird JCA/JDBC Driver

Improve JDBC escape function implementation for CONVERT

Created: 27/Dec/12 02:35 PM   Updated: 27/Oct/18 09:53 AM
Component/s: JDBC driver
Affects Version/s: None
Fix Version/s: Jaybird 4


 Description  « Hide
The current JDBC function escape CONVERT implementation does not support the conversion specified in JDBC 4.1 (which have a SQL_ prefix), because it simply maps it "CAST({0} AS {1})".

This also doesn't work for conversions which require a length (CHAR/VARCHAR) and precision (NUMERIC/DECIMAL), as the CONVERT specification (see ODBC documentation: http://msdn.microsoft.com/en-us/library/windows/desktop/ms715381%28v=vs.85%29.aspx ), does not include length or precision.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 11/Mar/18 12:07 PM
Implemented

Mark Rotteveel added a comment - 29/Sep/18 01:21 PM
DatabaseMetaData.supportsConvert() and DatabaseMetaData.supportsConvert(int, int) need to be implemented as well.

Mark Rotteveel added a comment - 27/Oct/18 09:53 AM
Implemented supportsConvert