Connecting to external mysql database using Java

Question

I am trying to connect to a external database , but it seems that i may be making a mistake on the way i am putting the DriverManager connection, this is the first time i am connecting using this driver, Can you please point me in the right direction? thank you (might be something wrong on the getConnection call)

Class.forName( "com.mysql.jdbc.Driver" ) ;

       // Get a connection to the database
       Connection conn = DriverManager.getConnection( "jdbc:mysql://cs.cis.can.edu;databaseName=mar200;user=utest;password=utest" ) ;

Error

SQL Exception:
State  : 08S01
Message: Communications link failure

Last packet sent to the server was 0 ms ago.
Error  : 0

I posted the exception but can you tell if my code is correct (the connection string)? — user710502
– user710502, Commented Feb 10, 2012 at 3:12
Check this link and it will help you create proper connection string. MySql Connection String — havexz
– havexz, Commented Feb 10, 2012 at 3:22

Afshin Moazami · Accepted Answer · 2013-11-25 05:12:34Z

2

instead of passing one string argument, try passing each separatly like

    getConnection(String url, String user, String password)

here is the guide to the DriverManager class http://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html

edited Nov 25, 2013 at 5:12

Afshin Moazami

2,0985 gold badges33 silver badges57 bronze badges

answered Feb 10, 2012 at 3:15

bernabas

4811 gold badge4 silver badges12 bronze badges

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

Comments

Suresh · Accepted Answer · 2012-02-10 03:53:35Z

Instead of passing argument in one instance you can use separate of username, password and driver.

Connection conn = null;

           try
           {
               String userName = "testuser";
               String password = "testpass";
               String url = "jdbc:mysql://localhost/test";
               Class.forName ("com.mysql.jdbc.Driver").newInstance ();
               conn = DriverManager.getConnection (url, userName, password);
               System.out.println ("Database connection established");
           }
           catch (Exception e)
           {
               System.err.println ("Cannot connect to database server");
           }
           finally
           {
               if (conn != null)
               {
                   try
                   {
                       conn.close ();
                       System.out.println ("Database connection terminated");
                   }
                   catch (Exception e) { /* ignore close errors */ }
               }
           }

http://www.kitebird.com/articles/jdbc.html

Collectives™ on Stack Overflow

Connecting to external mysql database using Java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related