 |  |  |  |  |  |  |  |
insert and update data in two different database
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
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.
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.
•
•
Join Date: Dec 2004
Posts: 4,217
Reputation: 
Solved Threads: 489
•
•
•
•
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.
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
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).
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
•
•
Join Date: Dec 2004
Posts: 4,217
Reputation:
Solved Threads: 489
•
•
•
•
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).
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
if you feel it is, it might be 
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
•
•
Join Date: Feb 2007
Posts: 1
Reputation:
Solved Threads: 1
Newbie Poster
•
•
•
•
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.
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).
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).
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
•
•
•
•
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).
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.
Check Cheap Web Hosting and Business Web Hosting packages.
 |
Similar Threads
- Insert & Edit Data in DataGrid (VB.NET)
- insert data from one form into two diffent database table (JSP)
- how to insert data from dataset into database (VB.NET)
- retrieving a particular value with a sql query (PHP)
- Problem with update data to database (JSP)
Other Threads in the JSP Forum
- Previous Thread: login detail verification from oracle DB
- Next Thread: HI
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest JSP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write
