XA data source connection failed: unknown error

pbaral Feb 12, 2015 7:53 PM

Hi,

I created a XA data source from JBOSS console but when I test the connection it says unknown error. I have checked the connection details and credentials many times and it looks correct to me. Not sure why it's not being able to test the connection as a result it is throwing errors in the jboss log file. I have attached the server log and standalone-full.xml where you can see the connection settings.

Thanks

standalone-full (1).xml 26.2 KB
server.log.zip 51.6 KB

1. Re: XA data source connection failed: unknown error

nigord Feb 12, 2015 9:01 PM (in response to pbaral)

Hello Paras,

This section looks weird:

You give it an Oracle JDBC URL:
<xa-datasource-property name="URL"> jdbc:oracle:thin:@localhost:1521:orcl </xa-datasource-property>

You confirm you want Oracle:
<xa-datasource-class>oracle.jdbc</xa-datasource-class>

Yet you try to tell it to use some form of Microsoft sqlserver driver:
<driver>informatica-mdm-platform-ear.earcom.informatica.jdbc.sqlserver.SQLServerDriver_5_1</driver>

Please confirm your database type.

Thanks,
Maxime
Actions