JDBC JTDS configuration problems w/ Jetspeed 1 torque.properties

["Dalton, Michael D" <Mi...@nasa.gov>]

Friends - 

I am attempting to test out the JDBS JTDS driver with Jetspeed but have
had no luck configuring it so far.   All I get is a LoginException /
NullPointerException.  I currently have  Jetspeed configured with the
Microsoft driver which works fine.  Here are the torque.properties file
settings for both the Microsoft and JTDS (Microsoft settings are
commented out).  Any help in sorting this out will be appreciated -- I
would love to move to a pure open source Java solution for the JDBC
driver.

### Microsoft SQL - Microsoft driver
##torque.dsfactory.default.connection.driver =
com.microsoft.jdbc.sqlserver.SQLServerDriver
##torque.dsfactory.default.connection.url = 
##jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=portal;SelectMe
thod=cursor
##torque.dsfactory.default.connection.user =  portal
##torque.dsfactory.default.connection.password = xxxxxxxxx

### Microsoft SQL - JTDS driver
torque.dsfactory.default.connection.driver =
net.sourceforge.jtds.jdbc.Driver
torque.dsfactory.default.connection.url =
jdbc:jtds:sqlserver://localhost:1433/portal;user=portal;password=xxxxxxx
xx;TDS=8.0;

torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS
ourceFactory
# The number of database connections to cache per ConnectionPool
instance (specified per database)
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10

Our configuration:
Windows 2000 server (and Windows 2003 server)
JDK 1.4.2
Tomcat 5
Jetspeed 1.4

Michael Dalton
NASA KSC

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

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