Re: Need java.sql.Array impl for PreparedStatement.setArray()
Posted by: Thomas Mayr
Date: July 04, 2005 06:47AM

Hi Mark,
1) I agree it is optional.
2) Normaly I want to know if a features is supported before I install the software and write a test program. I have the Connector/J Documentation of version 3.1.0 where it is clearly documented in the release notes that this functionality is un-implemented. I'm missing this chapter in the current documentation.
3) Oracle supports the definition of a domain data type as VARRAY. This domain data type can be used as data type for a column. I cannot say if this is compliant to any SQL standard. However I can use this data type to exchange arrays with JDBC. I thought MySql supports also columns with arrays but this seems not to be the case.


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.