Jboss4.0下对MySql数据源的设置方法

＜application-policy name = "MySqlDbRealm"＞ 
＜authentication＞ 
＜login-module code = 
"org.jboss.resource.security.ConfiguredIdentityLoginModule" 
flag = "required"＞ 
＜module-option name ="principal"＞sa＜/module-option＞ 
＜module-option name ="userName"＞sa＜/module-option＞ 
＜module-option name ="password"＞＜/module-option＞ 
＜module-option name ="managedConnectionFactoryName"＞ 
jboss.jca:service=LocalTxCM,name=MySqlDS 
＜/module-option＞ 
＜/login-module＞ 
＜/authentication＞ 
＜/application-policy＞

create table TIMERS (
           TIMERID varchar(50) not null,
           TARGETID varchar(50) not null,
           INITIALDATE timestamp not null,
           INTERVAL bigint,
           INSTANCEPK other,
           INFO other,
           constraint timers_pk primary key (TIMERID)