aspose file tools*
The moose likes JDBC and the fly likes Jsp/Servelets Problem Inserting more than 30 rows Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Jsp/Servelets Problem Inserting more than 30 rows" Watch "Jsp/Servelets Problem Inserting more than 30 rows" New topic
Author

Jsp/Servelets Problem Inserting more than 30 rows

Ananth sunraj
Greenhorn

Joined: Sep 05, 2008
Posts: 12
Hello,
I have a serious problem while inserting values from a purchase entry jsp page.it works fine while inserting below 20rows. but when i try to insert more than 20 rows it does not react to my code.
Kindle help me regarding this ASAP.

I have listed the jboss console.

java.lang.Throwable: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:423)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnec
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at DataBase.getConnection(DataBase.java:25)
at DataBase.executeQuery3(DataBase.java:162)
at Auto_Data_Purchase_Part_Name.auto_PartnameByPartType(Auto_Data_Purchase_Part_Name.java:43)
at Auto_servlet_Part_Name_ByPartType.doGet(Auto_servlet_Part_Name_ByPartType.java:26)
at Auto_servlet_Part_Name_ByPartType.doPost(Auto_servlet_Part_Name_ByPartType.java:37)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
12:52:26,500 INFO [STDOUT] Closing Connections..org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@6ca716
12:52:26,500 INFO [STDOUT] Closing Connections..org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@1593225
12:52:26,500 INFO [STDOUT] Closing Connections..org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@1e0338f
12:52:26,500 INFO [STDOUT] Closing Connections..org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@ccfa5e
12:52:26,500 INFO [STDOUT] Closing Connections..org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@1e4acce
12:52:26,500 INFO [STDOUT] Closing Connections..org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@19e0994
12:52:26,500 INFO [STDOUT] Closing Connections..org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@15034e0
12:52:26,500 INFO [STDOUT] Closing Connections..null
12:52:26,500 INFO [STDOUT] Closing Connections..null
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Isn't this a database issue, not servlets?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61419
    
  67

Ananth sunraj wrote:Kindle help me regarding this ASAP.

You might want to rethink using phrases such as this. Please read this for more information.

And, moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Ananth sunraj
Greenhorn

Joined: Sep 05, 2008
Posts: 12
Hi,
Sry for phrases like ".....ASAP". After some time of googling i found that the problem is with the jboss connection manager.
JBoss is closing my connections. is there any solutions to solve this issue?


Dear Admin,
do i need to move this post under Database Category or any other Category?

Regards,
Ananth
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Jsp/Servelets Problem Inserting more than 30 rows