Multiple EM persist

[wborgo]

Hi,

I'm new to Seam and I want to execute a entityManager multiple times in a loop. I want to insert a couple of rows in database. Here's my code:

SadPerguntasEmbaralhadas spe = new SadPerguntasEmbaralhadas();
for (int i=1; i< mSession.getListPerguntasEmbaralhadas().size(); i++){
     spe.setIdMat(new Integer(mSession.getMatricula()));
     spe.setIdProva(new Integer(mSession.getIdProva()));               
     spe.setNrPergunta(mSession.getListPerguntasEmbaralhadas().get(i));
     spe.setNrPerguntaTmp(i);
                    
     entityManager.persist(spe);
     entityManager.flush();
}

The problem is: only the firt row is inserted, the others is executed as a Update to that row in database. In other words, I see in the database just the last row.

Anyone can help me? How can I make a multiple insert?

Thanks,
William

[monkeyden]

It's the same reference.  Try:

SadPerguntasEmbaralhadas spe = new SadPerguntasEmbaralhadas();

inside the loop.

[wborgo]

Thanks a lot Kyle,
It works,

I had tried this before, but there were other errors, I corrected them but I forgot to put this line inside the loop again.

Thanks again,
William