CMP Roster example

I am trying with CMP and it does not work. First I try with Roster CMP example against MySQL and the server responses with an exception regarding datasource not found, and I have configured the descriptor mysql-ds.xml as the tutorial explain. In fact the tutorial explains how to use MySQL with Roster CMP example.

If you know what I am talking about, will you post me the descriptors of the application.

Thanking you in advance,
Jose Alvarez de Lara

Well, I have configured the xml files to use Jboss 4.0.0 with MySQL 5.0
and I have a problem,

10:12:19,470 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
state: FAILED
I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS

Depends On Me: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'INTERVAL bigint,
INSTANCEPK other,
INFO other,
' at line 5

MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
state: FAILED
I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS

etc�

And I do not Know what file is talking of.

Any idea?

Hi All,

I have it resolved. I mean it is not necessary any post about the issue.

Thanks,
Jose Alvarez de Lara