Java调用存储过程的事务问题（任务紧急，望高手解决）

sundog315

原帖由 kelwenQ 于 2011-8-30 20:00 发表
对于同一个connection中，会不会有多个session的情况？

我见过有些DAO实现里是这样的
if (!conn.connected)
  conn.open();
end if;

do some things....

conn.close();

cszxheap

10有89是different的session。只是不知道是哪里分配出来的，也许是获取的时候新开的，也许是中间缓冲池，也许是mts....

cow977

JAVA用了连接池？

cszxheap

看是不是直连了，也许是走连接池的，要看部署架构。

kelwenQ

Firstly thx for your reply.

> 1）oracle 有没有数据更新延迟的问题。
No. But before 10g, RAC may have this problem. Beginning with 10gR2, RAC doesn't have this problem any more. Always tell us Oracle version.
>>We are using the Oracle 10g.

> 2）cursor会不会有查询延时的问题。

What do you mean?

>>Saying that is it possible the result set of a cursor might be not the updated result.

> 3）在不考虑我们的生产环境/代码的情况执行，出现这种情况的原因可能会有哪些？

Add a little code to print out session ID. It may be because the second step to query is on a different session.

Do you use shared server config?

>>Sorry for my insufficient knowledge, what you mean the shared server config?

kelwenQ

代码中使用的是同一个connection

Yong Huang

kelwenQ,

Share server config is documented at
http://download.oracle.com/docs/ ... cess.htm#sthref1644

Do you have v$session.server showing 'SHARED'?

What version of Oracle exactly? Do you use RAC?

Add a little code to print out session ID. It may be because the second step to query is on a different session.

Yong Huang

kelwenQ

Hi all,

Thanks for you kindly advice.

This issue is under root cause identified!

After various trial we found that is caused by program error which is complicated! Damn!

Thanks again for all your attention and advice!

Specially thanks Yong Huang for your expertise!

Best Regards.

tzdjjs

可能是2个session导致的，某些时候在使用连接池的情况下会出现此问题。