Multiple prepareStatement on one Connection

Hi,
how does multiple prepared statment work on one connection object.
Unknowingly I was using it for a while and it does work. Now while reviewing my code i was wondering how does this actually work.

Here is the code sample:
Connection box1Con = Commons.getBOX1DBConnection();
Connection box2Con = Commons.getBOX2DBConnection();
queryResource = readResource();

PrepareStatement ps1 = box1Con.prepareStatement(query1);
PrepareStatement ps1 = box2Con.prepareStatement(query2);

Thanks for the help in advance.
Sidd

"Sidd Sidd ",
Please check your private messages.

There is no need to have two connection for 2 prepared statement!. You can open any number of prepared statements as long as you are closing it after closing the ResutSets

Whats up with Ben ? he is sending private messages !. post it man ; let others too read !

Raees

Originally posted by Raees Uzhunnan:
Whats up with Ben ? he is sending private messages !. post it man ; let others too read !

Raees

The PM is private because it is private information.

Originally posted by Campbell Ritchie:
The PM is private because it is private information.

The name "Sidd Sidd" might be a clue...

Raees Uzhunnan,
Please check your private messages.

I apologize ben ; Yeah you are right ! if you are asking questions, be man enough !!

Originally posted by Scott Selikoff:

. . . might be a clue...

I was trying to keep quiet about that.

I forgot to mention, I am using both the prepareStatements in a loop.
ex:
Connection box1Con = Commons.getBOX1DBConnection();
Connection box2Con = Commons.getBOX2DBConnection();
queryResource = readResource();

PrepareStatement ps1 = box1Con.prepareStatement(query1);
PrepareStatement ps1 = box2Con.prepareStatement(query2);

for(int i=0; i < 100; i++){
rs1 = ps1.executeQuery();
rs1.....
rs1.close();

rs2 = ps2.executeQuery();
rs2.....
rs2.close();

}

ps1.close();
ps2.close();

Thanks
Sidd N

"Sidd N",
Please check your private messages, again.

Originally posted by Campbell Ritchie:
I was trying to keep quiet about that.

Well I've got to keep 'the conspiracy' under wraps.

Raees Uzhunnan, as you mentioned using multiple prepared statements is not an issue if we close it after closing resultset. But in my example I am closing the result set and not closing the preparedstatment. Do you see this as an issue.

Not an issue ; you can call as many execute as possible on a statement before closing it. But make sure you are not creating as many statements for the same query

Raees