在setup3.jsp "连接测试"时不能通过, 检查TOMCAT stdout.log发现如下异常:
java.io.IOException
at com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.<init>(DefaultConnectionProvider.java:455)
at com.jivesoftware.forum.database.DefaultConnectionProvider.start(DefaultConnectionProvider.java:78)
at com.jivesoftware.forum.database.ConnectionManager.setConnectionProvider(ConnectionManager.java:185)
at org.apache.jsp.admin.setup.setup3_jsp._jspService(org.apache.jsp.admin.setup.setup3_jsp:407)
...
...
Warning: DbConnectionDefaultPool.getConnection() wascalled before the internal pool has been initialized.
WARNING: ConnectionManager.getConnection() failed to obtain a connection.
好像配置有问题啊.
请问怎么初始化"internal pool"呢?
我用自己的测试jsp可以连接MySql啊, 自己的测试jsp如下:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page language="java" import="java.sql.*"%>
<%
String mySqlDriver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://localhost/jive";//数据库连接
Connection conn;
Class.forName(mySqlDriver);
conn = DriverManager.getConnection( url,"root","xxxx");//用户名与密码
if(conn==null){
System.out.println("get Conn Error");
}
Statement stmt=conn.createStatement();
ResultSet rs=null;
rs=stmt.executeQuery("select * from jiveuser");
while(rs.next())
{
%>
id=<%=rs.getString("userid")%> <%=rs.getString("username")%>
(<%=rs.getString("email")%>)
<%="<br>"%>
<%
}
rs.close();
stmt.close();
conn.close();
%>