File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
REST with Spring (video course)
this week in the
JDBC and Relational Databases
Datasource for non-default instance of SQL Server
Joined: Aug 31, 2004
Mar 18, 2008 07:16:00
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 :
Driver : net.sourceforge.jtds.jdbc.Driver
Connection URL :
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!!
Joined: Apr 14, 2004
Mar 18, 2008 07:43:00
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.
I agree. Here's the link:
subject: Datasource for non-default instance of SQL Server
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.
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015