Hi everyone, trying to do a simple connection pooling example. This is my code and the error message I get. I am using visual age, and running websphere
test environment in it. Also, if it means something I am using running my app with
struts as the controller.......
in init method of
servlet that gets executed while websphere it starting up, i say -->
org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource ds = new org.gjt.mm.mysql.jdbc2.optional.MysqlDataSource();
ds.setUser(dbLogin);
ds.setPassword(dbPassword);
ds.setServerName(dbServer);
ds.setDatabaseName("docserver");
ds.setUrl(dbUrl);
ds.setPortNumber(8080);
try {
Context ctx = new InitialContext();
ctx.bind("jdbc/docserverDB", ds);
} catch (NamingException nme) {
nme.printStackTrace();
}
it throws the following exception on the line ..new InitialContext();
javax.naming.ConfigurationException: URLToObjectFacility.badProtocoldocserver:1099
So I added the following lines in.
Hashtable hash = new Hashtable();
hash.put(Context.INITIAL_CONTEXT_FACTORY, "com.ibm.ejs.ns.jndi.CNInitialContextFactory");
and then changed the line saying new InitialContext(hash);
I then still got the same exception.
Can anyone please shed some light as to what I'm doing wrong.
All I want is to be able to use the connection pooling part of
jdbc 2.0 (or 3.0) using mySql driver in my webapp.
Thanks for your replies
Darryl