Java, Insert "Out of Memory" ou "Error:java.lang.NullPointerException"

Bonjour,

j'essaie d'insérer dans une table de 96 colonnes, à partir d'une arraylist, un fichier csv parsé.
Je parcours ici mon arraylist mais lorsque je veux faire mon INSERT j'ai ce message d'erreur :

Citation:

---

"Select Error:java.sql.SQLException: out of memory"

---

voici un ex de transaction :

Code:

---

"INSERT INTO extract VALUES ("1","0","V28C52019001","A","A-UK","VAUK-SYS","","Published","NoDS","na","S","na","0","0","ko","na","ok","ko","ko","","ok","","","","","","","","","","","","","","","","","","","","","","","","","ko","to do","0","0000-00-00","","2009-06-10","","","","","","","","","","","","","00","ok","","","","","","","","","","","","","","","","","","","","","","","10","ko","12","00","ok","","10","ko","11")"

---

Un seul enregistrement est dans la base sur 20000...

Code:

---

1 2 3 4 5 6 7

for(int i=1;i<listMyList.size();i++){ // statement.executeUpdate("INSERT INTO extract VALUES "+"("+listMyList.get(i)+")"); statement.close(); connection.close(); }

---

A noter: j'ai également essayé avec un prepareStatement et j'obtiens alors un "Error:java.lang.NullPointerException"

Merci pour votre aide

Bonsoir,

Code:

---

1 2 3 4 5 6

FOR(int i=1;i<listMyList.size();i++){ // statement.executeUpdate("INSERT INTO extract VALUES "+"("+listMyList.get(i)+")"); statement.close(); connection.close(); }

---

Si tu fais comme cela, ta connexion à la base est fermée après une insertion, d'où une seule ligne et boom lorsque i = 2.

Essayes :

Code:

---

1 2 3 4 5 6

FOR(int i=1;i<listMyList.size();i++){ // statement.executeUpdate("INSERT INTO extract VALUES "+"("+listMyList.get(i)+")"); statement.close(); } connection.close();

---

a+