用这些ejb+jboss7.1+jndi 访问mysql数据库怎么弄

jboss7没有试过

jboss6.1.0 final
1 编辑jboss-6.1.0.Final/docs/examples/jca/mssql-ds.xml或者mssql-xa-ds.xml(xa resource)
connection-url, user-name, password
2 copy 以上文件到jboss-6.1.0.Final/server/default/deploy下
3 以上是完成数据源的配置工作

4 stateless session bean

Java code
@Stateless
@TransactionAttribute(TransactionAttributeType.REQUIRED)
public class Service implements ServiceLocal {
@Resource(mappedName = "java:/MysqlDS")
private DataSource dataSource;
}

5 以上完成session bean的配置，注意MysqlDS与你配置的resource xml中一致。
6 jndi look 代码

Java code

private static Object lookUpJndiObject(String jndiName) {
InitialContext ctx = null;
try {
ctx = new InitialContext();
Object object = ctx.lookup(jndiName);
return object;
} catch (NamingException e) {
String errorMessage = "NamingException: jndiName:" + jndiName;
throw new TMRuntimeException(errorMessage, e);
} finally {
SafeCloseUtil.close(ctx);
}
}

jndi名称格式 DeployProjectName + "/" + beanname + "/" + local(or remote)