🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: es.comp.lenguajes.java
Article #26739

CreateStatement, OutOfMemory

#26739
From: Vicente Perez
Date: Thu, 03 Dec 1998 00:00
29 lines
1482 bytes
Necesito ayuda:
Tengo el siguiente c�digo para cargar en una tabla ACCESS un fichero de
texto delimitado, pero no consigo cargarlo porque cada vez que lo ejecuto y
en un registro diferente me da el siguiente error JAVA.LANG.OUTOFMEMORY.
Estoy utilizando JBUILDER.
Podr�a alguien decirme como solucionar el problema.
Gracias

 TextDataFile textDataFile1 = new TextDataFile ();
 TableDataSet tableDataSet1 = new TableDataSet ();
public ClsImportar (Database pDatabase, String pFileName)  throws
DataSetException, Exception
  {
    textDataFile1.setFileName (pFileName);
    textDataFile1.setDelimiter ("");
    textDataFile1.setSeparator ("|");
    tableDataSet1.setDataFile (textDataFile1);
    String insert = new String ();
    Statement pstm = pDatabase.createStatement();
    tableDataSet1.open ();
    while (tableDataSet1.inBounds())
    {
            insert = "insert into tabla1 values ("..........;
            pstm.executeUpdate(insert);
            tableDataSet1.next();
    }
    tableDataSet1.close();
}
Technical Details
Message-ID: <746dfo$8ok$1@talia.mad.ibernet.es>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: SPANISH,ASCII
X-Google-Thread: 1116f3,35b8206de66f6d8e,start
X-Google-Attributes: gid1116f3,public
From: "Vicente Perez" <vicentepf@odec.es>
Subject: CreateStatement, OutOfMemory
Date: 1998/12/03
Message-ID: <746dfo$8ok$1@talia.mad.ibernet.es>
X-Deja-AN: 418277141
Organization: Telefonica Transmision de Datos
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: es.comp.lenguajes.java