切换数据库平台到Sql Server 2005，失败

victor_mamj · 发表于 2011-12-23 10:23:19

本帖最后由 shary 于 2011-12-27 13:20 编辑

配置文件：

报错信息：
java.lang.Exception: org.hibernate.exception.GenericJDBCException: Cannot open connection
at cn.myapps.base.dao.PersistenceUtils.beginTransaction(PersistenceUtils.java:118)
at cn.myapps.base.web.listener.StartupListener.contextInitialized(StartupListener.java:53)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4765)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5260)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:842)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:958)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1599)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:424)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)

at cn.myapps.base.dao.HibernateBaseDAO.beginTransaction(HibernateBaseDAO.java:733)
at cn.myapps.base.dao.PersistenceUtils.beginTransaction(PersistenceUtils.java:116)
... 15 more
Caused by: java.sql.SQLException: 无法打开登录所请求的数据库 "obpm"。登录失败。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:602)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:344)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:421)
... 21 more
10:08:03,656 INFO AutoAuditJobManager:82 - ********************* Auto Audit Job Manager Init Jobs Start ********************
10:08:04,109 ERROR AutoAuditJobManager:127 - Auto Audit Job Manager Init Jobs Error:
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:424)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1538)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at cn.myapps.base.dao.HibernateBaseDAO.getData(HibernateBaseDAO.java:83)
at cn.myapps.core.superuser.dao.HibernateSuperUserDAO.findByLoginno(HibernateSuperUserDAO.java:93)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean.doViewByLoginno(SuperUserProcessBean.java:243)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$5ffc2bbd.CGLIB$doViewByLoginno$17(<generated>)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$5ffc2bbd$$FastClassByCGLIB$$f7e15e52.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:182)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$5ffc2bbd.doViewByLoginno(<generated>)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean.getDefaultAdmin(SuperUserProcessBean.java:239)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$5ffc2bbd.CGLIB$getDefaultAdmin$9(<generated>)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$5ffc2bbd$$FastClassByCGLIB$$f7e15e52.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:182)
at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$5ffc2bbd.getDefaultAdmin(<generated>)
at cn.myapps.core.workflow.engine.AutoAuditJobManager.initJobs(AutoAuditJobManager.java:88)
at cn.myapps.base.web.listener.StartupListener.contextInitialized(StartupListener.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4765)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5260)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:842)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:958)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1599)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: 无法打开登录所请求的数据库 "obpm"。登录失败。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:602)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:344)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:421)
... 43 more

shary · 发表于 2011-12-23 10:32:31

您好，您的错误显示无法打开登录所请求的数据库 "obpm"。登录失败。请问您的数据库中存在数据库名为obpm的数据库吗？确认您的sqlserver服务是否启动。

victor_mamj · 发表于 2011-12-23 10:34:36

需要建这样的数据库？配置手册里面没说！

shary · 发表于 2011-12-23 10:44:35

额。需要的。我们程序不会帮您在数据库中建库。只是会通过Hibernate连接您配置的数据库生成一些系统表。

		自动登录	找回密码
密码			注册成为天翎用户

切换数据库平台到Sql Server 2005，失败

本帖子中包含更多资源