Hi John, I use SQL Squirrel to sort out the JDBC connect string before running Torque since SQL Squirrel is a pure JDBC client
Cheers, Siegfried Goeschl -----Original Message----- From: John Boyko [mailto:[EMAIL PROTECTED] Sent: Dienstag, 01. Juni 2004 18:37 To: [EMAIL PROTECTED] Subject: SQLException and TorqueException when getting a Connection. 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) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
