First question is what is happening?
Does the mserver5 keep running? Does it crash? are there any messages on the mserver5 console (or in the merovingian.log in case you use merovingian (aka. monetdbd))?
Second question is, why are you using MAL to create a SQL result set and send this via JDBC? What are you trying to do that cannot be done in SQL?
Thanks!
Stefan
----- On Nov 29, 2017, at 4:20 PM, dennis.fassl dennis.fassl@uni-konstanz.de wrote:
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
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list