mysql 1117_DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC:SWZCYJS

最新推荐文章于 2021-09-13 08:52:01 发布
最新推荐文章于 2021-09-13 08:52:01 发布
阅读量639 收藏
点赞数
文章标签： mysql 1117
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35025310/article/details/113587971
版权

DBCP borrowObject failed: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

2013-08-27 11:31:43 ERROR context.ContextLoader (ContextLoader.java:211) - Context initialization failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/hibernate-context.xml]: Initialization of bean failed; nested exception is org.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

org.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:722)

at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:108)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:871)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:797)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1091)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:396)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)

at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190)

at org.springframework.web.context.ContextLoaderServlet.init(ContextLoaderServlet.java:83)

at javax.servlet.GenericServlet.init(GenericServlet.java:212)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

at com.ibm.db2.jcc.c.p.a(p.java:2663)

at com.ibm.db2.jcc.b.eb.q(eb.java:696)

at com.ibm.db2.jcc.b.eb.p(eb.java:572)

at com.ibm.db2.jcc.b.eb.l(eb.java:393)

at com.ibm.db2.jcc.b.eb.d(eb.java:142)

at com.ibm.db2.jcc.b.b.lc(b.java:1274)

at com.ibm.db2.jcc.b.b.b(b.java:1198)

at com.ibm.db2.jcc.b.b.s(b.java:926)

at com.ibm.db2.jcc.b.b.b(b.java:607)

at com.ibm.db2.jcc.b.b.a(b.java:593)

at com.ibm.db2.jcc.b.b.(b.java:263)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)

... 48 more

2013-8-27 11:31:43 org.apache.catalina.core.ApplicationContext log

严重: StandardWrapper.Throwable

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/hibernate-context.xml]: Initialization of bean failed; nested exception is org.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

org.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:722)

at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:108)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:871)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:797)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1091)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:396)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)

at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190)

at org.springframework.web.context.ContextLoaderServlet.init(ContextLoaderServlet.java:83)

at javax.servlet.GenericServlet.init(GenericServlet.java:212)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

at com.ibm.db2.jcc.c.p.a(p.java:2663)

at com.ibm.db2.jcc.b.eb.q(eb.java:696)

at com.ibm.db2.jcc.b.eb.p(eb.java:572)

at com.ibm.db2.jcc.b.eb.l(eb.java:393)

at com.ibm.db2.jcc.b.eb.d(eb.java:142)

at com.ibm.db2.jcc.b.b.lc(b.java:1274)

at com.ibm.db2.jcc.b.b.b(b.java:1198)

at com.ibm.db2.jcc.b.b.s(b.java:926)

at com.ibm.db2.jcc.b.b.b(b.java:607)

at com.ibm.db2.jcc.b.b.a(b.java:593)

at com.ibm.db2.jcc.b.b.(b.java:263)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)

... 48 more

2013-8-27 11:31:43 org.apache.catalina.core.StandardContext loadOnStartup

严重: Servlet  threw load() exception

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

at com.ibm.db2.jcc.c.p.a(p.java:2663)

at com.ibm.db2.jcc.b.eb.q(eb.java:696)

at com.ibm.db2.jcc.b.eb.p(eb.java:572)

at com.ibm.db2.jcc.b.eb.l(eb.java:393)

at com.ibm.db2.jcc.b.eb.d(eb.java:142)

at com.ibm.db2.jcc.b.b.lc(b.java:1274)

at com.ibm.db2.jcc.b.b.b(b.java:1198)

at com.ibm.db2.jcc.b.b.s(b.java:926)

at com.ibm.db2.jcc.b.b.b(b.java:607)

at com.ibm.db2.jcc.b.b.a(b.java:593)

at com.ibm.db2.jcc.b.b.(b.java:263)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:722)

at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:108)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:871)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:797)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1091)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:396)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)

at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190)

at org.springframework.web.context.ContextLoaderServlet.init(ContextLoaderServlet.java:83)

at javax.servlet.GenericServlet.init(GenericServlet.java:212)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

InitPropertiesServlet.init---属性文件初始化null

2013-08-27 11:31:44 ERROR impl.DefaultCreatorManager (CommonsLoggingOutput.java:83) - Error loading class for creator 'SpringCreator[content]'.

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/hibernate-context.xml]: Initialization of bean failed; nested exception is org.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

org.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:722)

at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:108)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:871)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:797)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1091)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:396)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)

at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190)

