General J2EE General J2EE General J2EE

Messages: 4 Messages: 4 Messages: 4

Printer friendly Printer friendly Printer friendly

Post reply Post reply Post reply

XML XML XML

SQL SERVER 2005 Support in Websphere Application Server V6.0.1

Posted by: yogvinder singh on August 18, 2006 DIGG

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 replies

·	SQL SERVER 2005 Support in Websphere Application Server V6.0.1 by yogvinder singh on Fri Aug 18 08:16:17 EDT 2006

·	Re: SQL SERVER 2005 Support in Websphere Application Server V6.0.1 by Rajib GC on Tue Aug 29 17:45:58 EDT 2006

·	Getting error by Mohamed Safir on Mon Mar 05 22:23:09 EST 2007

·	Yes, how?! by Luiz Gustavo Stábile de Souza on Wed Aug 19 15:18:24 EDT 2009

·	Do this: by Luiz Gustavo Stábile de Souza on Wed Aug 19 15:32:02 EDT 2009

Message #216849

Post reply Post reply Post reply

Go to top Go to top Go to top

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

Posted by: Rajib GC on August 29, 2006 in response to Message #216028

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 <<WAS_home_dir>>/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 : <<WAS_home_dir>>/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

Message #228630

Post reply Post reply Post reply

Go to top Go to top Go to top

Getting error

Posted by: Mohamed Safir on March 05, 2007 in response to Message #216849

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?

Message #319103

Post reply Post reply Post reply

Go to top Go to top Go to top

Yes, how?!

Posted by: Luiz Gustavo Stábile de Souza on August 19, 2009 in response to Message #228630

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

Message #319105

Post reply Post reply Post reply

Go to top Go to top Go to top

Do this:

Posted by: Luiz Gustavo Stábile de Souza on August 19, 2009 in response to Message #319103

I just discoreved:

You have to add this custom properties for de datasource:

serverName: myserver
portNumber: 1433 (optional)
databaseName: ICPC

Top posters of the weekTop posters of the weekTop posters of the week

This list contains the members who have made the most posts in all forums over the last 7 days:

Hot threads Hot threads Hot threads

More hot threads More hot threads More hot threads

Object pooling is now a serious performance loss

Brian Goetz continues to lift the lid and peak into the inner workings of Java in Java Urban Performance Legends. In this article he exposes the fallacy behind some of the more common performance myths found in the annals of the JVM.
(93 comments, last posted February 06, 2009)

Beyond Java

Bruce Tate, author of Better, Faster Lighter Java and Bitter EJB has come out with a new book called Beyond Java. Bruce has an epiphany about the future of software development. Does it include Java?
(770 comments, last posted September 23, 2009)

Three forms of AJAX: solid, liquid and gas.

Looks like today AJAX concept have several interpretations. We can distinguish different approaches of AJAX integration. Can they co-exist within the same application? Can we talk about layered AJAX integration?
(68 comments, last posted May 08, 2008)

Design-Time API Promises to make Java more like VB

Artima has published a short article describing the Design-Time API for JavaBeans, which was recently approved as JSR 273. This API promises to bring VB-like ease to Java development, but may face a cultural bias among Java developers who tend to think more in terms of class libraries than components.
(225 comments, last posted November 19, 2009)

Will Sun be that target of a management buyout?

There is plenty of speculation today regarding a potential buyout of Sun Microsystems by Scott McNealy and Silver Lake Partners. How would privatization of Sun affect Java?
(16 comments, last posted May 15, 2009)

More hot threads »