|
|
我用jdbc连的数据库
在/conf/Catalina/locahost/加了test.xml,内容如下
<Context path="/test" docBase="test"
debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/test" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="********" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/CourseManagement"/>
</Context>
在/webapps下创建目录test,测试代码index.jsp如下:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.*"%>
<html>
<body>
<%
try
{
Context initCtx=new InitialContext();
DataSource db = (DataSource)initCtx.lookup("java:comp/env/jdbc/test");
out.println( "ok" );
Connection conn = db.getConnection();
out.println( "ok" );
Statement stmt = conn.createStatement();
out.println( "ok" );
ResultSet rs = stmt.executeQuery("SELECT * FROM Student");
out.println("User-list"+"<br>");
while(rs.next())
{
out.print(rs.getString(1)+" ");
out.print(rs.getString(2)+"<br>");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
out.print(e);
}
%>
</body>
</html>
错误打开测试网页后,错误信息如下:
ok org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null, message from server: "Host 'localhost.localdomain' is not allowed to connect to this MySQL server")
还有,我的JAVA_HOME和CLASSPATH是在setclasspath.sh中设置的
到底是怎么回事呢?
整了好久,郁闷惨了.谢谢~ |
|
IP卡
狗仔卡
发表于 2005-10-31 08:57:40
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
楼主