Hello, I ended up get my records in a List through before recording them in my other table. My data is not fixed, a repro program does not I would argue, I think.
Thanks, Isabelle -----Message d'origine----- De : Dag H. Wanvik [mailto:[email protected]] Envoyé : mardi 21 février 2012 03:43 À : Derby Discussion Objet : Re: Operation 'next' not permitted "Isabelle DASTUGUE" <[email protected]> writes: > Hello, > > I am facing a problem with the commit: « java.sql.SQLException: > ResultSet not open. Operation 'next' not permitted. Verify that > autocommit is OFF. » > I found this documentation : > https://issues.apache.org/jira/browse/DERBY-4095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#issue-tabs This issue (4095) involves triggers. Do you use that in your application? Perhaps you can make a stand-alone repro program? Thanks, Dag > So I tried to update Derby in Eclipse. > Here is the information sent by Derby (Sysinfo): > --------- Derby Information -------- > JRE - JDBC: Java SE 6 - JDBC 4.0 > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derby.jar] 10.8.1.2 > - (1095077) > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derbytools.jar] > 10.8.1.2 - (1095077) > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derbynet.jar] > 10.8.1.2 - (1095077) > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derbyclient.jar] > 10.8.1.2 - (1095077) > > But now I've always the error, what can I do ? > > Thank you in advance > > Isabelle > > > //---------------------------------------------------------------------------------------------------------- > > Bonjour, > > Je suis confrontée à un problème avec le commit : « > java.sql.SQLException: ResultSet not open. Operation 'next' not > permitted. Verify that autocommit is OFF. » > J'ai trouvé cette documentation : > https://issues.apache.org/jira/browse/DERBY-4095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#issue-tabs > J'ai donc tenté de mettre à jour Derby dans Eclipse. > Voici les information Derby envoyées par Sysinfo : > > --------- Derby Information -------- > JRE - JDBC: Java SE 6 - JDBC 4.0 > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derby.jar] 10.8.1.2 > - (1095077) > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derbytools.jar] > 10.8.1.2 - (1095077) > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derbynet.jar] > 10.8.1.2 - (1095077) > [C:\Program > Files\eclipse\plugins\org.apache.derby.core_10.8.1\derbyclient.jar] > 10.8.1.2 - (1095077) > > Mais actuellement j'ai toujours l'erreur, que puis je faire de plus ? > > Merci par avance > > Isabelle
