You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by John Mattos <ma...@yahoo.com> on 2002/11/12 20:54:39 UTC
RE: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL Server 2000
Hmm. I have the app specified in my server.xml as follows. dows anything jump out at you? I even used the IP instead of the DNS entry for the DB machine
<!-- iN DEMAND Clearinghouse Context -->
<Context docBase="indemand" path="/indemand" reloadable="true" source="indemand">
<Resource name="jdbc/indemand" auth="SERVLET"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/indemand">
<parameter>
<name>user</name>
<value>tibco_user</value>
</parameter>
<parameter>
<name>password</name>
<value>tibco_user</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:inetdae7:10.10.0.84:1433?database=TibcoClearHouse</value>
</parameter>
</ResourceParams>
</Context>
"Turner, John" <JT...@AAS.com> wrote:
Yup. It's network related. Probably the name of the database server can't
be resolved into an IP address, or a connection request is being made on the
wrong port. SQL Server's default port is 1433, I believe.
John
> -----Original Message-----
> From: John Mattos [mailto:mattosj@yahoo.com]
> Sent: Tuesday, November 12, 2002 2:48 PM
> To: tomcat-user@jakarta.apache.org
> Subject: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL Server
> 2000
>
>
>
> I'm getting the following error trying to connect to my SQL
> Server Database
>
> java.sql.SQLException: [Microsoft][SQLServer JDBC
> Driver]Error establishing socket.
>
> I'm using the driver
> "com.microsoft.jdbc.sqlserver.SQLServerDriver", and the 3
> necessary jar files are in C:\Tomcat4.0.6\lib (msbase.jar,
> msutil.jar and mssqlserver.jar)
>
> Any thoughts on this? Has anyone seen this before?
>
> John
>
>
>
> ---------------------------------
> Do you Yahoo!?
> U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD
>
--
To unsubscribe, e-mail:
For additional commands, e-mail:
---------------------------------
Do you Yahoo!?
U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD
RE: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL Server 2000
Posted by "Sexton, George" <gs...@mhsoftware.com>.
Change
jdbc:inetdae7:10.10.0.84:1433?database=TibcoClearHouse
to
jdbc:microsoft:sqlserver://10.10.0.84:1433;DatabaseName=TibcoClearHouse
George Sexton
MH Software, Inc.
Home of Connect Daily Web Calendar Software
http://www.mhsoftware.com/connectdaily.htm
Voice: 303 438 9585
-----Original Message-----
From: John Mattos [mailto:mattosj@yahoo.com]
Sent: 12 November, 2002 12:55 PM
To: Tomcat Users List
Subject: RE: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL
Server 2000
Hmm. I have the app specified in my server.xml as follows. dows anything
jump out at you? I even used the IP instead of the DNS entry for the DB
machine
<!-- iN DEMAND Clearinghouse Context -->
<Context docBase="indemand" path="/indemand" reloadable="true"
source="indemand">
<Resource name="jdbc/indemand" auth="SERVLET"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/indemand">
<parameter>
<name>user</name>
<value>tibco_user</value>
</parameter>
<parameter>
<name>password</name>
<value>tibco_user</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:inetdae7:10.10.0.84:1433?database=TibcoClearHouse</value>
</parameter>
</ResourceParams>
</Context>
"Turner, John" <JT...@AAS.com> wrote:
Yup. It's network related. Probably the name of the database server can't
be resolved into an IP address, or a connection request is being made on the
wrong port. SQL Server's default port is 1433, I believe.
John
> -----Original Message-----
> From: John Mattos [mailto:mattosj@yahoo.com]
> Sent: Tuesday, November 12, 2002 2:48 PM
> To: tomcat-user@jakarta.apache.org
> Subject: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL Server
> 2000
>
>
>
> I'm getting the following error trying to connect to my SQL
> Server Database
>
> java.sql.SQLException: [Microsoft][SQLServer JDBC
> Driver]Error establishing socket.
>
> I'm using the driver
> "com.microsoft.jdbc.sqlserver.SQLServerDriver", and the 3
> necessary jar files are in C:\Tomcat4.0.6\lib (msbase.jar,
> msutil.jar and mssqlserver.jar)
>
> Any thoughts on this? Has anyone seen this before?
>
> John
>
>
>
> ---------------------------------
> Do you Yahoo!?
> U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD
>
--
To unsubscribe, e-mail:
For additional commands, e-mail:
---------------------------------
Do you Yahoo!?
U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>