943,547 Members | Top Members by Rank

Ad:
  • JSP Discussion Thread
  • Marked Solved
  • Views: 17981
  • JSP RSS
You are currently viewing page 1 of this multi-page discussion thread
Jan 29th, 2007
0

insert and update data in two different database

Expand Post »
good day ,

i am new to java ,

i am using two different databases and i want to insert data from one table to other empty table using jdbc .and it consists of null values in one table along with some data .when ever we add new data to one table it should insert into other table and existence data should be updated after insert is executed.

can i have one example with these details.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
reddy5081 is offline Offline
1 posts
since Jan 2007
Jan 29th, 2007
0

Re: insert and update data in two different database

Click to Expand / Collapse  Quote originally posted by reddy5081 ...
good day ,

i am new to java ,

i am using two different databases and i want to insert data from one table to other empty table using jdbc .and it consists of null values in one table along with some data .when ever we add new data to one table it should insert into other table and existence data should be updated after insert is executed.

can i have one example with these details.
Sorry, I don't see any problem with this as all datas which you save in first database are still stored in their original variables plus same string you use on first database can be send to second one, or may be modified before sending as neccesary. So what you do I presume is recive data from form, validate them, store in varables, open conection with first database, save data, close conection, open connection to second database, save data and close connection. Then go to other page or refresh original...
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 871
Code tags enforcer
peter_budo is offline Offline
6,653 posts
since Dec 2004
Jan 31st, 2007
0

Re: insert and update data in two different database

it has nothing to do with JSP either (and anyone doing something like this in a JSP should be shot, preferably in the gut, and left for the vultures).
Team Colleague
Reputation Points: 1658
Solved Threads: 331
duckman
jwenting is offline Offline
7,719 posts
since Nov 2004
Feb 1st, 2007
0

Re: insert and update data in two different database

Click to Expand / Collapse  Quote originally posted by jwenting ...
it has nothing to do with JSP either (and anyone doing something like this in a JSP should be shot, preferably in the gut, and left for the vultures).
Hmmmm, was this addressed to me
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 871
Code tags enforcer
peter_budo is offline Offline
6,653 posts
since Dec 2004
Feb 1st, 2007
0

Re: insert and update data in two different database

if you feel it is, it might be
Team Colleague
Reputation Points: 1658
Solved Threads: 331
duckman
jwenting is offline Offline
7,719 posts
since Nov 2004
Feb 12th, 2007
0

Re: insert and update data in two different database

Click to Expand / Collapse  Quote originally posted by peter_budo ...
Sorry, I don't see any problem with this as all datas which you save in first database are still stored in their original variables plus same string you use on first database can be send to second one, or may be modified before sending as neccesary. So what you do I presume is recive data from form, validate them, store in varables, open conection with first database, save data, close conection, open connection to second database, save data and close connection. Then go to other page or refresh original...

Hi all,
I have a similar sort of problem and I am little bit familiar with java-JDBC and I would like to know how do I insert data from one database table to the other database table using java. This insertion must happen when ever there is a change in first database(change in the sense like for insertion an insert and for updation an update and for deletion a delete.). please tell me the procedure to do this sort of work or a small program which gives an Idea.

help me in this issue.
Reputation Points: 10
Solved Threads: 1
Newbie Poster
vijaymanoharrao is offline Offline
1 posts
since Feb 2007
Feb 14th, 2007
0

Re: insert and update data in two different database

start your own threads, kid.
And read some tutorials... What you want is
a) well described
b) inappropriate for doing in Java (unless you're using a database engine that uses Java stored procedures maybe).
Team Colleague
Reputation Points: 1658
Solved Threads: 331
duckman
jwenting is offline Offline
7,719 posts
since Nov 2004
Sep 9th, 2008
-1

Re: insert and update data in two different database

post your code !!!
Reputation Points: 6
Solved Threads: 1
Newbie Poster
haoyou2008 is offline Offline
7 posts
since Sep 2008
Jun 20th, 2009
-2

Re: insert and update data in two different database

Click to Expand / Collapse  Quote originally posted by jwenting ...
it has nothing to do with JSP either (and anyone doing something like this in a JSP should be shot, preferably in the gut, and left for the vultures).
You are totally right...
Reputation Points: 3
Solved Threads: 0
Light Poster
CasTex is offline Offline
45 posts
since Mar 2008
Aug 19th, 2009
0

Re: insert and update data in two different database

Very useful discussion, am new to JSP, trying to learn from last two weeks, this discussion about database entry seems useful info for me. Thanks.
Reputation Points: 7
Solved Threads: 2
Light Poster
jenn11 is offline Offline
25 posts
since Jul 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in JSP Forum Timeline: login detail verification from oracle DB
Next Thread in JSP Forum Timeline: HI





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC