aspose file tools*
The moose likes JDBC and the fly likes run query in the same time Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "run query in the same time" Watch "run query in the same time" New topic
Author

run query in the same time

Yudi Ono
Greenhorn

Joined: Aug 24, 2008
Posts: 12
hi..

i have a question..

is it possible to run query insert, update, delete in the same time in java?

if its possible could you please give me the example..

thanks & regards
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18992
    
    8

What does "in the same time" mean?
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716
    
    5

If you mean as a single update, yes, you can chain them together in a single string if your driver supports batch queries. Although usually when you perform a batch operating all the queries are the same type. Having a batch operation of multiple different type (Select, insert, update) would create output akin to apples and oranges, as in its hard for the driver to know what to return. A lot of times it might just return the information from the last operation, so hopefully that's where you put the select.


My Blog: Down Home Country Coding with Scott Selikoff
Yudi Ono
Greenhorn

Joined: Aug 24, 2008
Posts: 12
@Paul, i want to perform batch operating all query(insert, delete, update) in to one transaction, the purpose is to identified which query is fall and when it's fall i just have to rollback the transaction.

@Scott
Having a batch operation of multiple different type (Select, insert, update) would create output akin to apples and oranges , as in its hard for the driver to know what to return


hi scott is it possible to change the multiple different type query and turn it into atomic query and hold them in one transaction and it also check if one query fall, it will return error, and automatically the rollback transaction run?
Yudi Ono
Greenhorn

Joined: Aug 24, 2008
Posts: 12
Yudi Ono wrote:hi..

i have a question..

is it possible to run query insert, update, delete at the same time in java?

if its possible could you please give me the example..

thanks & regards
Yudi Ono
Greenhorn

Joined: Aug 24, 2008
Posts: 12
Yudi Ono wrote:hi..

i have a question..

is it possible to run query insert, update, delete at the same time in java?

if its possible could you please give me the example..

thanks & regards
Yudi Ono
Greenhorn

Joined: Aug 24, 2008
Posts: 12
Yudi Ono wrote:hi..

i have a question..

is it possible to run query insert, update, delete at the same time in java?

if its possible could you please give me the example..

thanks & regards
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: run query in the same time