JNDI Resource Bindings

[Ananth Prakash]

I am using WSAD 5.1.0 to develop my appln. When i tried to explore the JNDI through the servlet which connects to a DB2 database and displays records from a table, I'm getting the expected result. But in the server's console window, I am seeing the following error message:

"Resource reference jdbc/Db2TDataSource could not be located, so default values of the following are used: [Resource-ref settings]
Resource reference jdbc/sbtdatasource could not be located, so default values of the
following are used: [Resource-ref settings]

res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined),"

In my web.xml file, I have given a reference name to the JNDI name 'jdbc/DB2TDataSource' and I'm using the reference name in the Initial context lookup. The code snippet goes like this.

InitialContext ctx = null;
ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/jdbc/DB2TDataSource");

I had read in the earlier postings that I need to use a Resource reference value in the Initial Context lookup for this error to stop. But I still get the above error in my console window.

Need help in this regard.

Regards,
Ananth

[Alana Sparx]

I've defined a datasource, giving a jndi binding of 'jdbc/ds1'.

This is the name I use when attempting to connect to the datasource

Connection conn    = null;
InitialContext ctx = null;
DataSource source  = null;
String JNDI_LOOKUP = "jdbc/ds1";
Hashtable params  = new Hashtable();
 
params.put(Context.INITIAL_CONTEXT_FACTORY, CONTEXT_FACTORY);
params.put(Context.PROVIDER_URL, CONTEXT_PROVIDER_URL);
        
//ensure password is in appropriate format
PASS = (PASS==null || "".equals(PASS)) ? null : PASS;
        
try
{
  ctx    = new InitialContext(params);
  source = (DataSource)ctx.lookup(JNDI_LOOKUP);
  conn   = source.getConnection(USER, PASS);
}

In your case try altering the following line from

ds = (DataSource) ctx.lookup("java:comp/env/jdbc/DB2TDataSource");

to

ds = (DataSource) ctx.lookup("jdbc/DB2TDataSource");

Good luck.

[Babji Reddy]

Usage of JNDI names is deprecated in Webshpere. You have to use reference bindings.
Define the resource references to the Database JNDI in web/ejb deployment descriptors, and use context.lookup("java:comp/env/<YOUR REF JNDI>").

This will suppress the warning (its not an error) in the console