My major application database is on one server. Part of the database resides on some other server. Is there is any way by which i can access the data which resides on the other serverm by changing only the connecivity part in the JSP code. My database is on ORACLE.
U can email the replys at
vickykak at justice dot com
or
rohanm at ureach dot com
Discussions
Web tier: servlets, JSP, Web frameworks: Connecting multiple databases on different servers
-
Connecting multiple databases on different servers (2 messages)
- Posted by: vicky kak
- Posted on: February 09 2001 07:54 EST
Threaded Messages (2)
- Connecting multiple databases on different servers by Kapil Israni on February 09 2001 08:58 EST
- Connecting multiple databases on different servers by vicky kak on March 16 2001 04:14 EST
-
Connecting multiple databases on different servers[ Go to top ]
- Posted by: Kapil Israni
- Posted on: February 09 2001 08:58 EST
- in response to vicky kak
sure u can do that. when u connect to database using JDBC u specify the database URL which identifies which database u r connecting to. and the database URL contains the IP address or the NETBios name of the actual machine u r connecting to. so u just need to change the IP address to point it to corrrect database.
kapil -
Connecting multiple databases on different servers[ Go to top ]
- Posted by: vicky kak
- Posted on: March 16 2001 04:14 EST
- in response to Kapil Israni
kapil,
Got the reply but still not fully clear,is the technique mentioned by you similar to the thin driver
concept in jdbc.Since to connect to different database
server i require to get the jdbcdriver for that server,
through which i can proceed for connection etc.
thanks
vicky