将Groovy应用程序连接到SQL Server Express [英] Connecting a groovy application to SQL server Express

问题描述

我按照下面的教程，但是必须有一些重要的步骤，我没有知识，我们正在假设。

http://padcom13.blogspot.co.uk/2011/01/setting-up-sql-server-2008-express-to.html

以下是我的datasource.groovy中的设置

  username =sa
密码=
 url =jdbc：sqlserver：// localhost：1433; databaseName = Sandpit
 driverClassName =com.microsoft.sqlserver.jdbc.SQLServerDriver
 dialect =org .hibernate.dialect.SQLServerDialect
  

及以下是运行应用程序命令弹出的错误

  ERROR context.GrailsContextLoader  - 执行bootstraps时出错：
创建名为'transactionManagerPostProcessor'的bean时出错：
初始化bean失败;嵌套异常是org.springframework.beans.factory.BeanCreationException：
创建名为'transactionManager'的bean时出错：
在设置bean属性'sessionFactory'时无法解析对bean'sessionFactory'的引用。 
嵌套的异常是org.springframework.beans.factory.BeanCreationException：
创建名为'sessionFactory'的bean时出错：
设置bean属性'lobHandler'时无法解析对bean'lobHandlerDetector'的引用; 
嵌套的异常是org.springframework.beans.factory.BeanCreationException：
创建名为'lobHandlerDetector'的Bean时出错：调用init方法失败; 
嵌套的异常是org.springframework.jdbc.support.MetaDataAccessException：
提取DatabaseMetaData出错;嵌套异常是org.apache.commons.dbcp.SQLNestedException：
无法加载JDBC驱动程序类'com.microsoft.sqlserver.jdbc.SQLServerDriver'
消息：创建名为'transactionManagerPostProcessor'的bean时出错：
 bean初始化失败;嵌套异常是org.springframework.beans.factory.BeanCreationException：
创建名为'transactionManager'的bean时出错：无法在设置bean属性'sessionFactory'时解析对bean'sessionFactory'
的引用。嵌套异常是
 org.springframework.beans.factory.BeanCreationException：创建名为'sessionFactory'的bean时出错：
设置bean属性'lobHandler'时无法解析对bean'lobHandlerDetector'的引用; 
嵌套异常是org.springframework.beans.factory.BeanCreationException：
创建名为'lobHandlerDetector'的bean时出错：
调用init方法失败;嵌套异常是
 org.springframework.jdbc.support.MetaDataAccessException：
提取DatabaseMetaData时出错;嵌套异常是
 org.apache.commons.dbcp.SQLNestedException：
无法加载JDBC驱动程序类'com.microsoft.sqlserver.jdbc.SQLServerDriver'
  

在没有看到我的应用程序运行的情况下，一直工作了几天.....有什么建议？

解决方案

根本原因是无法加载JDBC驱动程序类com.microsoft.sqlserver.jdbc.SQLServerDriver '

这是因为您的驱动程序在类路径中缺失。在SQL Server的情况下，您需要将jar复制到lib文件夹中。

在其他情况下，例如MySQL，您可以声明为maven依赖项。 b $ b

I was following the tutorial below but there must be some significant steps where knowledge, that I don't have, is being assumed.

http://padcom13.blogspot.co.uk/2011/01/setting-up-sql-server-2008-express-to.html

below is the setup in my datasource.groovy

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

and below is the error popping up on run app command

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'

Been working on this a couple of days without seeing my app run..... any advice?

解决方案

The root cause is Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

That's because your driver is missing in the classpath. In the case of SQL Server you need to copy the jar to the lib folder.

In other cases like MySQL you can declare as a maven dependency.

这篇关于将Groovy应用程序连接到SQL Server Express的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！