• 2 replies
  • Latest Post - ‏2012-02-09T05:21:08Z by U4UE_xie_zhi
2233 Posts

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?
Updated on 2012-02-09T05:21:08Z at 2012-02-09T05:21:08Z by U4UE_xie_zhi
  • Y5HD_Victor_Nechiporenko
    3 Posts

    Re: Oracle Database pool

    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
    54 Posts

    Re: Oracle Database pool

    Did Y5HD_Victor_Nechiporenko's solution solve your issue?