Question

Spring 配置Ibatis 的问题.

在main方法里面,可以通过ApplicationContext 运行正常,可以加载
<bean id="propertyConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location"><!-- configLocation,location -->
<value>classpath:/db.cfg.properties</value>
</property>
</bean>

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>classpath:/sqlMapConfig.xml</value>
</property>
<property name="dataSource" ref="dataSource" />
</bean>
可以正常使用,往数据库里面添加数据,查询都行... 说明applicationContext.xml + ibaits基本没有问题...

但是..
我用Tomcat启动服务的时候,就会报错,报错的内容是说
2011-11-27 13:01:51,593 ERROR: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is java.io.FileNotFoundException: class path resource [sqlMapConfig.xml] cannot be opened because it does not exist
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at
applicationContext.xml 大概内容如下

<bean id="propertyConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location"><!-- configLocation,location -->
<value>classpath:db.cfg.properties</value>
</property>
</bean>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>${jdbc.driver}</value>
</property>
<property name="url">
<value>${jdbc.url}</value>
</property>
<property name="username">
<value>${jdbc.username}</value>
</property>
<property name="password">
<value>${jdbc.password}</value>
</property>
</bean>

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>classpath:sqlMapConfig.xml</value>
</property>
<property name="dataSource" ref="dataSource" />
</bean>

Answer 1

classpath:/sqlMapConfig.xml配置有误。
sqlMapConfig.xml文件在什么目录？

追问

和 applicationContext.xml db.cfg.properties 一样, 都在src 下面.

追答

把这俩文件的配置改成这样试试：
classpath:db.cfg.properties
classpath:sqlMapConfig.xml

追问

各种路径都试过,没用...我在想是不是,奇怪的是 db.cfg.properties 解析没有问题,每次都是报的sqlMapConfig.xml打不开 文件格式都改过了

main 方法可以访问, 加到Tomcat里面服务启动不了,有怀疑过是不是web.xml有问题,但是db.cfg.properties 解析没有问题

追答

到tomcat的webapps目录找到你部署的项目，看看sqlMapConfig.xml怎么回事。

追问

\webapps\guoshu\WEB-INF\classes\SqlMapConfig.xml
没有问题呢
呃..问题发现了,SqlMapConfig 在Tomcat加载的时候,大小写敏感... 问题解决了...谢谢

Answer 2

大岁数大