my dog learned polymorphism*
The moose likes JDBC and the fly likes Datasource for non-default instance of SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Datasource for non-default instance of SQL Server" Watch "Datasource for non-default instance of SQL Server" New topic
Author

Datasource for non-default instance of SQL Server

Ramaswamy Srinivasan
Ranch Hand

Joined: Aug 31, 2004
Posts: 295
Dear All,

We are experiencing this situation now. On our database server, we are planning to create a non-default instance of the SQL Server Database.

On our application server, we need to configure a datasource to point to this database, which will be looked up by the application code and used for connectivity.

The information will look something like this.

Datasource Name : java:comp/env/jdbc/mysqlserver.mysite.com
Driver : net.sourceforge.jtds.jdbc.Driver
Connection URL : jdbc:jtds:sqlserver://mysqlserver.mysite.com:1433

Here, 1433 is the default port to which the default instance of the SQL will be listening to. If we create a non-default instance, the port will change, and the name of the datasource will change too.

In that case, how do we create the datasource for the non-default instance?
How would the URL field look like, provided we have the host:port info.

Requesting you to kindly help me. Thanks in advance for the reply!!
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

An "instance" in SQL Server terms is a distinct server, not a database. Is it an instance you mean? If it is I think you address it by simply changing the port numebr to the number the named instance is listening on.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Datasource for non-default instance of SQL Server
 
Similar Threads
connection to mssql server database
Using TDS Driver for MS Sql Server 2000
JBoss 4.0 and MSSQL Server 2000
Jboss- Mssql configuration porblem
java.sql.SQLException: I/O Error: DB server closed connection.