Re: Insertion problem for large number of columns

To start with: - Which version (release) of MonetDB are you using? - Are you using a 32- or 64-bit build of MonetDB? - Did you install the 32-bit or 64-bit or both JDBC drivers? - How does the crash show itself? + Are there any error messages on the server console? + Are there any errors returned from the server via you JDBC connection? + Or does the server process simply stop without any information? - What does you table schema (column types) look like? - Does the server crash with any data/tuple you insert? - What does a single sample tuple look like? - How exactly does your JDBC/Java code look like that performs the insert? - Did you try with fewer than 25 columns, and does that work? (I would not expect that the the number of columns makes any difference, but your email subject suggests so; hence, please elaborate on that!) Stefan ----- Original Message -----

Here some information: monetDB: MonetDB5 OS: Windows 7 64 bit, RAM 4GB Jdbc : monetdb-jdbc-2.4

Can you please tell me specifically what information do you need to give me advice.

Thanks Shajon

-----Original Message----- From: users-list-bounces+alam=finengine.com@monetdb.org [mailto:users-list-bounces+alam=finengine.com@monetdb.org] On Behalf Of Lefteris Sent: Monday, March 11, 2013 8:44 PM To: Communication channel for MonetDB users Subject: Re: Insertion problem for large number of columns

You are giving too little of information for us to even make a general suggestion.

On Mon, Mar 11, 2013 at 3:14 PM, Shajon wrote:

...

Dear Monet Team,

Today I was trying to insert data in MonetDB using " insert into ." command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values.

Thanks

Shajon

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.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) |