File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes TCPView AND NO ERROR BUT!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "TCPView AND NO ERROR BUT!!!" Watch "TCPView AND NO ERROR BUT!!!" New topic
Author

TCPView AND NO ERROR BUT!!!

A. S. Georgie
Ranch Hand

Joined: Dec 25, 2009
Posts: 72
hellos in there,

Brief problem was just calling a JSP page using JBoss, and JDBC driver, to retrieve some information about SQL Server 2000. and all are about this connectivity, first running i was getting the error 'The TCP/IP connection to the host localhost, port 1433 has failed' then Mr. Peter Johnson issued using TCPView find it very helpful trying correct port with sql server, but the other problem emerged like the following ...

well, using TCPView, it's a bit relief that because of not gettin' any error with using 'jtds-0.9.jar' driver an' that threepiece too, but the error is still the same with using sqljdbc.jar, and now matter is with those first, mean, when calling the page through JBoss, page chilling and no error , you see bar it's tellin you that 'Web site found. Waiting for reply ...' and bar don't go any higher than half, this time i used different versions of JBoss like jboss-4.0.5.GA, ... the result is same 'no error, no progress', this time i see what port sql server using then the problem is solved and no matter to find out this 1433, also this Administrative Tool > Data Source is working and stood firm with me,

  • i might add that when in this chilling situation you just turning SQL Server off (SQL Server Service Manager; ) page is down, i mean, is a clear reason of this hard time in connecting relation through web page, Jboss, driver, SQL Server


  • this time, tried in a different way, i mean, with Monitoring it's okay an' in the state of localhost:3333 (SQL-TCPView-Port) and it's Connecting bla bla bla at localhost:3333 ...' is 'handshaking ...' this assure relation. (3333 the last TCPView port of sqlserver)


  • so would somebody help me for a count down,

    any reply greatly regarded ...

    Peter Johnson
    author
    Bartender

    Joined: May 14, 2008
    Posts: 5776
        
        7

    How is this question different from this one: http://www.coderanch.com/t/477853/JDBC/java/netstat-telnet-TCP-IP-connection?


    JBoss In Action
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    Peter Johnson wrote:How is this question different from this one: http://www.coderanch.com/t/477853/JDBC/java/netstat-telnet-TCP-IP-connection?


    yes and it was you that helped to change the situation of this error pron that says there ... now i'm having this chilling problem, ...
    A. S. Georgie
    Ranch Hand

    Joined: Dec 25, 2009
    Posts: 72
    Well, found this one o that moot point for SQL 2000, after lots of checking, tos an' fros most parts of windows,
    this last verse installed SQL 2005, it worked , and i'm thankful Peter Johnson and Paul Sturrock for everything ..., but i still got that chilling!!!
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: TCPView AND NO ERROR BUT!!!
     
    Similar Threads
    [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing
    Tomcat Web App not Conncecting to DB, after Tomcat Change
    [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
    SQL Server express 2008 jdbc connection problem
    netstat, telnet: TCP/IP connection to localhost 1433 failed