grails - 在 JDBC 设置之后尝试启动 Grails 时出错

Question

我有可能重用我现有的问题。
Connecting a groovy application to SQL server Express

但这似乎有点不同。这个问题是在配置测试应用程序时提出的，现在我正在做真实的事情，这是真正出错的时候。

如您所见，Jar 文件位于我的 lib 和类路径中



我的数据源配置如下(几乎是我的工作示例中的复制粘贴作业)

dataSource {
username = "sa"
password = "password"
url = "jdbc:sqlserver://localhost:1433;databaseName=TimeTracker"
driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
dialect = "org.hibernate.dialect.SQLServerDialect"

我在 grails run-app 上收到以下错误，任何建议都会张开双臂欢迎

Error 2013-01-27 16:09:06,772 [localhost-startStop-1] ERROR context.GrailsContextLoader  
- Error executing bootstraps: Error creating bean with name 'transactionManagerPostProcessor': 
Initialization of bean failed; nested exception is 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 
'transactionManager': Cannot resolve reference to bean 'sessionFactory' 
while setting bean property 'sessionFactory'; nested exception is 
org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'sessionFactory': 
Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 
'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'lobHandlerDetector': 
Invocation of init method failed; nested exception is 
org.springframework.jdbc.support.MetaDataAccessException: 
Error while extracting DatabaseMetaData; 
nested exception is org.apache.commons.dbcp.SQLNestedException: 
Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
Message: Error creating bean with name 'transactionManagerPostProcessor': 
Initialization of bean failed; nested exception is 
org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'transactionManager': 
Cannot resolve reference to bean 'sessionFactory' while setting bean property 
'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' 
while setting bean property 'lobHandler'; nested exception is 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 
'lobHandlerDetector': Invocation of init method failed; nested exception is 
org.springframework.jdbc.support.MetaDataAccessException: 
Error while extracting DatabaseMetaData; nested exception is 
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 
'com.microsoft.sqlserver.jdbc.SQLServerDriver'

Answer 1

做grails --refresh-dependencies compile再来一次就好了。

如果问题仍然存在，以下是需要仔细检查的附加信息:

检查路径中是否有空格。如果路径包含空格字符，Grails 就不能正常工作，尤其是在 Windows 上。

检查您的 Grails 安装，并确保它适用于简单的应用程序。

检查您的 Ivy 缓存( under ~/.grails/ 或 c:\<your home>\.grails )是否正常。如果没有，只需删除它，Grails 就会为您重新创建一个新的 ivy 缓存。

如果不。 1-3忍不住，删~/.grails或 c:\<your home>\.grails清理与 Grails 相关的所有内容，然后重新开始。