Jboss 5.0 not able to connect to databse

1)DBTest.jsp

<%@page import="java.util.*,java.sql.*,javax.naming.*"%>

<%response.setHeader("Cache-Control","no-store");
response.setHeader("Cache-Control","no-cache");
response.setHeader("Pragma","no-cache");
response.setHeader("Expires","0");%>

<html>
<head>
<title>Review Report </title>
</head>
<body>
<table >
		<tr><td  ><font color="#1D339A" face="Verdana" size="2"><b>DB TEST</b></font></td></tr>
		<tr><td > </td></tr>
<%

javax.sql.DataSource ds=null;
Connection con = null;
ResultSet rs = null;
Statement statement = null;
try{//3
	Context ctx=new InitialContext();
    ds=(javax.sql.DataSource)ctx.lookup("java:comp/DBConnect");
    con = ds.getConnection();
	statement = con.createStatement();
	rs = statement.executeQuery("select user_id,status from t_userdetails where user_id='shivaprasadp'");
	
	%>
<table  border="1" >
    <%
    while (rs.next()) {
    %>
    <tr>
        <td><%=rs.getString(1)%></td>
    </tr>
    <%   }    %>
    <%
    // close all the connections.
    rs.close();
    statement.close();
    con.close();
} catch (Exception ex) {
    %>
    </font>
    <font size="+3" color="red"></b>
        <%
                out.println("Unable to connect to database.");
				 ex.printStackTrace();
            }
        %>
    </table><tr><td ><HR></td></tr>
</table>
</body>
</html>

error message

14:21:36,715 ERROR [STDERR] java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to javax.sql.Data
Source
14:21:36,725 ERROR [STDERR]     at org.apache.jsp.tools.DBTest_jsp._jspService(DBTest_jsp.java:98)
14:21:36,725 ERROR [STDERR]     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
14:21:36,725 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
14:21:36,725 ERROR [STDERR]     at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
14:21:36,725 ERROR [STDERR]     at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
14:21:36,725 ERROR [STDERR]     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
14:21:36,725 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
14:21:36,725 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
14:21:36,725 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
14:21:36,725 ERROR [STDERR]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
14:21:36,725 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
14:21:36,725 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
14:21:36,725 ERROR [STDERR]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
14:21:36,725 ERROR [STDERR]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
14:21:36,725 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
14:21:36,725 ERROR [STDERR]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
14:21:36,725 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve
.java:126)
14:21:36,735 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.
java:70)
14:21:36,735 ERROR [STDERR]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
14:21:36,735 ERROR [STDERR]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
14:21:36,735 ERROR [STDERR]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
14:21:36,735 ERROR [STDERR]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
14:21:36,735 ERROR [STDERR]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
14:21:36,735 ERROR [STDERR]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
14:21:36,735 ERROR [STDERR]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601)
14:21:36,735 ERROR [STDERR]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
14:21:36,735 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:619)

And I am using:
classes12.jar file as oracle driver(placed in jboss-5.0.0\server\default\lib folder)
Jboss 5.0 AS
oracle8i as Database (soon will be changing to 10g)
JDK 1.6

Could any one tell me why am I getting this error, when the same code works fine in jboss 4 AS.

thanks and regards

ohh,
the problem is resolved after checking

www.jboss.org

and now it is displaying the user ID, but still I am not able to login to my application.

When i gave the correct login id and password (which is working in jboss 4.0), I am getting the following error

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /InvalidLoginError.jsp at line 59

56: </head>
57: <body>
58: <font class=msg><%Exception  e=(Exception)request.getAttribute("Error");
59:          int index=e.getMessage().lastIndexOf(":")+1;
60: 		 String message=e.getMessage().substring(index);%>
61:    <%=message%>
62: <%String contextpath=request.getContextPath();%>

Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:498)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1033)
	org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:436)
	org.apache.struts.action.RequestProcessor.processActionForward(RequestProcessor.java:401)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:523)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

root cause

java.lang.NullPointerException
	org.apache.jsp.InvalidLoginError_jsp._jspService(InvalidLoginError_jsp.java:133)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1033)
	org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:436)
	org.apache.struts.action.RequestProcessor.processActionForward(RequestProcessor.java:401)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:523)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

Looks like there is no request attribute named "Error". Fix your code to either supply such an attribute, or fix the JSP code to handle the possibility of no "Error" attribute. (Or better yet, get rid of the server-side script in your JSP and make use of tag libraries and the expression language instead.)

Ouch, I sure hope you don't normally put Java code into your .jsp files, and that this is only a test. But even with a test, I would never ever put Java code into a jsp page.

Mark

hey guys thanks for your help....

My friend has found out the solution for this problem, there was a jar file placed in multiple places.
So that guy was creating all the trouble to my application from running.

Jboss 5 is very strict with duplicate jar files and also the parsing.....

Currently all the features of my application are running ......

but i have some other doubts i ll come up with them in my next post.......