MS SQL Server JDBC and Cocoon Connection Pool

2001-12-04 Thread Schroeter Christian

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

2001-12-04 Thread Marty McClelland

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

2001-12-04 Thread David Rosenstrauch

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]