1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Accessing a MySQL database in java

Discussion in 'Java' started by zdunham6287, Mar 17, 2007.

  1. zdunham6287

    zdunham6287 New Member

    Joined:
    Feb 7, 2007
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Pennsylvania, USA
    Home Page:
    I've written a java program to insert data into a MySQL database hosted on godaddy.com, I'm still having trouble connecting to the database though.

    Code:
           Connection connection = null;   
            try 
            { // load the driver 
                Class.forName("com.mysql.jdbc.Driver");
            }
            catch( Exception e ) 
            { // problem loading driver, class not exist?
                e.printStackTrace();
                return;
            }
            try 
            {
                connection = DriverManager.getConnection("jdbc:mysql://mysqladmin2.secureserver.net/277/","LyricsWhoreMain","imanidiot777");
    
    I downloaded the necessary driver for a MySQL connection, I'm not totally sure about what to change the class path to, I figured out how to change it though, can anyone help me get a database connection working?
     
    Last edited by a moderator: Mar 17, 2007
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
  3. zdunham6287

    zdunham6287 New Member

    Joined:
    Feb 7, 2007
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Pennsylvania, USA
    Home Page:
    That helped me with the driver part thanks, now my other problem is that I get a connection timing out every time I try to connect. I have no idea how to fix that.
     

Share This Page