<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
ClassCastException
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/hnb">Pierre Guillemot</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/715961#715961">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hello there, </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>i am new to JBoss AS, i am currently using JBoss AS6.0 final, MySQL and Netbeans 7.1.</p><p>I finally managed to configure the MySqlDS.xml and persistence.xml, i can see in the logs that the PU is read and all, the database is accessed, everything is working.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>In order to try my datasource access in created a simple servlet :</p><pre ___default_attr="java" class="jive_text_macro jive_macro_code"><p>@WebServlet(name = "Test", urlPatterns = {"/Test"})</p><p>public class Test extends HttpServlet {</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    protected void processRequest(HttpServletRequest request, HttpServletResponse response)</p><p>            throws ServletException, IOException {</p><p>        response.setContentType("text/html;charset=UTF-8");</p><p>        PrintWriter out = response.getWriter();</p><p>        try {</p><p>            /*</p><p>             * TODO output your page here. You may use following sample code.</p><p>             */</p><p>            out.println("<html>");</p><p>            out.println("<head>");</p><p>            out.println("<title>Servlet Test</title>");            </p><p>            out.println("</head>");</p><p>            out.println("<body>");</p><p>            out.println("<h1>Servlet Test at " + request.getContextPath() + "</h1>");</p><p>            out.println("</body>");</p><p>            out.println("</html>");</p><p>            </p><p>            Context context;</p><p>            try {</p><p>                context = new InitialContext();</p><p>                DataSource data = (DataSource)context.lookup("java:/MySqlDs");</p><p>            } catch (NamingException ex) {</p><p>                Logger.getLogger(Test.class.getName()).log(Level.SEVERE, null, ex);</p><p>            }</p><p>            </p><p>        } finally {            </p><p>            out.close();</p><p>        }</p><p>    }</p></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Except that in have this error :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code">23:01:32,412 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/YouFoodInc].[Test]] "Servlet.service()" pour la servlet Test a généré une exception: java.lang.ClassCastException: org.jboss.jpa.injection.InjectedEntityManagerFactory cannot be cast to javax.sql.DataSource
    at Test.processRequest(Test.java:57)    at Test.doGet(Test.java:80)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [:1.0.0.Final]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [:1.0.0.Final]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324) [:6.0.0.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:67) [:6.0.0.Final]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274) [:6.0.0.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [:6.0.0.Final]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [:6.0.0.Final]
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:181) [:6.0.0.Final]
    at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.event(CatalinaContext.java:285) [:1.1.0.Final]
    at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.invoke(CatalinaContext.java:261) [:1.1.0.Final]
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:88) [:6.0.0.Final]
    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:100) [:6.0.0.Final]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [:6.0.0.Final]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [:6.0.0.Final]
    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) [:6.0.0.Final]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [:6.0.0.Final]
    at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:53) [:6.0.0.Final]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [:6.0.0.Final]
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [:6.0.0.Final]
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [:6.0.0.Final]
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951) [:6.0.0.Final]
    at java.lang.Thread.run(Unknown Source) [:1.6.0_27]
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I added the mysql-connector-java-5.1.13-bin.jar inside the serverd/default/lib. And I have not added anything else inside the lib folder.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I already did this kind of thing using GlassFish 3.0, and i never had any issues.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>If you need any other informations, please tell me. Thank you for your attention,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Regards,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Pierre.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/715961#715961">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>