anil katta

Greenhorn
+ Follow
since Jun 18, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by anil katta

There is already a paging functionality included for the same. but still it comes.. could you please guide me for other alternatives

I tried with
<Context path="/SFE" reloadable="true">
<Resource name="jdbc/salesForce" auth="Container" type="javax.sql.DataSource"
connectionProperties="databasename=salesforcerpt_dev"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
maxActive="10"
maxIdle="-1"
maxWait="1000"
initialSize="10"
password="salesforce"
removeAbandoned="true"
url="jdbc:sqlserver://myauvwv00100430:1433"
username="salesforceuser"
validationQuery="select 1"
/>
</Context>

keeping maxIdle to -1 and inserted a initialiSize to 10.. it is not giving any exception so called Java memory heap but some times socket connection is not getting

java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at org.apache.jk.common.ChannelSocket.send(ChannelSocket.java:531)
at org.apache.jk.common.JkInputStream.endMessage(JkInputStream.java:121)
at org.apache.jk.core.MsgContext.action(MsgContext.java:304)
at org.apache.coyote.Response.action(Response.java:183)
at org.apache.coyote.Response.finish(Response.java:305)
at org.apache.catalina.connector.OutputBuffer.close(OutputBuffer.java:276)
at org.apache.catalina.connector.CoyoteOutputStream.close(CoyoteOutputStream.java:104)
at org.apache.myfaces.renderkit.html.util.MyFacesResourceLoader.writeResource(MyFacesResourceLoader.java:244)
at org.apache.myfaces.renderkit.html.util.MyFacesResourceLoader.serveResource(MyFacesResourceLoader.java:217)
at org.apache.myfaces.renderkit.html.util.DefaultAddResource.serveResource(DefaultAddResource.java:606)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:128)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:209)
at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:347)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Unknown Source)


Could you please guide me Paul??
yes I'm returning Huge resultset..
in this what i need to do could you please guide me...
there is lot of heap size rite.. please let me know how to increase a web application heap size
java.sql.SQLException: The system is out of memory. Use server side cursors for large result sets:Java heap space. Result set size:42,174,756. JVM total memory size:1,069,678,592.
I am using dbutils to connect to data base using following resource in context.xml

<Context path="/SFE" reloadable="true">
<Resource name="jdbc/salesForce" auth="Container" type="javax.sql.DataSource"
connectionProperties="databasename=salesforcerpt_dev"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
maxActive="10"
maxIdle="-1"
maxWait="5000"
initialSize="10"
password="salesforce"
removeAbandoned="true"
url="jdbc:sqlserver://myauvwv00100430:1433"
username="salesforceuser"
validationQuery="select 1"
/>
</Context>


now my application is throwing java.sql.SQLException: The system is out of memory. Use server side cursors for large result sets:Java heap space. Result set size:42,174,756. JVM total memory size:1,069,678,592.

please could you help me out