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

Reply via email to