sql connection , java , my sql

Question

I am new to Java, and I need your help please.
I have a sql database in the server and always use sql plus to log into the database when in the cmd of the server. On the client PC when I tried to develop a configuration string, I am using mysql connector, will it work? Is it possible to use mysql connector for establishing connection with sql?

This is my code:

            public class Connection_String {

      static public final String driver = "com.mysql.jdbc.Driver";
      static public final String    connection= "jdbc:mysql://192.168.2.22:1521/nameofdatabase ";
      static public final String user = "user" ; 
      static public final String password = "password"; //connection password 



      public static void main(String[] args) throws ClassNotFoundException, SQLException 
      {
        try 
        {
            Class.forName(driver);
            Connection con = DriverManager.getConnection(connection,user,password);
            System.out.println(" Connection string : ");
            System.out.println(connection);
            System.out.println("User Name " + user );
            System.out.println("password" + password);

            if (!con.isClosed())
            { 
                con.close();
            }

These are the errors :

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source)

You might want to have read of this question

MadProgrammer
– MadProgrammer

2012-09-24 05:01:24 +00:00
Commented Sep 24, 2012 at 5:01 — MadProgrammer
– MadProgrammer, Commented Sep 24, 2012 at 5:01

Hernan Velasquez · Accepted Answer · 2012-09-24 04:57:25Z

2

Are you sure that your mysql is listening sockets at port 1521? By default, mysql is configured to use the port 3306.

answered Sep 24, 2012 at 4:57

Hernan Velasquez

2,82017 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

abhinav Over a year ago

i always connect to the database in the server using sql plus , is there a different connector for sql plus , since the one i am using now is for mysql

Collectives™ on Stack Overflow

sql connection , java , my sql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related