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 :
"Select Error:java.sql.SQLException: out of memory"
voici un ex de transaction :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
"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 : Sélectionner tout - Visualiser dans une fenêtre à part
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