[Seasar-user:19900] Re: transactionの質問

[Phenix Zhang]

小林さん
お世話になっております。phenixです。
下記の通り,weblogic10.3で、teradataのトラザクションを設定しましたが、画面でDBに接続したとき、エラーが発生してしまいました。
（Supports Global Transactions＋Emulate Two-Phase Commit の選択）
http://www.teradata.com/DownloadCenter/Topic9448-98-1.aspx#stto10.3

下記はエラーログです。（xxxPortalDataSourceとxxxCentralDataSourceはうちが使ってる二つのデータソースです。）
2010/06/23 15:01:28
[xxxx][127.0.0.1][8ytkMhjNyyhnpTYmm2j4dTGpb3Y9ZX2c10WTqvH3s1W86RVdhnNJ!1252808116!1277272877165][][]
[WARN ] [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default
(self-tuning)' (AppLogInterceptor.java:131) -
dfv.msm.salesforce.service.impl.RemoteObjectServiceImpl#login([E-MAIL ADDRESS DELETED])：[ESSR0072]SQLで例外(SQL=[],
Message=[Connection has already been created in this tx context for pool
named msmCentralDataSource. Illegal attempt to create connection from
another pool: xxxPortalDataSource], ErrorCode=0, SQLState=null)が発生しました
org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQLで例外(SQL=[],
Message=[Connection has already been created in this tx context for pool
named xxxCentralDataSource. Illegal attempt to create connection from
another pool: msmPortalDataSource], ErrorCode=0, SQLState=null)が発生しました
    at
org.seasar.extension.jdbc.util.DataSourceUtil.getConnection(DataSourceUtil.java:53)
    at
org.seasar.extension.jdbc.manager.JdbcManagerImpl.getJdbcContext(JdbcManagerImpl.java:376)
    at
org.seasar.extension.jdbc.query.AbstractSelect.getSingleResultInternal(AbstractSelect.java:246)
    at
org.seasar.extension.jdbc.query.AbstractSelect.getSingleResult(AbstractSelect.java:182)

    ....

    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: java.sql.SQLException: Connection has already been created in
this tx context for pool named xxxCentralDataSource. Illegal attempt to
create connection from another pool: xxxPortalDataSource
    at weblogic.jdbc.jts.Driver.getExistingConnection(Driver.java:608)
    at weblogic.jdbc.jts.Driver.connect(Driver.java:127)
    at
weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
    at
org.seasar.extension.jdbc.util.DataSourceUtil.getConnection(DataSourceUtil.java:51)
    ... 94 more

よろしくお願いします。

2010年6月22日16:10 Koichi Kobayashi <[E-MAIL ADDRESS DELETED]>:

> 小林 (koichik) です．
>
> Date:    Tue, 22 Jun 2010 15:55:35 +0900
> From:    Phenix Zhang <[E-MAIL ADDRESS DELETED]>
> To:      [E-MAIL ADDRESS DELETED]
> Subject: [Seasar-user:19892] Re: transactionの質問
>
> > jta-wls10.diconを使う時、weblogic でのデータソースはXADataSource として必須ですよね？
>
> 一つだけなら XA でないデータソースを含める
> ことができます．
> 詳しくは WebLogic のドキュメントを参照してください．
>
>
> http://otndnld.oracle.co.jp/document/products/wls/docs103/jdbc_admin/jdbc_datasources.html#wp1174138
>
> など．
>
>
> --
> <component name="koichik">
>    <property name="fullName">"Koichi Kobayashi"</property>
>    <property name="email">"[E-MAIL ADDRESS DELETED]"</property>
>    <property name="blog">"http://d.hatena.ne.jp/koichik"</property>
> </component>
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
-------------- next part --------------
HTMLの添付ファイルを保管しました...
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20100623/4ec0f724/attachment.html>