db-torque-user mailing list archives

All,

 

I am getting the following exceptions when trying running my application. My
configuration file contains:

 

torque.dsfactory.clientsite.connection.driver =
com.microsoft.jdbc.sqlserver.SQLServerDriver

torque.dsfactory.clientsite.connection.url =
jdbc:microsoft:sqlserver<server>:<port>;DatabaseName=<databasename>;SelectMe
thod=cursor

 

and the JAR containing the SQL driver is in the lib directory. 

 

Has anyone come across this exception?

 

 

Regards,

 

John Boyko

Raymond James Ltd.

604.654.7285

 

 

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The
requested instance is either invalid or not running.

            at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

            at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)

            at
com.microsoft.jdbc.sqlserver.tds.TDSConnection.mapInstanceNameToPort(Unknown
Source)

            at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown
Source)

            at
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

            at
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

            at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

            at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

            at java.sql.DriverManager.getConnection(DriverManager.java:512)

            at java.sql.DriverManager.getConnection(DriverManager.java:171)

            at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(Dr
iverAdapterCPDS.java:180)

            at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(Dr
iverAdapterCPDS.java:146)

            at
org.apache.torque.pool.ConnectionPool.getNewConnection(ConnectionPool.java:2
54)

            at
org.apache.torque.pool.ConnectionPool.getConnection(ConnectionPool.java:223)

            at
org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa
taSource.java:488)

            at
org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa
taSource.java:458)

            at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743)

            at org.apache.torque.Torque.getConnection(Torque.java:306)

            at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)

            at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365)

            .

 

rethrown as org.apache.torque.TorqueException: [Microsoft][SQLServer 2000
Driver for JDBC]The requested instance is either invalid or not running.

            at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:755)

            at org.apache.torque.Torque.getConnection(Torque.java:306)

            .

 

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]The requested instance is either invalid or not running.

            at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

            at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)

            at
com.microsoft.jdbc.sqlserver.tds.TDSConnection.mapInstanceNameToPort(Unknown
Source)

            at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown
Source)

            at
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

            at
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

            at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

            at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

            at java.sql.DriverManager.getConnection(DriverManager.java:512)

            at java.sql.DriverManager.getConnection(DriverManager.java:171)

            at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(Dr
iverAdapterCPDS.java:180)

            at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(Dr
iverAdapterCPDS.java:146)

            at
org.apache.torque.pool.ConnectionPool.getNewConnection(ConnectionPool.java:2
54)

            at
org.apache.torque.pool.ConnectionPool.getConnection(ConnectionPool.java:223)