|
Sponsored Links
Resources
Enterprise Java Research Library
Get Java white papers, product information, case studies and webcasts
|
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
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.
|
|
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
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
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 #319105
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
 |
Do this:
I just discoreved:
You have to add this custom properties for de datasource:
serverName: myserver portNumber: 1433 (optional) databaseName: ICPC
|
|
 |
Hot threads
Hot threads
Hot threads
|
More hot threads
More hot threads
More hot threads
|
 |
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)
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)
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)
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)
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 »
|
|