RE: Insertion problem for large number of columns

Dear Stefan, Thank you for your help. Bellow I have provided my answer s Which version (release) of MonetDB are you using? MonetDB5 MonetDB5-SQL-Installer-x86_64-20120917 MonetDB SQL server and client, 64 bit, 32 bit oid MonetDB5-Geom-Module-x86_64-20121010 MonetDB SQL Geometry Module, 64 bit, 32 bit oid Are you using a 32- or 64-bit build of MonetDB? 64 bit Did you install the 32-bit or 64-bit or both JDBC drivers? 64 bit. i just used ( monetdb-jdbc-2.8.jar) MonetDB JDBC v4 driver for the Java 2 Platform 1.6 and 1.7. How does the crash show itself? the server process simply stop without any information What does you table schema (column types) look like? the table has columns with data type varchar , int , double, time Does the server crash with any data/tuple you insert? When I try to insert data using my java app/moned DB Sql client/ DBvisualizer it crash What does a single sample tuple look like? insert into .. (column list)values(..) How exactly does your JDBC/Java code look like that perform the insert? it just connects to database and inserts data using "insert into" command as batch. I have also disabled Auto commit. i did not use PrepareStatement strategy. Did you try with fewer than 25 columns, and does that work? Yes. I have other two tables where i load ~18 million records each day using copy command and using java app through this JDBC Shajon -----Original Message----- From: users-list-bounces+alam=finengine.com@monetdb.org [mailto:users-list-bounces+alam=finengine.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Monday, March 11, 2013 9:16 PM To: Communication channel for MonetDB users Subject: 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) | _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list