SQL Array type not implemented
------------------------------

         Key: SEQUOIA-1062
         URL: https://forge.continuent.org/jira/browse/SEQUOIA-1062
     Project: Sequoia
        Type: Bug

  Components: JDBC Driver  
 Environment: Affects all encironments
    Reporter: Jussi Pajala
 Assigned to: Jussi Pajala 
    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

Reply via email to