免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 程序设计 › Java › [原创]请教spring2+ibatis2找不到数据源
最近访问板块 发新帖
查看: 2325 | 回复: 1
打印 上一主题 下一主题

[原创]请教spring2+ibatis2找不到数据源 [复制链接]

ttl_web

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2007-09-26 00:09 |只看该作者 |倒序浏览
http://localhost:8888/spring/db.do

错误提示

  2. HTTP Status 500 -

  4. --------------------------------------------------------------------------------

  6. type Exception report

  8. message

  10. description The server encountered an internal error () that prevented it from fulfilling this request.

  12. exception

  14. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException
  15.         org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:487)
  16.         org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:430)
  17.         javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
  18.         javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  19.         org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
  20.         org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)


  23. root cause

  25. java.lang.NullPointerException
  26.         lsj.EmpSqlMapDao.getAllEmp(Unknown Source)
  27.         lsj.MyDb.handleRequest(Unknown Source)
  28.         org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
  29.         org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:857)
  30.         org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:792)
  31.         org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:475)
  32.         org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:430)
  33.         javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
  34.         javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  35.         org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
  36.         org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)


  39. note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.


  42. --------------------------------------------------------------------------------

  44. Apache Tomcat/5.5.23
复制代码


dispatcher-servlet.xml

  2. <?xml version="1.0" encoding="UTF-8"?>
  3. <beans xmlns="http://www.springframework.org/schema/beans"
  4.         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5.         xsi:schemaLocation="
  6. [url]http://www.springframework.org/schema/beans[/url]
  7. [url]http://www.springframework.org/schema/beans/spring-beans-2.0.xsd[/url]
  8. ">

  10.         <bean id="viewResolve"
  11.                 class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  12.                 <property name="prefix" value="/jsp/" />
  13.                 <property name="suffix" value=".jsp" />
  14.         </bean>

  16.         <bean name="/hello.do" class="lsj.MyC">
  17.                 <property name="viewPage" value="hello" />
  18.         </bean>

  20.         <bean id="dataSource"
  21.                 class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  22.                 <property name="driverClassName"
  23.                         value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
  24.                 <property name="url"
  25.                         value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind" />
  26.                 <property name="username" value="sa" />
  27.                 <property name="password" value="" />
  28.         </bean>

  30.         <bean id="sqlMapClient"
  31.                 class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  32.                 <property name="configLocation"
  33.                         value="WEB-INF/classes/lsj/sql-map-config.xml" />
  34.                 <property name="dataSource" ref="dataSource" />
  35.         </bean>

  37.         <bean id="empDao" class="lsj.EmpSqlMapDao">
  38.                 <property name="sqlMapClient" ref="sqlMapClient"/>
  39.         </bean>

  41.         <bean name="/db.do" class="lsj.MyDb">
  42.                 <property name="viewPage" value="db" />
  43.         </bean>
  44.        
  45. </beans>
复制代码
ttl_web

论坛徽章:
0
2楼 [报告]
发表于 2007-09-26 02:43 |只看该作者

  2. package lsj;

  4. public class Emp {
  5.   private String EmployeeID,LastName,FirstName;

  7.   public String getEmployeeID() {
  8.     return EmployeeID;
  9.   }

  11.   public void setEmployeeID(String employeeID) {
  12.     EmployeeID = employeeID;
  13.   }

  15.   public String getLastName() {
  16.     return LastName;
  17.   }

  19.   public void setLastName(String lastName) {
  20.     LastName = lastName;
  21.   }

  23.   public String getFirstName() {
  24.     return FirstName;
  25.   }

  27.   public void setFirstName(String firstName) {
  28.     FirstName = firstName;
  29.   }
  30.   
  31. }
复制代码


  2. package lsj;

  4. import java.util.List;

  6. import lsj.Emp;

  8. public interface EmpDao {
  9.   public List<Emp> getAllEmp();
  10. }
复制代码


  2. package lsj;

  4. import java.sql.SQLException;
  5. import java.util.List;

  7. import org.springframework.dao.DataAccessException;

  9. import com.ibatis.sqlmap.client.SqlMapClient;

  11. public class EmpSqlMapDao implements EmpDao {

  13.   private SqlMapClient sqlMapClient;

  15.   public void setSqlMapClient(SqlMapClient sqlMapClient) {
  16.     this.sqlMapClient = sqlMapClient;
  17.   }

  19.   public List<Emp> getAllEmp() throws DataAccessException {
  20.     try {
  21.       return (List<Emp>) this.sqlMapClient.queryForList("getAllEmp");
  22.     } catch (SQLException se) {
  23.       se.toString();
  24.     }
  25.     return null;
  26.   }
  27. }
复制代码


  2. package lsj;

  4. import javax.servlet.http.HttpServletRequest;
  5. import javax.servlet.http.HttpServletResponse;

  7. import org.springframework.web.servlet.ModelAndView;
  8. import org.springframework.web.servlet.mvc.Controller;

  10. public class MyDb implements Controller {
  11.   private String viewPage;

  13.   public void setViewPage(String viewPage) {
  14.     this.viewPage = viewPage;
  15.   }

  17.   public ModelAndView handleRequest(HttpServletRequest arg0,
  18.       HttpServletResponse arg1) throws Exception {
  19.     ModelAndView modelAndView = new ModelAndView("db");
  20.     modelAndView.addObject("empDao", new EmpSqlMapDao().getAllEmp());
  21.     return modelAndView;
  22.   }

  24. }
复制代码


Emp.xml

  2. <?xml version="1.0" encoding="UTF-8" ?>

  4. <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
  5.     "http://ibatis.apache.org/dtd/sql-map-2.dtd">

  7. <sqlMap namespace="Emp">

  9.   <typeAlias alias="emp" type="lsj.Emp" />

  11.   <select id="getAllEmp" resultClass="emp">
  12.     SELECT EmployeeID, LastName, FirstName FROM Employees
  13.   </select>

  15. </sqlMap>
复制代码


sql-map-config.xml

  2. <?xml version="1.0" encoding="UTF-8" ?>

  4. <!DOCTYPE sqlMapConfig      
  5.     PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
  6.     "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

  8. <sqlMapConfig>

  10.   <sqlMap resource="lsj/Emp.xml" />

  12. </sqlMapConfig>
复制代码


db.jsp

  2. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
  3. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  4. <html>
  5. <head>
  6. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  7. <title></title>
  8. </head>

  10. <body>

  12. </body>
  13. </html>
复制代码
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP