insert and update data in two different database

[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.

[peter_budo]

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...

[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).

[peter_budo]

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 :?:

[jwenting]

if you feel it is, it might be ;)

[vijaymanoharrao]

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.

[jwenting]

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).

[haoyou2008]

post your code !!!

[CasTex]

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...

[jenn11]

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.

[9944574568]

hi how to update the table using stored procedure in jsp program

[9944574568]

can u please help me..please send me the code for that how to update the table using stored procedure in jsp program ..need it urgent

[javaAddict]

can u please help me..please send me the code for that how to update the table using stored procedure in jsp program ..need it urgent

Start a new thread