Using a SQL Server back end with a Java application server may sound like an unnatural proposition but there's no need to bow to such arbitrary limitations. In this article you'll get step-by-step instructions on making a JDBC connection between the four most popular Java application servers and Microsoft SQL Server.
by Deepak Vohra
February 6, 2007
QL Server may be the domain of Microsoft, but that doesn't mean the database engine doesn't know how to play nice with Java. In fact, SQL Server is used in J2EE applications more often than you probably think. To develop an application using SQL Server as the backend with a Java application server, you'll have to create a JDBC connection with SQL Server.
In this tutorial I will show you how to configure a JDBC connection with SQL Server from four of the most popular Java application servers: Oracle's JDeveloper (with embedded OC4J server), Red Hat's JBoss, IBM WebSphere, and BEA WebLogic. I'll show the procedure using both SQL Server 2000 and SQL Server 2005 Express.
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
QL Server may be the domain of Microsoft, but that doesn't mean the database engine doesn't know how to play nice with Java. In fact, SQL Server is used in J2EE applications more often than you probably think. To develop an application using SQL Server as the backend with a Java application server, you'll have to create a JDBC connection with SQL Server.
