求救:配置jboss3.2_tomcat的mySql数据源

shytian 2003-08-23 02:35:24

各位大侠救命啊,小弟配置jboss3.2_tomcat的mySql数据源一直搞不定啊.
我的mysql-ds.xml如下:

<?xml version="1.0" encoding="UTF-8"?>












<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/test</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></password>
</local-tx-datasource>
</datasources>

测试代码如下:

import javax.sql.DataSource;
import java.sql.*;
import java.util.*;
import javax.naming.*;

public class JBossDSTester{

public static void main(String[] args){
try
{

Properties props =new Properties();
props.put(Context.INITIAL_CONTEXT_FACTORY,"org.jnp.interfaces.NamingContextFactory");
props.put(Context.PROVIDER_URL,"localhost");
Context ctx = new InitialContext(props);
System.out.println("start!");
DataSource ds=(DataSource)ctx.lookup("java:/MySqlDS");
Connection con =ds.getConnection();
System.out.println("succeed!");
}
catch(Exception e)
{
e.printStackTrace();
}

}
}

出现一下错误

javax.naming.NameNotFoundException: No object bound for java:/MySqlDS
at com.sun.enterprise.naming.java.javaURLContext.lookup(javaURLContext.j
ava:116)
at javax.naming.InitialContext.lookup(InitialContext.java:347)
at JBossDSTester.main(JBossDSTester.java:17)

我已经把mysql-connector-java-3.0.8-stable-bin.jar拷贝到server\default\lib目录下

...全文