"hasc" wrote : Hi, | | i posted this question already in the seam forum, but i was told I should post the question here again... | | I wrote a simple stateless bean to test the TimerService. i am using jboss 4.2.0GA | |
I hope you long ago solved your issue =) Bit since I saw this problem a number of places w/out a solution I'm commenting here. I ran into this moving from Jboss 4.0.5 to 4.2.2 using Postgresql 8.1 Your DS doesn't support the XA interface. I assume there is a way to do this in HSQL as well but found no answer (I saw no XA DataSource in the hsqldb.jar)? But... here is my solution. In my postgres-dx.xml I had the usual local-tx-datasource, which was used for my entities. I then added the xa-datasource | <datasources> | <local-tx-datasource> | <jndi-name>PostGresDS</jndi-name> | <connection-url>jdbc:postgresql://localhost:5432/blah</connection-url> | <driver-class>org.postgresql.Driver</driver-class> | <user-name>user</user-name> | <password>password</password> | </local-tx-datasource> | | <xa-datasource> | <jndi-name>XAPostGresDS</jndi-name> | <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> | <xa-datasource-property name="ServerName">localhost</xa-datasource-property> | <xa-datasource-property name="DatabaseName">blah</xa-datasource-property> | <xa-datasource-property name="PortNumber">5432</xa-datasource-property> | | <xa-datasource-property name="User">user</xa-datasource-property> | <xa-datasource-property name="Password">password</xa-datasource-property> | | <metadata> | <type-mapping>PostgreSQL</type-mapping> | </metadata> | </xa-datasource> | </datasources> | The type-mapping is from standardjbosscmp-jdbc.xml The configuration parameters were identifed in http://wiki.jboss.org/wiki/ConfigDataSources the wiki And in your ejb-deployer, you should use your newly configured datasource (in my case XAPostGresDS) | <mbean code="org.jboss.ejb.txtimer.DatabasePersistencePolicy" name="jboss.ejb:service=EJBTimerService,persistencePolicy=database"> | <!-- DataSourceBinding ObjectName --> | <depends optional-attribute-name="DataSource">jboss.jca:service=DataSourceBinding,name=XAPostGresDS</depends> | <!-- The plugin that handles database persistence --> | <attribute name="DatabasePersistencePlugin">org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin</attribute> | <!-- The timers table name --> | <attribute name="TimersTable">TIMERS</attribute> | </mbean> | I think thats about it. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4146006#4146006 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4146006 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user