[ https://forge.continuent.org/jira/browse/SEQUOIA-1062?page=comments#action_14421 ]
Emmanuel Cecchet commented on SEQUOIA-1062: ------------------------------------------- The current implementation serializes blindly the Array object. The code basically duplicates setObject code but it does not ensure that the underlying Array object is serializable which is likely to fail with a bunch of drivers. The Array should also create a reference to the ResultSet object (currently not implemented as many other parts of the Array API). The code could be inspired from the PostgreSQL or MySQL implementations (e.g. http://www.pgcluster.org/browser/pgcluster-1.1/src/interfaces/jdbc/org/postgresql/jdbc2/Array.java) Also please fix your dev environment to follow formatting conventions and import organization. > SQL Array type not implemented > ------------------------------ > > Key: SEQUOIA-1062 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-1062 > Project: Sequoia > Type: New Feature > Components: JDBC Driver > Environment: Affects all encironments > Reporter: Jussi Pajala > Assignee: Robert Hodges > Priority: Minor > > > SQL Array type is not implemented. The following postgresql sequence reveals > the problem: > dbc:pcluster://localhost/DB1 (user) > create table t ( name text, > pay_by_quarter integer[],schedule text[][]) > Affected rows: 0 > Query executed in 0 s 304 ms . > jdbc:pcluster://localhost/DB1 (user) > insert into t values ('Bill','{10000, > 10000, 10000, 10000}','{{"meeting", "lunch"}, {"training", "presentation"}}') > Affected rows: 1 > Query executed in 0 s 146 ms . > jdbc:pcluster://localhost/DB1 (user) > select * from t > An error occured while executing SQL query > (org.continuent.sequoia.common.exceptions.NotImplementedException: Backend > driver gave an object of an unsupported java > type:org.postgresql.jdbc3.Jdbc3Array, at colum number 1 of name > pay_by_quarter not implemented) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://forge.continuent.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
