This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes jdbc and the internet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc and the internet" Watch "jdbc and the internet" New topic
Author

jdbc and the internet

rob armstrong
Ranch Hand

Joined: Jul 25, 2005
Posts: 77
Currently I am running Microsoft Access database and JDBC connects to it on my local network. I want to devolop JDBC client software that will make queries and updates via the internet however I am having problems making the database visible on the net. What are my options in doing this and should i change to MYSQL? I plan to have less than 100,000 rows on the database and queries will roughly produce 1000 resultset rows. Updates will be roughly the same or maybe i can cut it down to 500 or so if i need to.
Like i say again is my options putting the database on a FTP server or can users use it from my home computer or what is best?
roba
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Switch to MySQL. Running JDBC to Access is risky at best.


My Blog: Down Home Country Coding with Scott Selikoff
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1131

Rob,
Care to elaborate on the following:

I am guessing that if you are using an applet, then you are having security issues.
You can use JSP or servlets instead of applets, for example.
You can use PHP (I think).
You can even use .Net

Good Luck,
Avi.
rob armstrong
Ranch Hand

Joined: Jul 25, 2005
Posts: 77
Orgionally I had a Microsoft Access Database and can connect using JDBC via the Connection object. I wanted to be able to have MS Access usable from anywhere in the world though via my cleint software. Sounds like MYSQL is more secure for this job so that is fine. I have a cable modem now at home and I want various 'players' to be able to use my client software to query and make sql updates from anywhere in the world with jdbc via my client software.

hope this helps more.\
roba
Amit Ghorpade
Bartender

Joined: Jun 06, 2007
Posts: 2716
    
    6

All you need is a connection string something like "http://yourdomain.com:your_port" to connect to the database.


SCJP, SCWCD.
|Asking Good Questions|
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc and the internet