Hi all,
can you help me with the below query?
Is there an other way to return query results using the jdbc interface (without using sql.resultSet)?
Thanks in advance!
Best regards,Dennis
-------- Ursprüngliche Nachricht --------Von: Dennis Fassl Datum: 25.11.17 16:55 (GMT+01:00) An: users-list@monetdb.org Betreff: MAL query "sql.resultSet"
Hi all,
I am trying to execute the MAL query below.
But the command "sql.resultSet" is terminating mclient. When using the
JDBC interface I get "SQLException: Connection to server lost! (mserver
still alive?)".
Do you have an idea why this is happening?
Thanks and regards,
Dennis
sql.init();
table_names := bat.new(nil:str);
bat.append(table_names, "t0");
bat.append(table_names, "t1");
table_attrs := bat.new(nil:str);
bat.append(table_attrs, "int_col");
bat.append(table_attrs, "str_col");
table_types := bat.new(nil:str);
bat.append(table_types, "int");
bat.append(table_types, "str");
table_lens := bat.new(nil:int);
bat.append(table_lens, 1);
bat.append(table_lens, 1);
table_scales := bat.new(nil:int);
bat.append(table_scales, 0);
bat.append(table_scales, 0);
ints := bat.new(nil:int);
bat.append(ints, 42);
bat.append(ints, 23);
strs := bat.new(nil:str);
bat.append(strs, "foo");
bat.append(strs, "bar");
sql.resultSet(table_names, table_attrs, table_types, table_lens,
table_scales, ints, strs);
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
