How To Link My hosted online Database with my Java Programming?

Question

first i'm not much professional in JAVA programming but if you mentioned a code how hard is it I'll understand it ...

I want to create a desktop application that is connected with an online database to insert/retrieve data from it ... I've searched a lot on google but no useful answer for this and most of people say that it's impossible cuz the host provider avoid external access while i'm using bluehost/godaddy there is Remote MySQL available in the control panel ... so external access is available !!

And othere's said that I have to use php script to retrieve the database link and write it in the java code but no useful links ...

if one of these solutions are true so how can I dot it ?? and if there's another solution i'd be glad if you shared with me !!

user399666 · Accepted Answer · 2012-11-18 12:15:31Z

1

And othere's said that I have to use php script to retrieve the database link and write it in the java code but no useful links ...

That doesn't sound right at all. Java can connect to MySQL on its on accord. If your program is Java-based, why add PHP into the mix? I'm a PHP developer myself and I haven't touched Java in a while, but:

Check up on Using MySQL With Java because you'll need to use the JDBC driver (MySQL Connector/J).

try {
    conn =
       DriverManager.getConnection("jdbc:mysql://IPADDRESSGOESHERE:PORTNUMBER/yourdatabase");

    // Do something with the Connection

} catch (SQLException ex) {
    // handle any errors
    System.out.println("SQLException: " + ex.getMessage());
    System.out.println("SQLState: " + ex.getSQLState());
    System.out.println("VendorError: " + ex.getErrorCode());
}

answered Nov 18, 2012 at 12:15

user399666

20k7 gold badges49 silver badges68 bronze badges

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

2 Comments

HitchCoder Over a year ago

I've already installed the connector/j and it's working fine but on localhost ... I still need to try it on the online sql database !!

user399666 Over a year ago

@user1294027 Change localhost to the IP address of the host with your external MySQL database.

Collectives™ on Stack Overflow

How To Link My hosted online Database with my Java Programming?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related