I can sucessfully access the DataStore using JNDI, but cannot access it when I am using @RESOURCE annotation. I do not use JPA. I though that I do not need JPA for @RESOURCE annotation Here it is the code: * private* @Resource (mappedName="jdbc/Cobra") DataSource ds; *public* DataSource getDefaultDs() *throws* Throwable{ *return* ds; }
here the code with JNDI that is working: *public* DataSource getDefaultDs() *throws* Throwable{ Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:comp/*env*"); DataSource *ds* = (DataSource)envContext.lookup("*jdbc*/*Cobra*"); *return* ds; } Here the definition is the web.xml <resource-ref> <description>*Cobra* DataSource</description> <res-ref-name>*jdbc*/*Cobra*</res-ref-name> <res-type>*javax*.*sql*.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> here the definition in my context: <Resource name=*"jdbc/Cobra"* auth=*"Container"* type=* "javax.sql.DataSource" *maxActive=*"100"* maxIdle=*"30"* maxWait=*"10000" *username=*"yyyyyy"* password=*"xxxxxx"* driverClassName=* "com.microsoft.sqlserver.jdbc.SQLServerDriver" *url=*"jdbc:sqlserver://myserver:1645;databaseName=Cobra"*/> environment: TOMCAT 5.5.25; Windows XP, JDK 1.5.0_17. Currently I am trying to use Tomcat from IBM RAD I would appreciate if you would help me with thanks