Re: MAL query "sql.resultSet"

and the usual, but most important one: which version of MonetDB are you using on what OS? Best, Stefan ----- On Nov 29, 2017, at 7:55 PM, Stefan Manegold Stefan.Manegold@cwi.nl wrote:

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 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

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |