Gytis Trikleris [https://community.jboss.org/people/gytis] created the discussion "xa-datasource is not registered correctly" To view the discussion, visit: https://community.jboss.org/message/802706#802706 -------------------------------------------------------------- Hello, I'm writing a quickstart to show integration of JBoss Transactions, IronJacamar and Tomcat. However, I am a little bit stuck with Postgres xa-datasource. It seams that it is not getting registered correctly. I can successfully access database with local datasource, but I get the following exception when using xa-datasource (exception stack trace available here: http://pastebin.com/vmjHLHX6 http://pastebin.com/vmjHLHX6): ... Caused by: org.postgresql.util.PSQLException: FATAL: database "IronJacamarTryout;User=postgres;ServerName=127.0.0.1;PortNumber" does not exist         at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:471)         at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112)         at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)         at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)         at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)         at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)         at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32)         at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)         at org.postgresql.Driver.makeConnection(Driver.java:393)         at org.postgresql.Driver.connect(Driver.java:267)         at java.sql.DriverManager.getConnection(DriverManager.java:579)         at java.sql.DriverManager.getConnection(DriverManager.java:221)         at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:92)         at org.postgresql.xa.jdbc3.AbstractJdbc3XADataSource.getXAConnection(AbstractJdbc3XADataSource.java:57)         at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:430)         ... 43 more Datasource registration code looks as following (available on github: https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a... https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a...): // ... Embedded embedded = EmbeddedFactory.create(); embedded.startup(); embedded.deploy(getURL(JDBC_RAR_FILE_NAME)); embedded.deploy(getURL(POSTGRES_DS_FILE_NAME)); Context context = new InitialContext(); DataSource dataSource = (DataSource) context.lookup("java:/PostgresDS"); Connection connection = dataSource.getConnection("postgres", "postgres"); // ... postgres-ds.xml (the one which works) looks as following (available on github: https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a... https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a...): <?xml version="1.0" encoding="UTF-8"?> <datasources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     xsi:noNamespaceSchemaLocation="http://www.jboss.org/ironjacamar/sche...     <datasource jndi-name="PostgresDS" pool-name="PostgresDS">         <connection-url>jdbc:postgresql://127.0.0.1:5432/IronJacamarTryout</connection-url>         <driver-class>org.postgresql.Driver</driver-class>         <security>             <user-name>postgres</user-name>             <password>postgres</password>         </security>         <validation>             <valid-connection-checker                  class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker>             <exception-sorter                  class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"></exception-sorter>         </validation>     </datasource> </datasources> And finally postgres-xa-ds.xml (the one which does not work) looks as following (available on github: https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a... https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a...) <?xml version="1.0" encoding="UTF-8"?> <datasources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     xsi:noNamespaceSchemaLocation="http://www.jboss.org/ironjacamar/sche...         <xa-datasource jndi-name="PostgresDS" pool-name="PostgresDS">         <xa-datasource-property name="ServerName">127.0.0.1</xa-datasource-property>         <xa-datasource-property name="PortNumber">5432</xa-datasource-property>         <xa-datasource-property name="DatabaseName">IronJacamarTryout</xa-datasource-property>         <xa-datasource-property name="User">postgres</xa-datasource-property>         <xa-datasource-property name="Password">postgres</xa-datasource-property>         <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>                 <validation>             <valid-connection-checker                  class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker>             <exception-sorter                  class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"></exception-sorter>         </validation>     </xa-datasource> </datasources> PostgreSQL version used: 9.1 IronJacamar version used: 1.0.15.Final JDK version used: 1.7 pom.xml: https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a... https://github.com/Gytis/quickstart/blob/master-JBTM-1479/ArjunaJTS/jca-a... p.s. username and password does not have to be passed to dataSource.getConnection(), if local datasource is used. However, such invocation will raise an error that password is missing, if xa-datasource is used. (see: datasource registration code). -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/802706#802706] Start a new discussion in IronJacamar at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]