at org.springframework.web.context.ContextLoaderServlet.init(ContextLoaderServlet.java:83)

at javax.servlet.GenericServlet.init(GenericServlet.java:212)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS

at com.ibm.db2.jcc.c.p.a(p.java:2663)

at com.ibm.db2.jcc.b.eb.q(eb.java:696)

at com.ibm.db2.jcc.b.eb.p(eb.java:572)

at com.ibm.db2.jcc.b.eb.l(eb.java:393)

at com.ibm.db2.jcc.b.eb.d(eb.java:142)

at com.ibm.db2.jcc.b.b.lc(b.java:1274)

at com.ibm.db2.jcc.b.b.b(b.java:1198)

at com.ibm.db2.jcc.b.b.s(b.java:926)

at com.ibm.db2.jcc.b.b.b(b.java:607)

at com.ibm.db2.jcc.b.b.a(b.java:593)

at com.ibm.db2.jcc.b.b.(b.java:263)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)

... 48 more

问题补充：#####################################\u8bf7\u9009\u62e9\u6570\u636e\u5e93################################################

##################################### MySQL######################################################

#hibernate.dialect org.hibernate.dialect.MySQLDialect

#hibernate.connection.driver_class com.mysql.jdbc.Driver

#hibernate.connection.url jdbc:mysql://localhost:3306/sxgov?useUnicode=true&characterEncoding=GBK

#hibernate.connection.username root

#hibernate.connection.password 123456

#################################### Db2 #######################################################

hibernate.dialect org.hibernate.dialect.DB2Dialect

hibernate.connection.driver_class com.ibm.db2.jcc.DB2Driver

##hibernate.connection.url jdbc:db2://10.2.64.219:50000/EGOV_POT

hibernate.connection.url jdbc\:db2\://192.168.27.71\:50000/swzcyjs

hibernate.connection.username db2admin

hibernate.connection.password db2admin

#################################Windows Setting Path Begin#############################################

#.\u8bbe\u7f6e\u670d\u52a1\u5668\u8def\u5f84

#String.WebServer_dir=C:/Program Files/IBM/WebSphere/AppServer/profiles/AppSrv01/installedApps/xiang-pvw311ezlNode01Cell/ccmcmsgn.war.ear/ccmcmsgn.war/

String.WebServer_dir=D:/Program Files/Tomcat 6.0/webapps/ROOT/

#String.WebServer_dir=D:/Program Files/IBM/WebSphere/AppServer/profiles/AppSrv01/installedApps/webNode01Cell/ccmcmsgn_war.ear/ccmcmsgn.war/

#.\u8bbe\u7f6e\u56fe\u7247\u7684\u4e0a\u4f20\u8def\u5f84

String.PIC_UPLOAD_PATH=D:/Program Files/Tomcat 6.0/webapps/ROOT/uploadfile/images/

#.\u8bbe\u7f6e\u670d\u52a1\u5668\u8bbf\u95ee\u57df\u540d\u53ca\u7aef\u53e3.#!.\u6682\u65f6\u4e0d\u8003\u8651

String.Domain_URL=

#.\u5b9a\u4e49\u5e74\u6708\u65e5\u65e5\u671f\u683c\u5f0f

String.DATE_FORMAT_YMD=yyyy-MM-dd

#.\u5b9a\u4e49\u5e74\u6708\u65e5\u65f6\u5206\u79d2\u65e5\u671f\u683c\u5f0f

String.DATE_FORMAT_YMDHMS=yyyy-MM-dd HH:mm:ss

#.\u5b9a\u4e49\u8d27\u5e01\u8f6c\u6362\u683c\u5f0f

String.MONEY_FORMAT=#,###,###,###.00

#.\u8bbe\u7f6e\u6839\u7ad9\u70b9\u8def\u5f84

String.SITE_ROOT=/

#.\u8bbe\u7f6e\u670d\u52a1\u5668\u56fe\u7247\u6d4f\u89c8\uff08\u76f8\u5bf9\uff09\u8def\u5f84

String.PIC_IMAGES_PATH=/uploadfile/images

#.\u8bbe\u7f6e\u6bcf\u4e00\u9875\u663e\u793a\u7684\u5927\u5c0f

int.PAGE_SIZE=20

#.\u5b9a\u4e49\u9996\u9875\u90e8\u95e8\u680f\u76ee\u5217\u6570

int.indexcoluncount=2

