distant database and jdbc 
Author Message
 distant database and jdbc
I am trying to access a database rom a servlet,
but the server running the servlet is different from the one hosting
the database.

how can i access that databse with jdbc ?

thanks

Sent via Deja.com http://www.***.com/
Before you buy.



Fri, 25 Apr 2003 03:00:00 GMT
 distant database and jdbc

jdbc is transparent over the internet, thus is is
very simple to have jsp/servlet engine in
one comp and DB in the other

in connection string you can put (for example with oracle)
DriverManager.getConnection

The main thing here is: "can database work as a server to
accept distant calls?" jdbc is, by-itself, fine for
this work

AlexV


Quote:
> I am trying to access a database rom a servlet,
> but the server running the servlet is different from the one hosting
> the database.

> how can i access that databse with jdbc ?

> thanks

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Fri, 25 Apr 2003 03:00:00 GMT
 distant database and jdbc

Quote:

> I am trying to access a database rom a servlet,
> but the server running the servlet is different from the one hosting
> the database.

> how can i access that databse with jdbc ?

> thanks

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Using the database URL. It should be the same regardless of
the location of the client and the database server.

Cheers,
Avi.



Sun, 27 Apr 2003 11:55:45 GMT
 distant database and jdbc

Quote:

> I am trying to access a database rom a servlet,
> but the server running the servlet is different from the one hosting
> the database.

> how can i access that databse with jdbc ?

By setting the database URL. The exact syntax depends on your driver,
but for example

    jdbc:postgresql://your.database.server:5432/databasename

--

                        ;; I'd rather live in sybar-space



Sun, 27 Apr 2003 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. JBuilder-jdbc/odbc-MS Access-distant connection

2. SQL query from java application to distant web access(r) database

3. Copy a distant database ?

4. dynamic server with Informix distant database

5. cross platform distant access to sql server

6. Distant clusters

7. Probleme accès approuvé depuis un domaine distant

8. Send updates to distant web server

9. sp_oacreate and distant DLL

10. Two distant locations

11. Want to insert to distant SQL server

12. pb when trying to connect to a distant server with SQLXML console


 
Powered by phpBB® Forum Software