Discussions

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

Bookmark and Share Get thread feed

  1. SQL SERVER 2005 Support in Websphere Application Server V6.0.1 (4 messages)

    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.
    Reply to this

    Threaded Messages (4)

  2. Re: SQL SERVER 2005 Support in Websphere Application Server V6.0.1[ Go to top ]

    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 <<Node01/scott>> * 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
    Reply to this Reply to original

  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?
    Reply to this Reply to original

  4. Yes, how?![ Go to top ]

    How to configure server and database name in this configuration steps?
    Reply to this Reply to original

  5. Do this:[ Go to top ]

    I just discoreved: You have to add this custom properties for de datasource: serverName: myserver portNumber: 1433 (optional) databaseName: ICPC
    Reply to this Reply to original