[jboss-jira] [JBoss JIRA] Commented: (JBAS-4320) The EJB2 timer service with persistencePolicy=database can not start on MySQL

[mike ayres (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBAS-4320?page=comments#action_12410143 ] 
            
mike ayres commented on JBAS-4320:
----------------------------------

Sergey,

For the Postgres XA datasource you must specify the metadata (as noted in the error)

  <xa-datasource>
      ...
      <metadata>
         <type-mapping>PostgreSQL</type-mapping>
      </metadata>
  </xa-datasource>


See standardjbosscmp-jdbc.xml for the defined mappings

> The EJB2 timer service with persistencePolicy=database can not start on MySQL
> -----------------------------------------------------------------------------
>
>                 Key: JBAS-4320
>                 URL: http://jira.jboss.com/jira/browse/JBAS-4320
>             Project: JBoss Application Server
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: EJB2, Scheduling/Timers
>    Affects Versions: JBossAS-5.0.0.Beta2
>         Environment: MySQL 5, JBossAS-5.0.0.Beta2
>            Reporter: Joshua Partogi
>         Assigned To: Scott M Stark
>         Attachments: ejb2-timer-service.xml, mysql-ds.xml, stacktrace.txt
>
>
> The database tested other than HSQL is only MySQL
> Perhaps we should also check other database too

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira