aspose file tools*
The moose likes JDBC and the fly likes Mqsql DB connection Issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mqsql DB connection Issue" Watch "Mqsql DB connection Issue" New topic
Author

Mqsql DB connection Issue

Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492
While accessing the Mqsql DB am facing this issue. Please help me to resolve this issue. I tried changing the my sql driver from 5.1 to 5.08. But same error.

Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18909
    
    8

Like the message says, the driver can't connect to wherever the configuration says the MySQL server is running. This is a network configuration problem and no amount of futzing with software will fix it. Perhaps you don't have a MySQL server running. Or perhaps the configuration isn't pointing to it. Or perhaps there's a firewall or some other network artifact which prevents the connection.
Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492
Even I tried disabling the firewall, but no difference... any other suggestion please.
my context.xml

Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18909
    
    8

Any suggestions? Like the other suggestions which I mentioned but you ignored?

Okay. One small step at a time. Is there a MySQL server running at 180.121.22.22? Is it listening at port 1800?
Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492
yes it's running and listening... I tested the db connection by using a small program. I guess the program is by using connection pool.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18909
    
    8

May I ask whether you ran that "small program" on the same computer where this problem is occurring, or on a different computer?
Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492
You are right.. I ran that in diff computer (server were DB is running). I guess some issues on my computer.

But I tried disabling the firewall on my computer (It's windows 7 64 bit). Any other suggestion please
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mqsql DB connection Issue