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驱动也不行~~~
不知道到底错在哪里，搞了很长时间都不行，
我快要绝望了，各位大哥帮忙~~~
