Hey guys, just a little problem. How do you connect to a remote database that doesn't allow remote connections, lol Ok doesn't make much sense. You have a remote database that doesnt allow remote database connections, what are your alternatives given that you have to access that database?

Broad answer is Data Access layer using Web Services or custom assembly. An understanding of the environment will help provide better answer.

remote database that doesn't allow remote connections

Remote? Make it allow connections.
Its hard to solve your problem with insufficient data.

Haha i can't make it. My host(for ma site) doesn't allow remote connectionS. That means i can't. Connect to my database frm my local computer using my java code, i have to go online to access dat database. So wata a work around?

Nope. I don't even know what you're talking about.

hmm are you sure? what dont u understand?

usually you should put a request to your host to whitelist your IP to connect the to the DB. I know CPanel have a feature called php mysql remote or something like that where you put your IP.
On the other hand if they absolutely do not allow remote connections then you need to create some sort of proxy script on the server to take your sql request, query the server and return the result.

Hmmm but i wanna access the database with a java software, gat any ideas? Am so lost,

1. Proxy script
2. whitelist IP

In the proxy script just make a http request to it from your java software. The script will act as a connector i.e get query, query server, return result.

Just an idea, never had to do this before,

Use RMI to make access to the database available from your server. You need a port to use for the RMI registry.
Use RMI to obtain the access from your local machine,

Never used a proxy script and have never used the Java RMI before, ok so which do i go for now

proxy is probably less complicated. Don't know if your host supports java. To expose the interface through RMI, your host has to support java.

Your problem indicate that your server does not allow remote IP, so you have to have 127.0.0.1 as your IP or the localhost IP. RMI is definitely a no.

A proxy script is just a self made script that will act as an intermediary in this case take sql query from your java application, query the webserver and return the result to your java application.

<?php
$query = $_REQUEST['query_java_app']; //HTTP post sql query.

//mysql connection settings goes here.

mysql_query($query);

mysql_fetch_array(); //get result

//echo result back to java application.
?>

Your application should parse and filter out the result.

Ok i think thats just what i need, When you gonna be on chat so we can talk more or do ou have any documentation for this online?

URLConnection see class urlconnection for more info. This class should be able to handle the http communication between your application and the script on the web server. Imagine it as an n-tier application in this case 3 tier i.e the app, the script and the database.

use a tunnell. like in the above script
u may need to secure it though

If it's a Java host, you can even have a servlet. It simply acts as a proxy similar to what dell_net suggested. All your JDBC code will be in the servlet, and you just expose some commands to the servlet (Command Pattern).

And yes, you can also similar use a web-service (but that's overkill).