You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Schroeter Christian <Ch...@nbg.sbs.de> on 2001/12/04 09:56:49 UTC
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: MS SQL Server JDBC and Cocoon Connection Pool
Posted by Marty McClelland <mm...@eduprise.com>.
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 <Ch...@nbg.sbs.de>
To: <co...@xml.apache.org>
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: MS SQL Server JDBC and Cocoon Connection Pool
Posted by David Rosenstrauch <da...@dti.net>.
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>