Hello experts,
I am using IBM rational eclipse, sql2005 and websphere 6.0 using dsn.
i have configured websphere for accessing sql2005 and the problem starts now, I configured jdbc_registry.properties file as follow..
when I start my workspace it gives me following exception
Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL 'jdbc: sqlserver://dbserver:1433;DatabaseName=ons5dev_2005;user=abc;password=12345'
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:261)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.onproject.security.registry.JdbcRegistry.getConnection(JdbcRegistry.java:188)
at com.onproject.security.registry.JdbcRegistry.checkPassword(JdbcRegistry.java:225)
at com.ibm.ws.security.registry.UserRegistryImpl.checkPassword(UserRegistryImpl.java:296)
at com.ibm.ws.security.server.lm.swamLoginModule.login(swamLoginModule.java:429)
at com.ibm.ws.security.common.auth.module.proxy.WSLoginModuleProxy.login(WSLoginModuleProxy.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke...... I have sqljdbc2005.jar in my .classpath file as seen in eclipse for my project. i think this issue is related to classpath but dont know how to fix it. your
word of advice would be a great help to me.
I have tested driver using a jdbc demo application and found it working.
[ March 26, 2008: Message edited by: Nirav San ]