This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi, I am creating application in Java. My application is connecting to SQL server 2000. It connects properly for couple of minutes and then I am getting following error. java.rmi.ConnectException: Connection refused to host: xxx.xx.xxx.xxx; nested exception is: java.net.ConnectException: Connection refused: connect at sun.rmi.transport.tcp.TCPEndpoint.newSocket(Unknown Source) at sun.rmi.transport.tcp.TCPChannel.createConnection(Unknown Source) at sun.rmi.transport.tcp.TCPChannel.newConnection(Unknown Source) at sun.rmi.server.UnicastRef.invoke(Unknown Source) at circdatabase.client.StatusFrame_Stub.callRefresh(Unknown Source) at circdatabase.loanServices.LoanServiceImpl.callRefresh(Unknown Source) at circdatabase.loanServices.LoanServiceImpl$Schedule$RemindTask.run(Unk nown Source) at java.util.TimerThread.mainLoop(Unknown Source) at java.util.TimerThread.run(Unknown Source) Caused by: java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(Unknown Source) at java.net.PlainSocketImpl.connectToAddress(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.<init>(Unknown Source) at java.net.Socket.<init>(Unknown Source) at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(Unknown S ource) at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(Unknown S ource) ... 9 more ----------------------------------- Can anyone please help me out? Thanks, AJT
Hi "AJT" Welcome to JavaRanch! Before I answer your question: we ain't got many rules here at the Ranch, but we do have our naming policy. Most of us here just use our real names; please head over to here and change your display name to follow the rules. Thanks, pardner! Now, as to your question: my guess is that you're opening new connections, but not closing the old ones. Eventually, you're going to run out and get errors like the above. Be sure you close all your Connections and Statements when you're through using them!
Hello, Thank you for your quick response. I am closing my connections. I am running like ten java RMI Servers. Each of them are connecting to database server (SQL server 2000). I have five different databases on server and each RMI server is connecting to five databases using different connections. I am not sure how many connections sql server allows at a time. Though My app works fine for couple of minutes and then it starts throwing this exceptions. I don't know why. Do I need to reduce number of connections that i am making? Can you please guide me? Thank you, Ajay Thacker.