I'm using WAS CE V18.104.22.168 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.
Pinned topic Oracle Database pool
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-02-09T05:21:08Z at 2012-02-09T05:21:08Z by U4UE_xie_zhi
Y5HD_Victor_Nechiporenko 270004Y5HD3 Posts
Re: Oracle Database pool2012-01-19T13:49:46ZThis is the accepted answer. This is the accepted answer.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.