tomcat怎么连接oracle数据库
我安装了tomcat,配了一个数据源(名称:oracleJNDI)
怎么用这个数据源连接数据库?
是不是这样:
InitialContext ctx = new InitialContext();
String dataSourceName="oracleJNDI";
DataSource ds=null;
ds=(DataSource)ctx.lookup(dataSourceName);
Connection con=ds.getConnection("tmp","123");
Statement sta = con.createStatement();
ResultSet rs = sta.executeQuery("select * from tmp");
while (rs.next()){
out.println(rs.getString(1));
}
我这样试了一下,报错如下:
org.apache.jasper.JasperException: Name oracleJNDI is not bound in this Context
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
先谢谢大虾了!!!!