users@glassfish.java.net

Re: Glassfish, MySQL and _at_Resource

From: <glassfish_at_javadesktop.org>
Date: Tue, 10 Jun 2008 00:46:17 PDT

Hello Shalini,

Thank you for trying.
Doing the following:

[i]public class JDBCSelectServlet extends javax.servlet.http.HttpServlet {
         @Resource(mappedName="jdbc/__MysqlPool") // mappedName="jdbc/__MysqlPool"
         private javax.sql.DataSource dataSource;
[/i]

does not inject the datasource .... it is null.

Do I have to do some configuration in the web.xml-file ?
my xml is like this:
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
        xmlns="http://java.sun.com/xml/ns/j2ee"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
        <display-name>Chapter4B</display-name>

        <welcome-file-list>
                <welcome-file>index.jsp</welcome-file>
        </welcome-file-list>

        <servlet>
                <servlet-name>JDBCServlet</servlet-name>
                <servlet-class>is.in.JDBCSelectServlet</servlet-class>
        </servlet>
        <servlet-mapping>
                <servlet-name>JDBCServlet</servlet-name>
                <url-pattern>/jdbctest</url-pattern>
        </servlet-mapping>
</web-app>

regards, i
ps.
I am running the 'GlassFish V2 Update Release 2 (UR2)'
java version: java version "1.6.0_03"
java_home: C:\Program Files\Java\jdk1.6.0_03
running easyeclipse server java.
ds
[Message sent by forum member 'invergilius' (invergilius)]

http://forums.java.net/jive/thread.jspa?messageID=279341