Accessing a Remote Database

From: Rhino (rhino1_at_NOSPAM.sympatico.ca)
Date: 12/13/03

  • Next message: Herman Timmermans: "Re: Accessing a Remote Database" 
    Date: Fri, 12 Dec 2003 20:24:47 -0500

    I have some Java programs (including applications, applets, and servlets)
    that can access the local database just fine. (By "local", I mean that the
    application and the database reside on the same PC.)

    What do I need to do differently if the database is *not* local? For
    example, I have a Windows XP machine and I want programs running on it to
    access a MySQL database at my friend's server in another town.

    At present, I achieve local access by ensuring that my programs can see the
    database driver and then connecting, passing in the URL (e.g.
    jdbc:db2:<database-name>), userid, and password.

    If I want my programs to run against the database on my friend's Linux box,
    what do I need to do? Is it simply a matter of telling the driver to look on
    the remote machine instead of my own machine via a different URL or is it
    more involved? Can anyone take me through the steps I'll need to take? 

    -- 
Rhino
---
rhino1 AT sympatico DOT ca
"If you want the best seat in the house, you'll have to move the cat."
  • Next message: Herman Timmermans: "Re: Accessing a Remote Database"

    Relevant Pages

    • Re: TIP#308: Choice of dict as the row representation
      ... names with the possibility of NULLs. ... place the onus on the database driver to disambiguate the names, ... you can specifically tell the database to insert whatever substitute ...
      (comp.lang.tcl)
    • Re: TNS could not resolve the connect identifier
      ... database driver. ... Who supports and configures the database drivers on your production web ... The provider name is System.Data.OleDb. ... The web application does not work on the production web server. ...
      (comp.databases.oracle.server)
    • Re: TIP#308: Choice of dict as the row representation
      ... names with the possibility of NULLs. ... place the onus on the database driver to disambiguate the names, ... you can specifically tell the database to insert whatever substitute ...
      (comp.lang.tcl)
    • Re: Threading with Database Access
      ... > I have a singleton class that accesses a database (using jtds as ... > In the jtds database driver I have read that while connection is ... not" as meaning that multiple threads calling the same Statement Object ...
      (comp.lang.java.programmer)
    • Re: Threading with Database Access
      ... > I have a singleton class that accesses a database (using jtds as ... > public static DatabaseAccessSingleton getInstance() { ... > In the jtds database driver I have read that while connection is ...
      (comp.lang.java.programmer)