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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
