偶是这样配置的,,高手来帮偶看看,有什么错...
使用的是Tomcat 5.0..在D:\Tomcat 5.0\webapps\scm下(scm是这个项目名称)
1.一个scm.xml,,内容如下:
<Context docBase="/scm" path="/scm" workDir="work\Catalina\localhost\scm" debug="10"> <Resource type="javax.sql.DataSource" auth="Container" name="jdbc/sql"/>
<ResourceParams name="jdbc/sql">
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@10.147.20.14:1521:mis</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>gzxt</value>
</parameter>
</ResourceParams>
</Context>
2.:\Tomcat 5.0\conf\server.xml这个配置文件里.加入下面这句话:
<ResourceLink name="jdbc/sql" type="javax.sql.DataSource" global="jdbc/sql"/>
3.用JBuilder在com.db包路劲中,写一个java文件..名为DbConnection::(只写点关键的,其他都略去)
String strDriver = "oracle.jdbc.driver.OracleDriver";
String strUrl =
"jdbc:oracle:thin:@10.147.20.14:1521:mis";
String strUser = "gzxt";
String strPwd = "gzxt"; public DbConnection()
{
if(ds == null)
{
try
{
initCtx=new InitialContext();
if(initCtx==null)
throw new Exception("initialize the Context failed");
ds=(DataSource)initCtx.lookup("java:comp/env/jdbc/sql");
System.out.println(ds.toString()); }
catch (Exception ex)
{
ex.printStackTrace();
initCtx = null;
}
}
} private synchronized Connection getConnection()
{
try
{
System.out.println("Start getConnection=" + conn );
if(conn == null || conn.isClosed())
conn = ds.getConnection();
System.out.println("Got Connection=" + conn );
}
catch (Exception ex)
{
ex.printStackTrace();
return null;
}
return conn;
}
public synchronized ResultSet executeQuery(String sql){.......}
将这个java文件编译通过,取出DbConnection.class文件,放在D:\Tomcat 5.0\webapps\scm\WEB-INF\classes\com\db下...
4:然后在testconn.jsp业面中测试连接:(只写点关键的,其他都略去)
<%@page import="com.db.DbConnection"%>
<body>
<%
DbConnection db = new DbConnection();
ResultSet rs = db.executeQuery("select * from gzxt.zgkl");
try{
while (rs.next()) {
out.println(rs.getString("ZGXM"));
rs.close();
break;
}
}
catch (Exception e) {
System.out.println(e);
}
%>
</body>
5.语法上都米问题的.但就是提示数据库米连接上:
HTTP Status 500 -
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)root cause java.lang.NullPointerException
....................(省略6行出错代码)
note The full stack trace of the root cause is available in the Tomcat logs.
请高手帮偶看看为什么.....
谢谢了!
使用的是Tomcat 5.0..在D:\Tomcat 5.0\webapps\scm下(scm是这个项目名称)
1.一个scm.xml,,内容如下:
<Context docBase="/scm" path="/scm" workDir="work\Catalina\localhost\scm" debug="10"> <Resource type="javax.sql.DataSource" auth="Container" name="jdbc/sql"/>
<ResourceParams name="jdbc/sql">
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@10.147.20.14:1521:mis</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>gzxt</value>
</parameter>
</ResourceParams>
</Context>
2.:\Tomcat 5.0\conf\server.xml这个配置文件里.加入下面这句话:
<ResourceLink name="jdbc/sql" type="javax.sql.DataSource" global="jdbc/sql"/>
3.用JBuilder在com.db包路劲中,写一个java文件..名为DbConnection::(只写点关键的,其他都略去)
String strDriver = "oracle.jdbc.driver.OracleDriver";
String strUrl =
"jdbc:oracle:thin:@10.147.20.14:1521:mis";
String strUser = "gzxt";
String strPwd = "gzxt"; public DbConnection()
{
if(ds == null)
{
try
{
initCtx=new InitialContext();
if(initCtx==null)
throw new Exception("initialize the Context failed");
ds=(DataSource)initCtx.lookup("java:comp/env/jdbc/sql");
System.out.println(ds.toString()); }
catch (Exception ex)
{
ex.printStackTrace();
initCtx = null;
}
}
} private synchronized Connection getConnection()
{
try
{
System.out.println("Start getConnection=" + conn );
if(conn == null || conn.isClosed())
conn = ds.getConnection();
System.out.println("Got Connection=" + conn );
}
catch (Exception ex)
{
ex.printStackTrace();
return null;
}
return conn;
}
public synchronized ResultSet executeQuery(String sql){.......}
将这个java文件编译通过,取出DbConnection.class文件,放在D:\Tomcat 5.0\webapps\scm\WEB-INF\classes\com\db下...
4:然后在testconn.jsp业面中测试连接:(只写点关键的,其他都略去)
<%@page import="com.db.DbConnection"%>
<body>
<%
DbConnection db = new DbConnection();
ResultSet rs = db.executeQuery("select * from gzxt.zgkl");
try{
while (rs.next()) {
out.println(rs.getString("ZGXM"));
rs.close();
break;
}
}
catch (Exception e) {
System.out.println(e);
}
%>
</body>
5.语法上都米问题的.但就是提示数据库米连接上:
HTTP Status 500 -
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)root cause java.lang.NullPointerException
....................(省略6行出错代码)
note The full stack trace of the root cause is available in the Tomcat logs.
请高手帮偶看看为什么.....
谢谢了!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货