#.\u5b9a\u4e49\u9996\u9875\u90e8\u95e8\u680f\u76ee\u5217\u6570

int.icolumnpagesize = 9

#.\u5b9a\u4e49\u7ad9\u70b9\u5217\u8868\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.iwebsitepagesize=9

#.\u5b9a\u4e49\u5185\u5bb9\u5217\u8868\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.icontentpagesize=20

#.\u5b9a\u4e49\u5185\u5bb9\u5217\u8868\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.imediacenterpagesize=9

#.\u5b9a\u4e49\u5a92\u4f53\u5217\u8868\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.icontenttypepagesize=9

#.\u5b9a\u4e49\u6a21\u677f\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.itemplatepagesize=9

#.\u5b9a\u4e49\u5df2\u53d1\u5e03\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.ialreadypagesize=9

#.\u5b9a\u4e49\u7528\u6237\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.icmsuserpagesize=9

#.\u5b9a\u4e49\u89d2\u8272\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.irolepagesize=9

#.\u5b9a\u4e49\u5e10\u6237\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.iaccountpagesize=9

#.\u5b9a\u4e49\u529f\u80fd\u9879\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.ifucdefinepagesize=9

#.\u5b9a\u4e49\u90e8\u95e8\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.ideptmentpagesize=9

#.\u5b9a\u4e49\u5ba1\u6838\u3001\u53d1\u5e03\u3001\u672a\u53d1\u5e03\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.ipublishpagesize=9

#.\u5b9a\u4e49\u6279\u91cf\u53d1\u5e03\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.ibatchpublishpagesize=19

#.\u5b9a\u4e49\u8fdc\u7a0b\u6293\u53d6\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.iromotepagesize=9

#..\u5b9a\u4e49\u5728\u7ebf\u7edf\u8ba1\u7684\u7cfb\u6570

int.Stat_Coefficient=1

#.\u5b9a\u4e49\u7ad9\u70b9\u4e0b\u6700\u65b0\u5185\u5bb9\u7684\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.iwebsitenearcontentpagesize=10

#.\u5b9a\u4e49\u5168\u6587\u68c0\u7d22\u7ed3\u679c\u96c6\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.PER_PAGE=15

#.\u5b9a\u4e49\u5185\u5bb9\u5217\u8868\uff0c\u6bcf\u4e00\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570

int.LIST_PAGE=15

#.\u5b9a\u4e49\u83dc\u5355\u9875\uff08left.[\u6700\u65b0\u56fe\u6587]\u8bb0\u5f55\u6570

int.MENU_LEFT_NUM=3

#.\u5b9a\u4e49\u65b0\u95fb\u7cfb\u7edf\u53d1\u5e03\u540e\u6709\u6548\u5929\u6570

int.PUB_CONT_DNUM=3

#.\u5b9a\u4e49\u83dc\u5355\u9875\uff08left [\u6700\u65b0\u56fe\u6587]\u8bb0\u5f55\u6570

int.SHORTCUT_MAIN_CONT_NUM = 6

#.\u5b9a\u4e49\u7cfb\u7edf\u9ed8\u8ba4\u7684\u7ad9\u70b9\u6d41\u7a0b

int.CONTENTFLOWDEFINEID = 1

#.\u5b9a\u4e49\u680f\u76ee\u4e0b\u9ed8\u8ba4\u7684\u5185\u5bb9\u6570

int.COLUMN_CONTNUM = 6

#.\u5b9a\u4e49\u7f51\u4e0a\u6295\u7968\u7684\u6743\u503c

int.VOTE_POWER = 1

#.\u8bbe\u7f6e\u83b7\u5f97\u5929\u6c14\u9884\u62a5\u7684\u7f51\u7ad9URL

String.WEATHER_URL = http://weather.news.qq.com/inc/07_dc79.htm

#.\u5b9a\u4e49\u6570\u636e\u5e93\u7c7b\u578b\u8fdb\u884c\u65f6\u95f4\u8fd4\u56de\u7684\u5b57\u7b26\u4e32\u5904\u7406 1\u3001\u4ee3\u8868oracle\u6570\u636e\u5e93; 2\u3001\u4ee3\u8868Mysql\u6570\u636e\u5e93;3\u3001\u4ee3\u8868DB2\u6570\u636e\u5e93

int.DATABASE_FLAG = 3

#.\u5b9a\u4e49\u9ed8\u8ba4\u53d1\u5e03\u7684\u65f6\u95f4\u957f\u5ea6/\u5355\u4f4d\u4e3a\u5929

int.PUBLISH_DATELENGTH=36000

#.\u5b9a\u4e49\u5e94\u7528\u670d\u52a1\u5668\u7c7b\u578b\u8fdb\u884c\u5b57\u7b26\u4e32\u5b57\u7b26\u8f6c\u7801\u7b49\u7684\u64cd\u4f5c\u5904\u7406 1\u3001\u4ee3\u8868tomcat\u670d\u52a1\u5668; 2\u3001\u4ee3\u8868websphere\u670d\u52a1\u5668;3\u3001\u4ee3\u8868weblogic\u670d\u52a1\u5668

int.CONTAINER_FLAG = 1

#.\u5b9a\u4e49\u5185\u5bb9\u6392\u5e8f\u7684\u65b9\u5f0f asc;desc\u5347\u5e8f/\u964d\u5e8f

String.TAXIS = "desc";

#$.定义子站点的ip，用于上传文件等

String.WASIPS = 192.168.4.201-192.168.4.202-192.168.4.203

#.定义子站点的路径,用于文件上传

String.WASDIRS = C\:\\test\\-D\:\\test\\

input.encoding=gbk

output.encoding=gbk

2013年8月27日 11:41

uu老魏
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
解决因数据库返回1117或21等错误导致无法备份，tomcat无法正常启动的问题
12-14
确保没有其他链接连接到当前错误数据库后，重启SqlServer服务 然后执行 use master declare @databasename varchar(255) set @databasename='\u6570\u636e\u5e93\u540d' exec sp_dboption @databasename, N'single', N'true'--将目标数据库置为单用户状态 dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS) dbcc checkdb(@databasename,REPAIR_REBUILD) exec sp_dboption @databasename
DB2的SQL、sqlcode、sqlstate错误码中文大全
03-02
因此，本文旨在整理 DB2 的 SQL、sqlcode、sqlstate 错误码大全，提供详细的错误码说明和用户响应方法，帮助用户快速解决问题，提高工作效率。 SQL0000 - SQL0099 在 DB2 中，SQL0000 - SQL0099 错误码系列主要...
DB2数据库SQL1117N
jingemperor的博客
09-13 819
DB2数据库SQL1117N SQL1117N 因为处于 ROLL-FORWARD PENDING 状态，所以不能连接或激活数据库 执行命令db2 connect to cydb 出现SQL1117N 因为处于 ROLL-FORWARD PENDING 状态，所以不能连接或激活数据库"CYDB"。 需要执行命令： D:>db2 rollforward db cydb to end of logs and stop 前滚状态 输入数据库别名
db2启动错误 SQLSTATE=57019
热门推荐
::: 移动互联网时代开发者 :::
08-22 1万+
想启动DB2数据库，就到DB2命令行中运行db2start，结果出现如下错误：未发出启动数据库管理器的命令。SQLSTATE=57019。想了半天，这几天除了修改一次DB2登陆密码以外，没在DB2上做其它的事情。打开控制面板中的服务，看到DB2的某些服务并没有启动。看来问题就出在这里了。查看其属性，将登陆中的密码修改，然后重新启动。问题解决。
mysql 1117错误_MySQL InnoDB:在文件操作中操作系统错误号1117
weixin_35756690的博客
01-19 700
适用于：MySQL 服务器版本4.0到5.7 [发行版4.0到5.7]本文信息适用于所有平台。目标问题：InnoDB将像这样的错误打印到错误日志后，mysqld.exe崩溃：130820 13:37:44 InnoDB: Operating system error number 1117 in a file operation.InnoDB: Some operating system erro...
详解DB2 sqlstate 57016 SQLCODE=-668 原因码 "7"错误的快速解决办法
09-10
在使用DB2过程中，可能会遇到各种错误代码，其中SQLSTATE 57016与SQLCODE -668，特别是原因码“7”，是一个常见的错误，通常表示在尝试执行数据库操作时遇到了权限问题。本篇文章将深入探讨这个错误的原因，并提供...
db2_sqlcode.rar_db2_db2 sql
09-19
"db2_sqlcode.rar_db2_db2 sql"这个标题暗示了我们正在处理一个与DB2数据库相关的压缩文件，特别是关于SQL错误代码的信息。这个压缩包包含了一个名为"db2_sqlcode.pdf"的PDF文档，我们可以从中了解到DB2在执行SQL...
详解DB2 sqlstate 57016 SQLCODE=-668 原因码 “7”错误的快速解决办法
01-21
以上所述是小编给大家介绍的详解DB2 sqlstate 57016 SQLCODE=-668 原因码 “7”错误的快速解决办法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对软件开发网网站...
db2 错误码 大全
12-04
在DB2中，错误码通常由SQLCODE和SQLSTATE两部分组成： - **SQLCODE**：是一个整数值，用来表示错误或警告的状态。正数表示警告，负数表示错误。 - **SQLSTATE**：是一个五字符的字符串，用来提供关于错误或警告的更...
DB2 SQL1117N ROLL-FORWARD PENDING 状态解决办法
weixin_42076211的博客
06-07 6351
执行命令db2 connect to databasename,出现SQL1117N  因为数据库处于 ROLL-FORWARD PENDING 状态，所以不能连接或激活数据库。执行如下命令：db2 rollforward db databasename stopdb2 rollforward db databasename to end of logs再次执行连接数据库命令db2 connect...
com.ibm.db2.jcc.c.SqlException: DB2 SQL error
bangsen
02-03 706
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ;;?, ?, ?, ?, ?, ?, ?);END-OF-STATEMENT 在做JDBC编程的时候遇到了上面的错误， 下面是SQL语句： public static String sqlInsertMer...
mysql 1035_db2删除数据库SQL1035N 数据库当前正在使用。 SQLSTATE=57019
weixin_33148621的博客
02-01 1372
[ DB2数据库使用 DML(Data Manipulation Language commands)数据操纵语言 DDL(Data Definition Language commands) 数据定义语言[db2inst1@db01 ~]$ db2 drop db cmsSQL1035N 数据库当前正在使用。 SQLS...
[数据库][57019][错误]数据库的57019错误
zscomehuyue的专栏
11-05 877
[数据库][57019][错误]数据库的57019错误 7. 01. 查询数据库的日志，看到以下的错误： 2008-11-28-02.11.02.695011+480 E1354769G715 LEVEL: Severe PID : 32594 TID : 3009411984 PROC : db2acd INSTANCE: ...
DB2 SQL Error: SQLCODE=-7, SQLSTATE=42601
宁静轩
04-15 1万+
db2 报错之 DB2 SQL Error: SQLCODE=-7, SQLSTATE=42601 记录一个困扰了两天的问题，使用ssm框架搭配 db2 数据库，一直在插入数据时报错，报错内容如下： Exception in thread “main” org.springframework.jdbc.BadSqlGrammarException: Error updating databas...
microsoft WINDOWS 系统错误代码 [收藏]
yaasshole
09-23 2156
MS Windows Error Messages Code Error Message 0 操作成功完成。 1 功能错误。 2 系统找不到指定的文件。 3 系统找不到指定的路径。 4 系统无法打开文件。 5 拒绝访问。 6 句柄无效。 7 存储控制块被损坏。 8 存储空间不足，无法处理此命令。 9 存储控制块地址无效。 10 环境错误。 11 试图加载格式错误的程序。 12 访问码无效。 13 ...
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002
binglimeng8155的博客
10-08 1531
在项目支持时遇到db2的错误：   com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031   在网上查了下，大概有以下几个方面的原因：       1.程序里有很多游标没有关闭.一般情况下，都是...
mysql 1117错误,MySQL中遇到的几种报错及其解决方法
weixin_29311017的博客
03-17 1652
MySQL中遇到的几种报错及其解决方法1.[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''xxx'' at line 1解决方法：将所有的“ '' ”...
SQL Server错误代码及解释（一）
weixin_30412577的博客
01-19 711
0 操作成功完成。1 功能错误。2 系统找不到指定的文件。3 系统找不到指定的路径。4 系统无法打开文件。5 拒绝访问。6 句柄无效。7 存储控制块被损坏。8 存储空间不足，无法处理此命令。9 存储控制块地址无效。10 环境错误。11 试图加载格式错误的程序。12 访问码无效。13 数据无效。14 存储器不足，无法完成此操作。15 系统找不到指定的驱动器。16 无法...
db2 sql error:sqlcode=-289
最新发布
07-13
DB2 SQL 错误代码 -289 通常表示数据库事务处理中遇到了一个问题。这个错误一般与数据库锁定（Locking）有关，可能是由于并发操作导致的死锁（Deadlock）、资源已被占用而无法立即获取、或者是事务等待时间超时等...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值