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 :
voici un ex de transaction :"Select Error:java.sql.SQLException: out of memory"
Un seul enregistrement est dans la base sur 20000...
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")"
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
Partager