MS SQL Server multiple instances, jdbc connection error

Recently a colleague of mine ran into the issue where she has more than one instance of SQL Server running (of course on different ports), able to connect with SQL Mgmt Studio, service instances running fine but JDBC applications are not able to connect – encounter an “…jdbc.SQLServerException … Connection refused …”

 – Learnt that the SQL Browser Service has to be running – this is not required for a single instance. Multiple sql server instances need the sql browser service to be running for proper connection from clients

Did not find many links related to this when trying to fix the problem 😦 but searching for sql browser service and jdbc now brings up some useful information
http://www.mssqltips.com/tip.asp?tip=1946
http://msdn.microsoft.com/en-us/library/ms181087.aspx (via http://bytes.com/topic/sql-server/answers/808470-sql-server-browser-service)

Oracle, hibernate, jdbc errors

Using Oracle 9i with hibernate on Websphere was giving consistent but unpredictable errors when writing to the database.

Patches for oracle on Win2003 – oracle patch v9.2.0.3 and the jdbc driver that came with it also did not help. (the dates on the ojdbc-jars with 9i were in 2002 and 2003)

Using the jdbc driver that came with the Oracle 10g express as the oracle driver in Websphere (but still using Oracle 9i, just the jdbc jar is the one from 10g) fixed the issues.

>>>>ojdbc14.jar
Manifest-Version: 1.0
Specification-Title:    Oracle JDBC driver classes for use with JDK14
Sealed: true
Created-By: 1.4.2_08 (Sun Microsystems Inc.)
Implementation-Title:   ojdbc14.jar
Specification-Vendor:   Oracle Corporation
Specification-Version:  Oracle JDBC Driver version - "10.2.0.1.0XE"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.1.0XE"
Implementation-Vendor:  Oracle Corporation
Implementation-Time:    Wed Jan 25 01:28:31 2006