jboss,mysql,datasource配置问题。设计的数据源没绑定,,,
///mysql-ds.xml的设置如下
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://192.168.0.10:3306/MagicGame?useUnicode=true&characterEncoding=GBK</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>root</user-name>
<password></password>
</local-tx-datasource>
</datasources>
///////////驱动放在default/lib下了
///////////通过一下访问jboss,
public static void main(String[] args) throws Exception{
//accessDataSource accessDataSource1 = new accessDataSource();
String INITIAL_CONTEXT_FACTORY = "org.jnp.interfaces.NamingContextFactory";
String PROVIDER_URL = "192.168.0.10:1099";
java.util.Properties properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY, INITIAL_CONTEXT_FACTORY);
properties.put(Context.PROVIDER_URL, PROVIDER_URL);
//properties.put(Context.URL_PKG_PREFIXES,
// "org.jboss.naming:org.jnp.interfaces");
//properties.put(Context.SECURITY_PRINCIPAL, "test_user");
//properties.put(Context.SECURITY_CREDENTIALS, "test_pass");
Context context = new InitialContext(properties);
Object object = context.lookup("java:/MySqlDS");
DataSource ds = (DataSource) object;
Connection conn = ds.getConnection();
Statement sm = conn.createStatement();
ResultSet rs = sm.executeQuery("select * from mg_article");
String name;
while (rs.next()) {
name = rs.getString("name");
System.out.println(name);
}
。。。。
。。。。
错误是:MySqlDS not binding..
想测试一下是否得到datasource,,,埃 郁闷的 大伙帮忙的了