• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

jdbc and the internet

 
Ranch Hand
Posts: 77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
author
Posts: 4323
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Switch to MySQL. Running JDBC to Access is risky at best.
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 2856
10
Firefox Browser Fedora Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
All you need is a connection string something like "http://yourdomain.com:your_port" to connect to the database.
 
Their achilles heel is the noogie! Give them noogies tiny ad!
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic