-
1. Re: Question about XADatasource connection pool
nsbisgod Oct 16, 2002 5:25 PM (in response to lj123w)hi,
first of all if you have Oracle XA Sources working please could you mail me your config file. I have not been able to create an XA Datasouce working 3.0.3 . -
2. Re: Question about XADatasource connection pool
nsbisgod Oct 17, 2002 9:51 AM (in response to lj123w)I finally got it working with Oracle! I am no expert at explaining these things, but XA Datasources basically let you commit stuff across databases. So if you have a transaction spanning across multiple databases, you need to create a XA Datasource.
-
3. Re: Question about XADatasource connection pool
nsbisgod Oct 17, 2002 9:55 AM (in response to lj123w)oops! I thinks I answered the wrong query...too many threads open in too many windows...sorry my bad! Please ignore my last reply.
-
4. Re: Question about XADatasource connection pool
lj123w Oct 17, 2002 4:31 PM (in response to lj123w)It is very nice to see my post finally got answered. I've been searching for answers for the past few weeks. Fortunately, I did get my problem solved just two days ago. I'm new in J2EE technology and no expert too. Here are two points about the XADatasource that I learned from some articles: 1)you can not mixed global transactions and local transactions in a method. Although, I still not quite understand why I had mixed transactions in my case (try to open/get two connections from the same XADatasource in the same method) 2)a JTA transaction can be started implicitly or automatically by the EJB container if an EJB bean uses container managed transaction specification. My problem is right here since I use container managed session bean for my testing. Once I modified the ejb-jar.xml (changed it to Bean managed), all errors were gone.
-
5. Re: Question about XADatasource connection pool
imdkidd Nov 1, 2002 4:14 PM (in response to lj123w)Can either or you offer any insight on how you got it to work? I've been able to bind the Oracle XA Datasource but haven't been able to retrieve a connection from the pool.