File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Copy record in the same file. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Copy record in the same file." Watch "Copy record in the same file." New topic
Author

Copy record in the same file.

Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 666
I need to use 1 record in a file to create another record in the same file. The new record has the same column values except 1 or 2 columns. Is there a simple way to do this? I try to avoid reading every column to parse a INSERT string?
Thanks.


BJ - SCJP and SCWCD
We love Java programming. It is contagious, very cool, and lot of fun. - Peter Coad, Java Design

Crazy Bikes created by m-Power
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by Bruce Jin:
I need to use 1 record in a file to create another record in the same file. The new record has the same column values except 1 or 2 columns. Is there a simple way to do this? I try to avoid reading every column to parse a INSERT string?
Thanks.

The only solution that I can think of ( If I understand your question correctly ) is to use a DB specific SQL statement like:
insert into table2 ( column1, column2,... ) select column1, column2,... from table1 where ....
the above example works for Oracle, but may vary for other DB vendors.
Jamie
Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 666
Thanks.
Looks like there is no trick doing this.
I need copy to happen in the same file.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by Bruce Jin:
Thanks.
Looks like there is no trick doing this.
I need copy to happen in the same file.

why not just change table2 to table1. It will insert into table1 based on a query on the same table( table1 ).
Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 666
Thanks again.
I tried and the same table copy works. But now I am duplicating record.
How can I alter 1 of the columns before insert?

I am using this sql string:
insert into cust01 (select * from cust01 where custid=1002)
What I want is to change custid to 1003 before insert the record into database.
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Hi Bruce,
You 'll need to get rid of the ugly "select *". It 'll have to be something like this
.
Let me also suggest that you 'd do yourself a favour reading up on SQL, if you plan to do this sort of thing more often.
Good riding,
Rudy.
Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 666
Thanks Rudy;
Your code works.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Copy record in the same file.
 
Similar Threads
Records
Compare Two Column
nx:All of URLy Bird 1.1.3 find and search method
findByCriteria
reading a section of a file