weblogic 数据库连接池的问题~~~(大家帮忙) (up给分)
weblogic的连接池 配置:
name:mypool
url: jdbc:weblogic:mssqlserver4:javadata@127.0.0.1:1433
DriverClassname: weblogic.jdbc.mssqlserver4.Driver
propertyes:
user=sa
password=sa
然后在
Data Source 中配置:
name: example-datasource-mypool
JNDI name: example-datasource-mypool
Pool Name :mypool
jsp文件~~
<%@ page import="javax.naming.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<html>
<%
out.println("adf");
Statement stmt = null;
Connection conn = null;
ResultSet rs = null;
try{
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("example-datasource-mypool");
conn = ds.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from info");
out.println("The out is ^^^^^^^^^");
//while (rs.next()){
// out.println(rs.getString(1));
// }
}catch(Exception ex){
out.println("error~~error~~error~~");
out.println(ex.getMessage());
}
%>
</body>
</html>
总是显示错误
adf error~~error~~error~~ weblogic.common.ResourceException: No resources available
在连接池配置中,用jdbc-odbc驱动也不行~~~
不知道到底错在哪里,搞了很长时间都不行,
我快要绝望了,各位大哥帮忙~~~