Finance | Project Operations, Human Resources, ...

sql: Can we cage connection after select, and if it will get a error or not?

(0) Share

Report

Posted on by Liya Cheng

Description:

if we have two userconnection and we change the useconnection to another after select, i want to known whether it will get a error? is it reasonable? please give me suggestions, thanks!

For example:

bCon = new UserConnection();
cCon = new UserConnection();
table1.setConnection(bCon);
select * from table1 where table1.intfield==2;
table1.setConnection(cCon);

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

So you want to know if the code that you shared will cause an error?

Here's the quickest way to find that out: test your code!

Then please share the result with us. Thanks :)

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Apple,

Would you mind sharing what are you trying to achieve with that approach?

Was this reply helpful? Yes No
Liya Cheng on at

Like (0)

Report

yeah, i want to know whether the error is reasonable?

error refer to the following info:

<error>Cannot execute the required database operation.

Cannot attach to connection since the buffer is in use. Use another buffer or clear the buffer by assigning NULL.<\error>

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

The error is reasonable. Trying to point a buffer to another DB connection is not.

Was this reply helpful? Yes No