[Db-derby Wiki] Update of "JDBCSupport" by KristianWaagan

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by KristianWaagan:
http://wiki.apache.org/db-derby/JDBCSupport

------------------------------------------------------------------------------
  Since JDBC is the interface Derby is meant to be used with, the aim is obviously to support as much as possible of it.
  However, Derby's JDBC implementation is not complete. As new revisions of the JDBC specification are published, there will also be a certain delay between new specifications and the implementation of these in Derby.
  
- The current content does not separate between the different JDBC revisions, and the JDBC 4 revision (which is not yet generally available) is used as reference.
+ The current content does not separate between the different JDBC revisions, and the JDBC 4 revision is used as reference.
  
  == Datatype support ==
  The datatypes listed below are not supported in Derby. Note that not all of them have a corresponding class in JDBC (for instance, a ''getNString'' returns a Java ''String'').
-  * Array
+  * Array ([http://issues.apache.org/jira/browse/DERBY-4335 DERBY-4335]?)
   * Datalink
   * NClob
   * NString
@@ -33, +33 @@

  
  ||'''JDBC interface'''||'''Method'''||'''Embedded'''||'''Client'''||'''Related Jira issues'''||'''Comment'''||
  ||Array||''all methods''||<#FF9900>B||<#FF9900>B|| || ||
- ||Blob||getBinaryStream(long,long)||<#FF0000>Unsupported||<#FF0000>Unsupported|| || ||
- || ||setBinaryStream(long)||<#FF0000>Unsupported||<#00FF00>Supported||  || ||
- || ||setBytes(long,byte[])||<#FF0000>Unsupported||<#00FF00>Supported|| || ||
- || ||setBytes(long,byte[],int,int)||<#FF0000>Unsupported||<#00FF00>Supported|| || ||
- || ||truncate(long)||<#FF0000>Unsupported||<#00FF00>Supported|| || ||
  ||!CallableStatement||getArray(int)||<#FF9900>B||<#FF9900>B|| || ||
  || ||getArray(String)||<#FF9900>A - B||<#FF9900>A - B|| ||~-'''Bogus implementation on client'''-~||
  || ||getBigDecimal(String)||<#FF9900>A||<#FF9900>A|| || ||
@@ -116, +111 @@

  || ||setTimestamp(String,java.sql.Timestamp)||<#FF9900>A||<#FF9900>A|| || ||
  || ||setTimestamp(String,java.sql.Timestamp,java.util.Calendar)||<#FF9900>A||<#FF9900>A|| || ||
  || ||setURL(String,java.net.URL)||<#FF9900>A - B||<#FF9900>A - B|| || ||
- ||Clob||getCharacterStream(long,long)||<#FF0000>Unsupported||<#FF0000>Unsupported||~-[http://issues.apache.org/jira/browse/DERBY-1286 DERBY-1286]-~|| ||
- || ||setAsciiStream(long)||<#FF0000>Unsupported||<#00FF00>Supported||~-[http://issues.apache.org/jira/browse/DERBY-1286 DERBY-1286]-~|| ||
- || ||setCharacterStream(long)||<#FF0000>Unsupported||<#00FF00>Supported||~-[http://issues.apache.org/jira/browse/DERBY-1286 DERBY-1286]-~|| ||
- || ||setString(long,String)||<#FF0000>Unsupported||<#00FF00>Supported||~-[http://issues.apache.org/jira/browse/DERBY-1286 DERBY-1286]-~|| ||
- || ||setString(long,String,int,int)||<#FF0000>Unsupported||<#00FF00>Supported||~-[http://issues.apache.org/jira/browse/DERBY-1286 DERBY-1286]-~|| ||
- || ||truncate(long)||<#FF0000>Unsupported||<#00FF00>Supported||~-[http://issues.apache.org/jira/browse/DERBY-1286 DERBY-1286]-~|| ||
  ||Connection||createArrayOf(String,Object[])||<#FF9900>B||<#FF9900>B|| || ||
  || ||createNClob()||<#FF9900>B||<#FF9900>B|| || ||
  || ||createSQLXML()||<#FF9900>B||<#FF9900>B|| || ||
@@ -161, +150 @@

  || ||getURL(String)||<#FF9900>B||<#FF9900>B|| || ||
  || ||getUnicodeStream(int)||<#FF0000>Unsupported||<#FF0000>Unsupported|| ||~-'''Deprecated.''' Use getCharacterStream instead.-~||
  || ||getUnicodeStream(String)||<#FF0000>Unsupported||<#FF0000>Unsupported|| ||~-'''Deprecated.''' Use getCharacterStream instead.-~||
- || ||refreshRow()||<#FF0000>Unsupported||<#00FF00>Supported|| || ||
  || ||updateArray(int,java.sql.Array)||<#FF9900>B||<#FF9900>B|| || ||
  || ||updateArray(String,java.sql.Array)||<#FF9900>B||<#FF9900>B|| || ||
- || ||updateBlob(int,java.sql.Blob)||<#00FF00>Supported||<#FF0000>Unsupported|| || ||
- || ||updateBlob(String,java.sql.Blob)||<#00FF00>Supported||<#FF0000>Unsupported|| || ||
- || ||updateClob(int,java.sql.Clob)||<#00FF00>Supported||<#FF0000>Unsupported|| || ||
- || ||updateClob(String,java.sql.Clob)||<#00FF00>Supported||<#FF0000>Unsupported|| || ||
  || ||updateN!CharacterStream(int,java.io.Reader,int)||<#FF9900>B||<#FF9900>B|| || ||
  || ||updateN!CharacterStream(String,java.io.Reader,int)||<#FF9900>B||<#FF9900>B|| || ||
  || ||updateNClob(int,java.sql.NClob)||<#FF9900>B||<#FF9900>B|| || ||