Bonjour,
je fais une boucle d'insertion dans une base oracle 10g.
Je veux savoir s'il y a une limite sur le nombre d'appel de "prepareStatement".
Car quand j'arrive à 94000 insertion j'ai :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 java.lang.OutOfMemoryError: Java heap space at java.lang.String.toUpperCase(String.java:2376) at java.lang.String.toUpperCase(String.java:2448) at oracle.jdbc.driver.OracleSql.getReturnParameterCount(OracleSql.java:1744) at oracle.jdbc.driver.OraclePreparedStatement.initializeBinds(OraclePreparedStatement.java:1354) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1222) at oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28) at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68) at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140) at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042) at com.edeal.frontline.FlConnection.prepareStatement(FlConnection.java:344) at com.edeal.frontline.controller.actions.custom.TransfertStock.execute(TransfertStock.java:167) at com.edeal.frontline.controller.ControllerServlet.processAction(ControllerServlet.java:263) at com.edeal.frontline.controller.ControllerServlet.perform(ControllerServlet.java:196) at com.edeal.frontline.controller.ControllerServlet.doGet(ControllerServlet.java:108) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595)
Partager