JBOSS 5 SQL Server nested Exception -

-

this situation. have application running on 2 servers 24/7 in client side:

application server: tomcat + jboss 5 database server: sql server 2008 r2

lately encounter error whereby every thursday morning 6am jboss hit error:

com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error @ com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:1368) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:1355) @ com.microsoft.sqlserver.jdbc.tdschannel.write(iobuffer.java:1548) @ com.microsoft.sqlserver.jdbc.tdswriter.flush(iobuffer.java:2368) @ com.microsoft.sqlserver.jdbc.tdswriter.writepacket(iobuffer.java:2270) @ com.microsoft.sqlserver.jdbc.tdswriter.endmessage(iobuffer.java:1877) @ com.microsoft.sqlserver.jdbc.tdscommand.startresponse(iobuffer.java:4403) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement.doexecutepreparedstatement(sqlserverpreparedstatement.java:386) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement$prepstmtexeccmd.doexecute(sqlserverpreparedstatement.java:338) @ com.microsoft.sqlserver.jdbc.tdscommand.execute(iobuffer.java:4026) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.executecommand(sqlserverconnection.java:1416) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executecommand(sqlserverstatement.java:185) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executestatement(sqlserverstatement.java:160) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement.executeupdate(sqlserverpreparedstatement.java:306) @ org.jboss.resource.adapter.jdbc.wrappedpreparedstatement.executeupdate(wrappedpreparedstatement.java:365) @ sun.reflect.generatedmethodaccessor343.invoke(unknown source) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.jboss.invocation.invocation.performcall(invocation.java:386) @ org.jboss.ejb.statelesssessioncontainer$containerinterceptor.invoke(statelesssessioncontainer.java:228) @ org.jboss.resource.connectionmanager.cachedconnectioninterceptor.invoke(cachedconnectioninterceptor.java:156) @ org.jboss.ejb.plugins.statelesssessioninstanceinterceptor.invoke(statelesssessioninstanceinterceptor.java:173) @ org.jboss.ejb.plugins.callvalidationinterceptor.invoke(callvalidationinterceptor.java:63) @ org.jboss.ejb.plugins.abstracttxinterceptor.invokenext(abstracttxinterceptor.java:121) @ org.jboss.ejb.plugins.txinterceptorcmt.runwithtransactions(txinterceptorcmt.java:350) @ org.jboss.ejb.plugins.txinterceptorcmt.invoke(txinterceptorcmt.java:181) @ org.jboss.ejb.plugins.securityinterceptor.process(securityinterceptor.java:228) @ org.jboss.ejb.plugins.securityinterceptor.invoke(securityinterceptor.java:211) @ org.jboss.ejb.plugins.security.presecurityinterceptor.process(presecurityinterceptor.java:97) @ org.jboss.ejb.plugins.security.presecurityinterceptor.invoke(presecurityinterceptor.java:81) @ org.jboss.ejb.plugins.loginterceptor.invoke(loginterceptor.java:205) @ org.jboss.ejb.plugins.proxyfactoryfinderinterceptor.invoke(proxyfactoryfinderinterceptor.java:138) @ org.jboss.ejb.sessioncontainer.internalinvoke(sessioncontainer.java:650) @ org.jboss.ejb.container.invoke(container.java:1029) @ sun.reflect.generatedmethodaccessor323.invoke(unknown source) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.jboss.mx.interceptor.reflecteddispatcher.invoke(reflecteddispatcher.java:157) @ org.jboss.mx.server.invocation.dispatch(invocation.java:96) @ org.jboss.mx.server.invocation.invoke(invocation.java:88) @ org.jboss.mx.server.abstractmbeaninvoker.invoke(abstractmbeaninvoker.java:264) @ org.jboss.mx.server.mbeanserverimpl.invoke(mbeanserverimpl.java:668) @ org.jboss.invocation.unified.server.unifiedinvoker.invoke(unifiedinvoker.java:232) @ org.jboss.remoting.serverinvoker.invoke(serverinvoker.java:891) @ org.jboss.remoting.transport.socket.serverthread.completeinvocation(serverthread.java:744) @ org.jboss.remoting.transport.socket.serverthread.processinvocation(serverthread.java:697) @ org.jboss.remoting.transport.socket.serverthread.dorun(serverthread.java:551) @ org.jboss.remoting.transport.socket.serverthread.run(serverthread.java:232)

and app service give error: 

javax.ejb.ejbexception: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error; nested exception is: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error; nested exception is: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error: connection reset peer: socket write error

my client claimed there no activity being done on db nor apps server on thursday 6am, hence had no idea trigger error..it happens every thursday 6am. me appreciated!

what's network topology? there firewall between front end , database server? if so, firewall recycling connections.


Comments

Post a Comment

Popular posts from this blog

c# - SelectList with Dictionary, add values to the Dictionary after it's assigned to SelectList -

-
i have following code - dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value") further down in program, want add values mydict . possible? if yes, how? want - myselectlist.mydict.add("keyc", "valuec"); if you're wanting add items mydict, possible, , changes reflected in of myselectlist 's enumerations long changes made before enumeration (e.g. using .tolist() ) generated. as worked example: dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value...
Read more

how can i manage url using .htaccess in php? -

-
i want manage url of website right showing me www.computermall.co.in/product_details.php?prdid=34 but want www.computermall.co.in/product_details/34 how can it? i have tried this options +followsymlinks -multiviews rewriteengine on rewritebase /computermall # uri-path directly the_request variable rewritecond %{the_request} ^(get|head)\s/(.*)\.php [nc] # strip extension , redirect permanently rewriterule .* /%2 [r=301,l,nc] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_uri} !\.php [nc] # map internally original resource rewriterule ^(.*)$ $1.php [l,qsa] try this: rewriteengine on rewriterule ^product_details/prdid/([^/]*)$ /product_details?prdid=$1 [l] edit: removed leading slash
Read more

ios - I get the error Property '...' not found on object of type '...' -

-
appdelegate.h #import <uikit/uikit.h> @interface appdelegate : uiresponder <uiapplicationdelegate> @property (strong, nonatomic) uiwindow *window; @end appdelegate.m #import "appdelegate.h" #import "firstviewcontroller.h" #import "secondviewcontroller.h" @implementation appdelegate - (bool)application:(uiapplication *)application didfinishlaunchingwithoptions: goes on normal app.......... @end firstviewcontroller.h #import <uikit/uikit.h> @interface firstviewcontroller : uiviewcontroller @property (strong, nonatomic) iboutlet uiimageview *bground; - (ibaction)settingspressed:(id)sender; - (ibaction)startpressed:(id)sender; @end @class secondviewcontroller; @interface secondviewcontroller : uiviewcontroller @property(strong,nonatomic)secondviewcontroller *secondviewcontroller; @end firstviewcontroller.m #import "firstviewcontroller.h" @interface firstviewcontroller () @end @implement...
Read more