Resin 启动 Spring+Mybatis项目时报此错

Question

（此项目之前是在tomcat上运行，并且参考网上案例已对配置做出相应调整）
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [E:\workspace\Sa\Code\web\WEB-INF\classes\spring\applicationContext-ibatis3-dao.xml]: Invocation of init method failed; nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error building SqlSession.

The error may exist in SQL Mapper Configuration

Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: cannot create dialect instance by dialectClass:javacommon.SQLServerDialect2005

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1412)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:557)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at com.caucho.server.webapp.WebApp.start(WebApp.java:1866)
at com.caucho.server.deploy.DeployController.startImpl(DeployController.java:667)
at com.caucho.server.deploy.DeployController.restartImpl(DeployController.java:630)
at com.caucho.server.deploy.StartAutoRedeployAutoStrategy.alarm(StartAutoRedeployAutoStrategy.java:177)
at com.caucho.server.deploy.DeployController.handleAlarm(DeployController.java:789)
at com.caucho.util.Alarm.handleAlarm(Alarm.java:387)
at com.caucho.util.Alarm.run(Alarm.java:357)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)
at java.lang.Thread.run(Thread.java:619)

Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error building SqlSession.

The error may exist in SQL Mapper Configuration

Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: cannot create dialect instance by dialectClass:javacommon.SQLServerDialect2005

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:32)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:15)
at javacommon.SqlSessionFactoryFactoryBean.createSqlSessionFactory(SqlSessionFactoryFactoryBean.java:45)
at javacommon.SqlSessionFactoryFactoryBean.afterPropertiesSet(SqlSessionFactoryFactoryBean.java:39)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
... 22 more

Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: cannot create dialect instance by dialectClass:javacommon.SQLServerDialect2005
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:71)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:55)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:29)
... 27 more
Caused by: java.lang.RuntimeException: cannot create dialect instance by dialectClass:javacommon.SQLServerDialect2005
at cn.org.rapid_framework.ibatis3.plugin.OffsetLimitInterceptor.setProperties(OffsetLimitInterceptor.java:122)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.pluginElement(XMLConfigBuilder.java:100)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:62)
... 29 more
Caused by: java.lang.ClassNotFoundException: javacommon.SQLServerDialect2005
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at cn.org.rapid_framework.ibatis3.plugin.OffsetLimitInterceptor.setProperties(OffsetLimitInterceptor.java:120)
... 31 more

Answer 1

该回复引自免费微信小程序-皆我百晓生:

---

根据错误信息，可以看出问题出现在解析SQL Mapper配置文件时。具体错误是无法创建dialect实例，dialectClass为javacommon.SQLServerDialect2005。

可能的原因是缺少相关的类或配置文件。请确保以下几点：

1. 检查项目中是否存在名为javacommon.SQLServerDialect2005的类。如果不存在，请确认是否需要引入相关的依赖或配置文件。

2. 检查SQL Mapper配置文件中是否正确配置了dialectClass属性。确保该属性的值与实际的dialect类名一致。

3. 检查项目的类路径是否正确配置。确保相关的类和配置文件能够被正确加载。

如果以上步骤都没有解决问题，建议检查项目的依赖和配置是否与之前在Tomcat上运行的配置相同。可能需要对配置文件进行进一步调整或添加缺失的依赖。

如果问题仍然存在，请提供更多的项目配置信息和相关代码，以便更好地帮助您解决问题。