connexion to Cloudssape db in WSAD

[cyril vidal]

HI,
What may cause a connexion to a Cloudscape db deployed in test environnment fail in WSAD 5.0?
I've created a connexion under folder:
C:\Documents and Settings\Cyril\Bureau\Mes_docs\websphere\MessagingCenter\Web Content\WEB-INF\databases\UserDB
and specified no userID nor password during creation of the connexion.
In a servlet , I've tried to get the connexion to the db by standard way:

 protected Connection getConnection() {
try {
Class.forName("com.ibm.db2j.jdbc.DB2jDriver");
Connection con = DriverManager.getConnection(
"jdbc :mrgreen: b2j:C:\\Documents and Settings\\Cyril\\Bureau\\Mes_docs\\websphere\\MessagingCenter\\Web Content\\WEB-INF\\databases\\UserDB");
return con;
} catch (SQLException se) {
System.out.println("Ouups... Une erreur s'est produite lors de la connexion");
return null;
}

catch (ClassNotFoundException e){
System.out.println("Ouups... Une erreur s'est produite lors du chargement du driver");
  return null;
}
} 

and also with pooled connexion:

private static InitialContext context = null;
private final static String datasourceName = "jdbc/dsUserDB";
private static DataSource ds;
protected static DataSource getDataSource() throws NamingException {
if (ds == null) {
InitialContext context = getInitialContext();
ds = (DataSource) context.lookup(datasourceName);
}
return ds;
}
protected static InitialContext getInitialContext() {
if (context == null) {
try {
context = new InitialContext();
} catch (NamingException ne) {
System.out.println("ERROR: Can't access JNDI namespace");
}
}
return context;
}
protected Connection getConnection() {
try {
DataSource ds = getDataSource();
if (ds != null)
return ds.getConnection();
} catch (NamingException ne) {
return null;
} catch (SQLException se) {
return null;
}
return null;
}
  

but in both case, the connexion fails..
I have no more idea to fix the problem..
I've the book of Gary Craig and Peter Jakob devoted to certification test 285.
p.346, they use a pooling connection with the following code:

 return ds.getConnection("userid","PASSWORD") 

I think it's a generic code to apply to a db that need a login"userid" and a password "password". But in my case, i've specified none of them during the creation of the connexion, so:

 getConnection() 

must be sufficient, no?
I would be very grateful for any assistance,
Regards,
Cyril.

[jason adam]

Moving this to the Websphere/IBM forum, as this forum deals with just the certification of such products, not general help on the product itself.