Apache Tomcat/6.0.28 - Error report

HTTP Status 500 -


type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
        (select exchange_code,last_trade_price,last_trade_price-close_price diff,round(((last_trade_price-close_price)/last_trade_price)*100,2) perc
        from symbol_ltp where exchange_code in ('Sensex','NSE Index')
        order by exchange_code desc limit 2)
        union
        (select Ticker,Current,Current-Close diff,round(((Current-Close)/Current)*100,2) from commodity_ltp
        where 
        Ticker IN  ('Gold','Silver')
        and DateOfExpiry is not null
        and year(DateOfExpiry)>=year(CONVERT_TZ(now(),@@global.time_zone,'+5:30'))
        and date(CONVERT_TZ(now(),@@global.time_zone,'+5:30'))<=DateOfExpiry
        group by Ticker
        order by DateOfExpiry);
    : Communications link failure

Last packet sent to the server was 0 ms ago.
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
        (select exchange_code,last_trade_price,last_trade_price-close_price diff,round(((last_trade_price-close_price)/last_trade_price)*100,2) perc
        from symbol_ltp where exchange_code in ('Sensex','NSE Index')
        order by exchange_code desc limit 2)
        union
        (select Ticker,Current,Current-Close diff,round(((Current-Close)/Current)*100,2) from commodity_ltp
        where 
        Ticker IN  ('Gold','Silver')
        and DateOfExpiry is not null
        and year(DateOfExpiry)>=year(CONVERT_TZ(now(),@@global.time_zone,'+5:30'))
        and date(CONVERT_TZ(now(),@@global.time_zone,'+5:30'))<=DateOfExpiry
        group by Ticker
        order by DateOfExpiry);
    : Communications link failure

Last packet sent to the server was 0 ms ago.
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	org.apache.jsp.header_jsp._jspService(header_jsp.java:2570)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)

root cause

com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1887)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:215)
	org.apache.jsp.header_jsp._jspx_meth_sql_005fquery_005f0(header_jsp.java:3650)
	org.apache.jsp.header_jsp._jspService(header_jsp.java:848)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)

root cause

java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
	com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2431)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1887)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:215)
	org.apache.jsp.header_jsp._jspx_meth_sql_005fquery_005f0(header_jsp.java:3650)
	org.apache.jsp.header_jsp._jspService(header_jsp.java:848)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.28 logs.


Apache Tomcat/6.0.28

Markets near resistance zone

By
stock market

Last  week,  Nifty  rose  1.40%,  resulting  in to third consecutive weekly again.  Nifty Midcap and Smallcap indices underperformed during the current week,  Where  Nifty  Midcap  Index rose by 0.8% while Nifty small Cap Index remained flat. From the bottom of 9951, Nifty has recovered more than 500 points, to close at 10481 level today. During the week, Nifty has also surpassed the big hurdle of its 50 DMA and 100 DMA, placed at 10400 and 10447 respectively.

Long  build  is  seen in the Nifty and Bank Nifty Futures’ where Open Interest in the Nifty and Bank Nifty futures rising by 17% and 32% with Nifty and Bank Nifty rising by 1.4% and 1.3% respectively. First sign of short covering coupled with minor long build up is visible from  FIIs’  side, where they net bought worth Rs 1824 Cr in Index Futures’ till Thursday with open interest going up by 2183 contracts

U.S. stocks closed with solid gains as investors looked past the latest headlines and tweets coming from the White House and turned their focus to earnings season.

Earnings season is kicking off with Infosys announcing its results on Friday, With Salil Parekh completing his first quarter, his strategy and vision to drive the company forward will be keenly watched, when Infosys announces its results. Markets will also react to IMD’s forecast of monsoons for the year.

On economic data front, India’s Wholesale Inflation for the March month will be announced on Monday and it is estimated to inch up at 2.5% compared to 2.48% in the previous month. On Tuesday morning China will release 1st estimate of Q1 growth figures and broadly economist are predicting that it will show the same rate of growth of 6.8% YoY.

Markets have come near the resistance zone of 10500-10550 zone.  Quarterly results from heavyweights and monsoon forecast from IMD department will determine where markets move in the short run

 VK Sharma, Head Private Client Group & Capital Market Strategy at HDFC Securities

Comments (0)

No comments yet.


Leave a comment

(required)

No trackbacks yet.

??????