url to connect an applet to mysql on a virtual hosting environment

Thread view:

Francois - 13 Sep 2005 10:30 GMT

Hi
I can't connect to a mysql db with an applet and J-Connector although
the applet is on the same server (from my point of view).

I suspect the problem is that we are using a virtual hosting server.
I have tried url like
jdbc:mysql://www.aviron-vevey.ch:3306/DB_name
jdbc:mysql://localhost:3306/www.aviron-vevey.ch/DB_name
jdbc:mysql://localhost:3306/DB_name
jdbc:mysql://213.242.101.162:3306/DB_name
jdbc:mysql://box1.swiss-online.com:3306/DB_name

... but all I get is connection timed out or access.denied.

The same applet with LAMPP on my pc work without problem.

Is there anyone here who could help me ?

TIA

Francois

Reply to this Message

John Currier - 13 Sep 2005 19:08 GMT

> I can't connect to a mysql db with an applet and J-Connector although
> the applet is on the same server (from my point of view).

Applets don't typically run on the same machine as a database or web
server. They run on the machine that's running the browser.

Just making sure that you're clear on that,
John
http://schemaspy.sourceforge.net

Reply to this Message

Francois - 14 Sep 2005 07:06 GMT

OK, what I mean is "my applet should be able to make a connection to
the database, since (I believe) it comes from the same host as the
database". I know that it runs on the pc where the browser is.

Francois

Reply to this Message

John Currier - 15 Sep 2005 03:29 GMT

How about something like this:

conn = DriverManager.getConnection("jdbc:mysql://" +
applet.getCodeBase().getHost() + ":3306/DB_name", dbUsername,
dbPassword);

John
http://schemaspy.sourceforge.net

Reply to this Message

url to connect an applet to mysql on a virtual hosting environment

Free Magazines