MS SQL Server JDBC and Cocoon Connection Pool
Hi, i think about (..ok...i am forced to think about) to use the MS-SQL-Server. Surprisingly i didnt find any post in this mailinglist which deals with this challenge. So my questions: How do i connect to this MS-Sql-Server by using JDBC and the Cocoon Connection Pool (Cocoon 1.8.2)...ok... processor.xsp.pool.database.default.driver=??? processor.xsp.pool.database.default.url=??? processor.xsp.pool.database.adaptor.DBMSSqlServer=??? Which port is MSSqlServer using? In addition it was give this link to me: http://www.microsoft.com/sql/downloads/2000/jdbc.asp Cu, Christian - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: MS SQL Server JDBC and Cocoon Connection Pool
I am using MS SQL Server with C1.8.2 - but I am not using the connection pooling feature. At the Microsoft site - I was able to download the 3 jars to support jdbc and put them in the tomcat lib. Microsoft also provided a fairly lenghty document with examples of the jdbc connection including the port used. The format Microsoft used for specifying the database name in the URL was a little different from what I was familar with - but once I followed the documentation - everything worked like a charm. marty - Original Message - From: Schroeter Christian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 12:56 AM Subject: MS SQL Server JDBC and Cocoon Connection Pool Hi, i think about (..ok...i am forced to think about) to use the MS-SQL-Server. Surprisingly i didnt find any post in this mailinglist which deals with this challenge. So my questions: How do i connect to this MS-Sql-Server by using JDBC and the Cocoon Connection Pool (Cocoon 1.8.2)...ok... processor.xsp.pool.database.default.driver=??? processor.xsp.pool.database.default.url=??? processor.xsp.pool.database.adaptor.DBMSSqlServer=??? Which port is MSSqlServer using? In addition it was give this link to me: http://www.microsoft.com/sql/downloads/2000/jdbc.asp Cu, Christian - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: MS SQL Server JDBC and Cocoon Connection Pool
At 09:56 AM 12/4/01 +0100, you wrote: Hi, i think about (..ok...i am forced to think about) to use the MS-SQL-Server. Surprisingly i didnt find any post in this mailinglist which deals with this challenge. So my questions: How do i connect to this MS-Sql-Server by using JDBC and the Cocoon Connection Pool (Cocoon 1.8.2)...ok... processor.xsp.pool.database.default.driver=??? You have to choose the driver. I've used the ones from www.inetsoftware.de with SQL Server and they work nicely. Costs $ though. processor.xsp.pool.database.default.url=??? URL depends on the driver. In the case of www.inetsoftware.de the url is: jdbc:inetdae:_hostname_ Which port is MSSqlServer using? By default, 1433. Basically, pick a driver first and then put everything into place from there. HTH. DR - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]