using virtual machine like mySql server
- by ffmm
i'm developing a java program and i need a database. Now i'm using MAMP and it's pretty easy but i would have a virtual machine (ubuntu server) and i need to connect my java program with this virtual machine using vitualBox.
the situation:
I installed VirtualBox on my mac and I installed an ubuntu-server machine
set "bridge adapter" in the network settings of VB
I installed mysql on ubuntu-server and i created a simple database (all work well by ubuntu)
doing ifconfig by ubuntu I get the ip: 192.168.1.217
so in the java program i made this function:
public static Connection connect(String host, int port, String dbName, String user, String passwd)
{
Connection dbConnection = null;
try
{
String dbString = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
dbString = "jdbc:mysql://" + host + ":" + port + "/" + dbName;
dbConnection = DriverManager.getConnection(dbString, user, passwd);
}
catch (Exception e)
{
System.err.println("Failed to connect with the DB");
e.printStackTrace();
}
return dbConnection;
}
and in the main() i use:
Connection con = connect(1, "192.168.1.217", 3306, "Ciao", "root", "cocacola");
3306 was a default value. I don't know if is correct, it works on mamp, but…. how I can find the correct port that I have to use with VB?
when I ran the program I get the catch excepion… what's wrong?
ps: i have to install apache o something else?
