db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerhard Otte" <Gerhard.O...@emediapark.de>
Subject AW: DB Issues
Date Fri, 05 Mar 2004 13:43:35 GMT
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:G.Otte@emediapark.de     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:vincent.a.tebano@lmco.com]
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:Gerhard.Otte@emediapark.de] 
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:G.Otte@emediapark.de     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:vincent.a.tebano@lmco.com]
Gesendet: Freitag, 5. März 2004 14:01
An: torque-user@db.apache.org
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message