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 <dennis.fassl@uni-konstanz.de>
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