Topic
2 replies Latest Post - ‏2012-02-09T05:21:08Z by U4UE_xie_zhi
SystemAdmin
SystemAdmin
2233 Posts
ACCEPTED ANSWER

Pinned topic Oracle Database pool

‏2012-01-17T17:55:26Z |
Hello all,

I'm using WAS CE V2.1.1.6 for supporting an application called WMQ FTE Logger. I need to define a Database Pool, and I'm a remote Oracle db.

When defining the Database Pool the recommendation is to use the Oracle Thin. The documentation recommends Database Type "Oracle Thin" and the from Transaction Type select "XA", but when I hit deploy it fails. I'm attaching the relevant WAS CE log and the plan file.

Some suggestions?
Thanks!
Updated on 2012-02-09T05:21:08Z at 2012-02-09T05:21:08Z by U4UE_xie_zhi
  • Y5HD_Victor_Nechiporenko
    3 Posts
    ACCEPTED ANSWER

    Re: Oracle Database pool

    ‏2012-01-19T13:49:46Z  in response to SystemAdmin
    I have the same problem in WASCE 3.0.0.

    1) I created db pool with wrong type (Oracle XA)
    2) Checked that SQL doesn't work on it, and deleted it
    3) But after that I was unable to create db pool with type "Oracle Thin" - creation of new pool failed with some errors in log file.

    But my problem was resolved by restarting the server, and it looks like it was some temporary issue caused by garbage from previous pool. Maybe this helps you.
  • U4UE_xie_zhi
    U4UE_xie_zhi
    54 Posts
    ACCEPTED ANSWER

    Re: Oracle Database pool

    ‏2012-02-09T05:21:08Z  in response to SystemAdmin
    Did Y5HD_Victor_Nechiporenko's solution solve your issue?