Ok, here is my working sqlserver 2000 setup, contents of Torque.properties:
torque.applicationRoot = . torque.defaults.pool.logInterval = 0 torque.defaults.pool.connectionWaitTimeout = 10 torque.defaults.pool.defaultMaxConnections = 80 torque.defaults.pool.maxExpiryTime = 3600 torque.defaults.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.defaults.connection.url = jdbc:microsoft:sqlserver://ep01.local:1433;DatabaseName=LVS;SelectMethod =cursor torque.defaults.connection.user = ... torque.defaults.connection.password = ... torque.database.default=LVS torque.database.LVS.adapter=mssql torque.dsfactory.LVS.factory=org.apache.torque.dsfactory.SharedPoolDataS ourceFactory torque.dsfactory.LVS.pool.defaultMaxActive=10 torque.dsfactory.LVS.pool.testOnBorrow=true torque.dsfactory.LVS.pool.validationQuery=SELECT 1 HTH Gerhard Otte __ mailto:[EMAIL PROTECTED] emediapark GmbH http://www.emediapark.de Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 Regensburg,Germany -----Ursprüngliche Nachricht----- Von: Tebano, Vincent A [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 5. März 2004 14:33 An: 'Apache Torque Users List' Betreff: RE: DB Issues Nope, Tried that and it didn't work Vincent A. Tebano (Vinnie) Software Engineer Lockheed Martin Aircraft & Logistics Centers 244 Terminal Road Greenville, SC 29605 864-299-7267 -----Original Message----- From: Gerhard Otte [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 8:25 AM To: Apache Torque Users List Subject: AW: DB Issues may be you should try microsoft instead of Microsoft in the connection url Gerhard Otte __ mailto:[EMAIL PROTECTED] emediapark GmbH http://www.emediapark.de Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 Regensburg,Germany -----Ursprüngliche Nachricht----- Von: Tebano, Vincent A [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 5. März 2004 14:01 An: [EMAIL PROTECTED] Betreff: DB Issues I can't seem to get the system to connect to my Microsoft SQL 2000 DB. Are these statements needs in Torque.Properties when I am setting up my own DB. torque.database.default=default torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS ourc eFactory torque.dsfactory.default.pool.defaultMaxConnections=10 torque.dsfactory.default.pool.maxExpiryTime=3600 torque.dsfactory.default.pool.connectionWaitTimeout=10 torque.database.logInterval=0 torque.idbroker.cleverquantity=true Here is what I have set in the Torque.Properties file. I have omitted my ip, user and password for obvious reasons. torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.default.connection.url = jdbc:Microsoft:sqlserver:<ip address>:1433 torque.dsfactory.default.connection.user = <user> torque.dsfactory.default.connection.password = <password> I am getting this error when I startup the application. org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException I have also had the error that states that the system could not connect to the DB. Any Ideas what I am doing wrong? Vincent A. Tebano (Vinnie) Software Engineer Lockheed Martin Aircraft & Logistics Centers 244 Terminal Road Greenville, SC 29605 864-299-7267 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
