mysql connectivity failure

[trinity jecob]

I am trying to develop a small application using struts framework. For data base I am using MySQL-5.1.

Struts-config.xml contents are as follows -

    
 
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
<set-property property="url" value="jdbc:mysql://localhost/mydb" />
<set-property property="username" value="root" />
<set-property property="password" value="" />
</data-source>
</data-sources>
 

But when I run the Login page & try to access the dabase, it is givig me the following error -

    
 
[9/14/06 17:42:18:631 IST] 2b9e4b41 SystemOut     O DBCP borrowObject failed: java.sql.SQLException: Cannot connect to MySQL server on 10.175.100.175:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)
 
[9/14/06 17:42:18:631 IST] 2b9e4b41 SystemOut     O Exception Occured  :(    :(    :(  java.sql.SQLException: Cannot connect to MySQL server on 10.175.100.175:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)
 

I am not getting y it is happening.

The code in Action class is as follows -

    
 
try{
    datasrc = getDataSource(request);
    con = datasrc.getConnection();

    if (null != con){
stmt = con.createStatement();
if(null != stmt){
res = stmt.executeQuery("select * from user_info");

if (null != res){

while(res.next()){
String dbUser = res.getString("userid");
String dbPwd = res.getString("password");
}
}//end of while(res not empty)
}//end of if(res not null)
}//end of if(stmt not null)
}//end of if(con not null)
}catch (Exception e){
target="failure";
System.out.println("Exception Occured  :(    :(    :(  " + e.getMessage());
}
 

What could be the reason?

[Bear Bibeault]

"ttt jjj", you have previously been warned on one or more occasions regarding adjusting your display name to meet JavaRanch standards. This is not optional. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it prior to your next post.

Be aware that accounts with invalid display names are removed.

bear
JavaRanch Sheriff

[trinity jecob]

First of all I apologize for the prev. display name. I hope the updated one should not create a problem.

Thanks.

[Merrill Higginson]

Trinity,

Thanks for changing your name, but the JavaRanch naming policy indicates that you need both a first and a last name that are not initials and are not obviously fictitious.

Regarding your question: This error seems to indicate that your Mysql database server is not responding. Can you ping 10.175.100.175 from the system hosting your app server? Does the system with an IP address of 10.175.100.175 have an instance of Mysqld running on the default port of 3306?

[trinity jecob]

Thanks

The Ip address I have mentioned (10.175.100.175) is the ip of my machine only. I tried to give 'localhost' as well. I have not specifed the port number.

How can I confirm that on which port the MySql Instant is running??

Thanks in advance

[Merrill Higginson]

Unless you've changed it in your config file (and you probably haven't), the default port number is 3306. Did you Start the MYSQL database listener on your computer by running the command mysqld from the c:/<mysql install dir>/bin directory?

[trinity jecob]

yes i did that. Confirmed in the TaskManager a process 'mysqld-nt.exe' is running.

moreover after executing the following commands on command prompt, i got these results -

    
 
netstat -ao
 
Active Connections
 
  Proto  Local Address          Foreign Address        State           PID
  TCP    PDCDT088:1266          localhost:3306         ESTABLISHED     2052
  TCP    PDCDT088:3306          localhost:1266         ESTABLISHED     616
 
wmic process where ProcessId='616' get caption
 
Caption
mysqld-nt.exe
 

But still after running the application i am getting the exception as -

 
[9/15/06 14:48:41:979 IST] 2a942742 SystemOut     O DBCP borrowObject failed: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)
 
[9/15/06 14:48:41:979 IST] 2a942742 SystemOut     O Exception Occured  :(    :(    :(  java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)

[Merrill Higginson]

Ok, I no longer believe it's a problem with your Mysql server.

If you're using Tomcat, you may want to try changing your DataSource type to Tomcat's basic DataSource, as described in this article.

Quite frankly, I recommend that you don't use the Struts DataSource utility at all. The best practice is to define your DataSource using whatever method your application server recommends, and then to connect to that DataSource with a JNDI lookup. This way you can find the DataSource from any Java Class, and are not dependent on the Action class to find it.

[trinity jecob]

I am not using Tomcat. I am using WSAD 5.1 to create the application and the default websphere server.

[Merrill Higginson]

Here is an article explaining how to set up a Mysql data source in WebSphere