General J2EE: SQL SERVER 2005 Support in Websphere Application Server V6.0.1

  1. Hi i need to use Websphere Application Server V6.0.1 with SQL Server 2005. But as such there is no mention of Sql Server2005 Support in Documentation of Websphere Application Server V6.0.1. Can anyone provide me Links for the same. Thanks in advance.

    Threaded Messages (4)

  2. Hi, You may use Microsoft JDBC driver (downloadable from http://msdn.microsoft.com/data/ref/jdbc/) with WebSphere 6.0.1 using datasource. Install the driver & copy sqljdbc.jar to <>/lib/ext folder. I followed these steps : * WAS admin console -> Resources -> JDBC provider -> new * database type : User defined * provider type : User defined JDBC provider * implementation type : user defined * Name : Provider_SQLServer2005 * Classpath : <>/lib/ext/sqljdbc.jar * Impl class name: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource * Save. * Provider_SQLServer2005 -> data source (RHS) -> new * Data source name : dsSQLServer2005 * JNDI name : jdbc/dsSQLServer2005 * Data store helper: com.ibm.websphere.rsadapter.GenericDataStoreHelper * Save. * dsSQLServer2005 -> J2EE connector architecture auth data entries -> new * Alias : scott. User id : scott. Password : tiger [assuming that user/password exists!] * Save. * dsSQLServer2005 -> Component managed auth alias <> * Save. * Test conection. Then in code: //bla bla bla... Hashtable env = new Hashtable(); env.put(Context.INITIAL_CONTEXT_FACTORY, "com.ibm.websphere.naming.WsnInitialContextFactory"); InitialContext ctx = new InitialContext(env); DataSource ds = (DataSource) ctx.lookup("jdbc/dsSQLServer2005"); Connection con = ds.getConnection(); //bla bla bla... Related comments at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=646099&SiteID=1 HTH. - Rajib GanChaudhuri
  3. Getting error[ Go to top ]

    How do you specify the server name and the database name? I am getting a connection error when i followed the procedures that you have mentioned below. Any thoughts?
  4. Yes, how?![ Go to top ]

    How to configure server and database name in this configuration steps?
  5. I just discoreved: You have to add this custom properties for de datasource: serverName: myserver portNumber: 1433 (optional) databaseName: ICPC