https://bugs.documentfoundation.org/show_bug.cgi?id=148663
--- Comment #3 from [email protected] --- Hello, I thought I would dig into this problem a bit deeper. I downloaded and installed the latest firebird with jaybird 4.0.5 driver for java 8 on windows 10. also installed flamerobin 0.9.3. I made a new table: CREATE TABLE TABLE_ARRAY ( TABLE_NAME integer NOT NULL, TABLE_NUMBER integer NOT NULL, TABLE_ROLE integer[3], CONSTRAINT INTEG_5 PRIMARY KEY (TABLE_NAME) ); Using jdk 8 on netbeans jaybird I tried to insert the array value [2,3,4]. The result was the following exception message: org.firebirdsql.jdbc.FBDriverNotCapableException: Type ARRAY not yet supported. HOWEVER.... I wrote similar code in python which successfully inserted an array. import fdb def conFB(): global con con = fdb.connect(dsn='C:/Users/jacka/OneDrive/Documents/second.fdb',user='sysdba',password='masterkey') cur = con.cursor() cur.execute("delete from TABLE_ARRAY") t=[2,3,4] ar=(t) cur.execute("insert into TABLE_ARRAY (TABLE_NAME, TABLE_NUMBER, TABLE_ROLE) VALUES(?,?,?)",(1,2,ar)) cur.execute("select * from TABLE_ARRAY") row = cur.fetchone() print(row) con.commit() cur.close() con.close() which then prints out: (1, 2, [2, 3, 4]) This is exactly what I am looking for. If firebird's python driver can handle this situation, then I think it would be definitely worth LibreOffice's efforts to also handle this, since it proves that Firebird can handle array type, even if it is limited in its ability to do so. -- You are receiving this mail because: You are the assignee for the bug.
