Received: from gannet.scg.man.ac.uk (gannet.scg.man.ac.uk [130.88.94.110]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA41268 for ; Mon, 24 May 1999 11:14:39 -0400 (EDT) (envelope-from crispin@cs.man.ac.uk) Received: from pgr2.sbc.man.ac.uk ([130.88.235.9] helo=cs.man.ac.uk) by gannet.scg.man.ac.uk with esmtp (Exim 1.92 #2) for pgsql-general@postgresql.org id 10lwQy-0002YT-00; Mon, 24 May 1999 16:14:32 +0100 Sender: crispin Message-ID: <37495D80.26F5DF90@cs.man.ac.uk> Date: Mon, 24 May 1999 15:09:04 +0100 From: Crispin Miller Reply-To: crispin@cs.man.ac.uk Organization: The University of Manchester X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.2.3 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: JDBC and insert - stack overflow Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am afraid I am a newbie. Forgive me if this is a silly question- I'm trying to create a large database using JDBC to load the tables by calling executeUpdate with the statement "SQL INSERT INTO" + tableName + " VALUES (" etc... After 14 and a half thousand rows the java virtual machine crashes with: Exception in thread "main" java.lang.StackOverflowError at java.lang.Class.newInstance0(Native Method) at java.lang.Class.newInstance(Compiled Code) at sun.io.Converters.newConverter(Compiled Code) at sun.io.Converters.newDefaultConverter(Compiled Code) at sun.io.ByteToCharConverter.getDefault(Compiled Code) at java.lang.String.(Compiled Code) at postgresql.PG_Stream.ReceiveString(Compiled Code) at postgresql.Connection.ExecSQL(Compiled Code) at postgresql.Statement.execute(Compiled Code) at postgresql.Statement.executeUpdate(Compiled Code) My first question is: Am I doing things in a really stupid way? If not, how do I fix the problem - I have tried increasing the default stack and memory size for the JVM... Crispin