On Jun 3, 2009, at 3:53 PM, rbaumhof wrote:
We found out the following settings for Oracle XA Datasource. These
settings
have been tested with:
Java 1.5, Geronimo 2.1.3,2.1.4 and Oracle 10g Express (XE), 11g
Express and
11 Production.
The jar File for connect was in all cases the appropriate 10g
Express thin
jar file that is provided on oracle download site (version for java
1.4 and
higher).
Settings:
User Name: oracleuser (schema name)
Service Name: xe
Password: XXX
Confirm Password: XXX
Port: 1521
Data Source Name: oracle.jdbc.xa.client.OracleXADataSource
Network Protocol: TCP
Database Name: xe
TNS Entry Name: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host =
localhost)(Port = 1521))(CONNECT_DATA = (SID = xe)))
Driver Type: thin
Server Name: localhost
The appropriate value for Data Source Name is the name of the
datasource
class in the jdbc driver jar file. The value for TNS Entry Name is the
appropriate entry in the tnsnames.ora file.
With geronimo 2.1.4 an error is reported when deploying the
datasource and
also on every server startup. But this error can be ignored. The
datasource
works as desired. Rollbacks are performed correctly and no erronous
data
remains in the database in case of unchecked execptions.
Thanks for documenting this. What is the "error" that you're seeing on
2.1.4? Would like to see it "fixed", if possible...
--kevan
