com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

[Anil Sharma]

Hello All,

I am using MySql 5.0. I am trying to connect database using mysql-connector-java-5.1.10-bin.jar driver. I am getting the following exception

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

my java code is as follows

import java.sql.*;

class Test{
public static void main(String args[]){
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://192.168.91.103/pamafert","pamafert","pamdb@olive");
System.out.println("Success");
}catch (Exception e){
System.out.println("Fail" +e);
}
}
}

I have searched forums but did not get the solution. Can any one please help me fix this problem.

Thanks,
Anil Sharma.

[Scott Gray-2]

Hi Anil,

What does this have to do with OFBiz?

Regards
Scott

On 30/09/2009, at 6:17 PM, Anil Sharma wrote:

>
> Hello All,
>
> I am using MySql 5.0. I am trying to connect database using
> mysql-connector-java-5.1.10-bin.jar driver. I am getting the following
> exception
>
> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:  
> Communications link
> failure
>
> my java code is as follows
>
> import java.sql.*;
>
> class Test{
> public static void main(String args[]){
> try{
> Class.forName("com.mysql.jdbc.Driver").newInstance();
> Connection
> con=DriverManager.getConnection("jdbc:mysql://192.168.91.103/
> pamafert","pamafert","pamdb@olive");
> System.out.println("Success");
> }catch (Exception e){
> System.out.println("Fail" +e);
> }
> }
> }
>
> I have searched forums but did not get the solution. Can any one  
> please help
> me fix this problem.
>
> Thanks,
> Anil Sharma.
> --
> View this message in context: http://www.nabble.com/com.mysql.jdbc.exceptions.jdbc4.CommunicationsException%3A-Communications-link-failure-tp25675159p25675159.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Anil Sharma]

Hello Scott,

My primary requirement is to connect ofbiz to mysql. I tried that by modifying entityengine.xml but I got the below error. So I am trying for general program.

Thanks,
ANil SHarma

Scott Gray-2 wrote

Hi Anil,

What does this have to do with OFBiz?

Regards
Scott

On 30/09/2009, at 6:17 PM, Anil Sharma wrote:

>
> Hello All,
>
> I am using MySql 5.0. I am trying to connect database using
> mysql-connector-java-5.1.10-bin.jar driver. I am getting the following
> exception
>
> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:  
> Communications link
> failure
>
> my java code is as follows
>
> import java.sql.*;
>
> class Test{
> public static void main(String args[]){
> try{
> Class.forName("com.mysql.jdbc.Driver").newInstance();
> Connection
> con=DriverManager.getConnection("jdbc:mysql://192.168.91.103/
> pamafert","pamafert","pamdb@olive");
> System.out.println("Success");
> }catch (Exception e){
> System.out.println("Fail" +e);
> }
> }
> }
>
> I have searched forums but did not get the solution. Can any one  
> please help
> me fix this problem.
>
> Thanks,
> Anil Sharma.
> --
> View this message in context: http://www.nabble.com/com.mysql.jdbc.exceptions.jdbc4.CommunicationsException%3A-Communications-link-failure-tp25675159p25675159.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>


 

[Scott Gray-2]

Use the entity engine and the jdbc3 driver and everything should be  
fine.

Regards
Scott

On 30/09/2009, at 7:14 PM, Anil Sharma wrote:

>
> Hello Scott,
>
> My primary requirement is to connect ofbiz to mysql. I tried that by
> modifying entityengine.xml but I got the below error. So I am trying  
> for
> general program.
>
> Thanks,
> ANil SHarma
>
>
> Scott Gray-2 wrote:
>>
>> Hi Anil,
>>
>> What does this have to do with OFBiz?
>>
>> Regards
>> Scott
>>
>> On 30/09/2009, at 6:17 PM, Anil Sharma wrote:
>>
>>>
>>> Hello All,
>>>
>>> I am using MySql 5.0. I am trying to connect database using
>>> mysql-connector-java-5.1.10-bin.jar driver. I am getting the  
>>> following
>>> exception
>>>
>>> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
>>> Communications link
>>> failure
>>>
>>> my java code is as follows
>>>
>>> import java.sql.*;
>>>
>>> class Test{
>>> public static void main(String args[]){
>>> try{
>>> Class.forName("com.mysql.jdbc.Driver").newInstance();
>>> Connection
>>> con=DriverManager.getConnection("jdbc:mysql://192.168.91.103/
>>> pamafert","pamafert","pamdb@olive");
>>> System.out.println("Success");
>>> }catch (Exception e){
>>> System.out.println("Fail" +e);
>>> }
>>> }
>>> }
>>>
>>> I have searched forums but did not get the solution. Can any one
>>> please help
>>> me fix this problem.
>>>
>>> Thanks,
>>> Anil Sharma.
>>> --
>>> View this message in context:
>>> http://www.nabble.com/com.mysql.jdbc.exceptions.jdbc4.CommunicationsException%3A-Communications-link-failure-tp25675159p25675159.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/com.mysql.jdbc.exceptions.jdbc4.CommunicationsException%3A-Communications-link-failure-tp25675159p25675539.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>