Spring+hibernate 启动时未报错，但是数据库不能访问

0 0

Spring+hibernate 启动时未报错，但是数据库不能访问5

项目用了 Mevan,Spring Mvc,Hibernate, 开发环境 STS3.5.1(Eclipse Kepler SR2 4.3.2），jdk 1.7,tomcat 7

项目启动，tomcat没有报错，能够正常访问，正常的走通了controller->service->dao，在调用dao getJdbcTemplate().queryForList(sql)时，页面跳到了错误页，tomcat里没有报错！
我觉得问题是在Hibernate 配置那里，但不知道怎么解决
下面是代码和运行日志，详细的项目配置和pom.xml在附件里，兄弟们帮忙看看

代码如下
1.Controller
@Controller
@RequestMapping("/KpiQueryInterface")
public class KpiQueryContorller {
@Resource
KpiQueryService ts;

@RequestMapping("/Query1")
@ResponseBody
public Object auncherQuery(HttpServletRequest request, HttpSession session) {
System.out.println("@Controller Query1:");

HashMap hm=new HashMap();
String method=request.getParameter("method");
hm.put("Output", ts.getBackgroupdPics(method));
System.out.println("@Controller Query1:"+ method);
return hm;
}
}

2.service
@Service
public class KpiQueryService {
Logger logger = Logger.getLogger(this.getClass().getName());
@Resource
KpiQueryDao ld;

public ArrayList getBackgroupdPics(String method) {

String sql = "";
System.out.println("Service getBackgroupdPics:"+ method);
sql = "select count(*) from ecs.sts_task_record ";

return ld.queryKpi(sql);
}
}

3.dao
@Repository
public class KpiQueryDao extends SuperDao {

public ArrayList queryKpi(String sql) {
System.out.println("KpiQueryDao queryKpi:"+ sql);
ArrayList list= (ArrayList) this.getJdbcTemplate().queryForList(sql);
System.out.println("KpiQueryDao queryKpi end");
return list;
}
}

public class SuperDao extends JdbcDaoSupport {

@Resource(name = "dataSource")
public void setSessionFactoryOverride(DataSource dataSource) {
super.setDataSource(dataSource);
}
}

tomcat 启动和运行日志：

八月 04, 2014 1:35:39 下午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
八月 04, 2014 1:35:39 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
log4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
13:35:40.426 [localhost-startStop-1] INFO o.hibernate.cfg.annotations.Version - Hibernate Annotations 3.4.0.GA
13:35:40.487 [localhost-startStop-1] INFO o.h.annotations.common.Version - Hibernate Commons Annotations 3.1.0.GA
13:35:40.494 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Validator not present in classpath, ignoring event listener registration
13:35:40.496 [localhost-startStop-1] DEBUG o.h.c.s.HibernateSearchEventListenerRegister - Search not present in classpath, ignoring event listener registration.
13:35:40.496 [localhost-startStop-1] INFO o.h.c.s.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
13:35:40.496 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Execute first pass mapping processing
13:35:40.519 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Process hbm files
13:35:40.519 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Process annotated classes
13:35:40.519 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
13:35:40.520 [localhost-startStop-1] INFO o.h.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
八月 04, 2014 1:36:13 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring FrameworkServlet 'dispatcher'
13:36:13.372 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Validator not present in classpath, ignoring event listener registration
13:36:13.373 [localhost-startStop-1] DEBUG o.h.c.s.HibernateSearchEventListenerRegister - Search not present in classpath, ignoring event listener registration.
13:36:13.373 [localhost-startStop-1] INFO o.h.c.s.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
13:36:13.373 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Execute first pass mapping processing
13:36:13.373 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Process hbm files
13:36:13.373 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - Process annotated classes
13:36:13.373 [localhost-startStop-1] DEBUG o.h.cfg.AnnotationConfiguration - processing fk mappings (*ToOne and JoinedSubclass)
13:36:13.373 [localhost-startStop-1] INFO o.h.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
八月 04, 2014 1:36:45 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
八月 04, 2014 1:36:45 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
八月 04, 2014 1:36:45 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 68574 ms

@Controller Query1:
Service getBackgroupdPics:count
KpiQueryDao queryKpi:select count(*) from sts_task_record

Spring Hibernate

2014年8月04日 14:25

farness
26
0 0 2

WEB-INF.rar (6.2 KB)
下载次数: 3

pom.rar (1.1 KB)
下载次数: 2

4个答案按时间排序按投票排序

0 0

你用的是jdbcTemplate，还要有个配置：
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>

2014年8月06日 17:31

yongsky
260
0 0 19

添加评论

0 0

单元测试
直接写case测试，是否能调用数据库。如果不能，查看连接内容，账号密码权限，端口，数据库服务起了没。
如果都行，看看你返回的页面的路径有没有错，这些小错误都是喜欢用框架的人容易出错的地方，必要的类注入没有，等等。

另外，页面返回错误页面，没有错误代码吗？贴出来。
写程序的时候，就没有逐步测试下吗？写完数据库先看看能不能调用数据库，写完spring,看看能不能调用hibernate，都写完了才知道错误，肯定是写程序的时候不规范，出错了吧！

2014年8月05日 13:06