> -----Original Message----- > From: Celeste Haseltine [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 15, 2003 11:11 PM > To: '[EMAIL PROTECTED]' > Subject: Setting up Jetspeed with MS SQL Server > Importance: High > > > I'm new to Jetspeed, and I have searched the jetspeed mailing > list with no luck, so I am hoping someone can point out to me > where I am going wrong. > > I have done the following: > > 1. Run the SQL Server scripts to create and populate the > database. 2. Built the war file using the ant build.xml file > located in the C:jetspeed\build directory. 2. Put the MS SQL > Server driver in both the C:\Tomcat > 4.1\webapps\jetspeed\WEB-INF\lib and the C:\Tomcat > 4.1\common\lib directories 3. Modified the torque.properties > file as follows: > torque.database.default.adapter=mssql > torque.dsfactory.default.connection.driver = > com.microsoft.jdbc.sqlserver.SQLServerDriver > torque.dsfactory.default.connection.url = > jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=jetspeed > torque.dsfactory.default.connection.user = sa > torque.dsfactory.default.connection.password = sa >
Hello Celeste, I'm using jetspeed with MS-SQL and it works fine. I cannot really say what is wrong, the only differences I noticed between your torque.properties and mine is that in my properties it is "DatabaseName=jetspeed" (with a small 'b', but I don't know if these properties are case sensitive), and my db has no password. For me, it even worked without having to rebuild the war. Cheers -- Holger Dewes --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
