DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC:SWZCYJS

问题描述

DBCP borrowObject failed: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJS2013-08-27 11:31:43 ERROR context.ContextLoader (ContextLoader.java:211) - Context initialization failedorg.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: SWZCYJSorg.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJSat 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: SWZCYJSat 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.<init>(b.java:263)at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)... 48 more2013-8-27 11:31:43 org.apache.catalina.core.ApplicationContext log严重: StandardWrapper.Throwableorg.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: SWZCYJSorg.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJSat 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: SWZCYJSat 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.<init>(b.java:263)at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)... 48 more2013-8-27 11:31:43 org.apache.catalina.core.StandardContext loadOnStartup严重: Servlet threw load() exceptioncom.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJSat 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.<init>(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---属性文件初始化null2013-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: SWZCYJSorg.apache.commons.dbcp.DbcpException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC: SWZCYJSat 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: SWZCYJSat 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.<init>(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 问题补充:
解决方案二:

解决方案三:

解决方案四:

解决方案五:

解决方案六:

解决方案七:

解决方案八:

解决方案九:

解决方案十:

解决方案十一:

解决方案十二:

解决方案十三:
#u8bf7u9009u62e9u6570u636eu5e93
解决方案十四:

解决方案十五:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:
# 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&amp;characterEncoding=GBK#hibernate.connection.username root#hibernate.connection.password 123456
解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:
Db2
解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:
#hibernate.dialect org.hibernate.dialect.DB2Dialecthibernate.connection.driver_class com.ibm.db2.jcc.DB2Driver##hibernate.connection.url jdbc:db2://10.2.64.219:50000/EGOV_POThibernate.connection.url jdbc:db2://192.168.27.71:50000/swzcyjshibernate.connection.username db2adminhibernate.connection.password db2admin
解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:
Windows Setting Path Begin
解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:

解决方案:
#.u8bbeu7f6eu670du52a1u5668u8defu5f84#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/#.u8bbeu7f6eu56feu7247u7684u4e0au4f20u8defu5f84String.PIC_UPLOAD_PATH=D:/Program Files/Tomcat 6.0/webapps/ROOT/uploadfile/images/#.u8bbeu7f6eu670du52a1u5668u8bbfu95eeu57dfu540du53cau7aefu53e3.#!.u6682u65f6u4e0du8003u8651String.Domain_URL=#.u5b9au4e49u5e74u6708u65e5u65e5u671fu683cu5f0fString.DATE_FORMAT_YMD=yyyy-MM-dd#.u5b9au4e49u5e74u6708u65e5u65f6u5206u79d2u65e5u671fu683cu5f0fString.DATE_FORMAT_YMDHMS=yyyy-MM-dd HH:mm:ss#.u5b9au4e49u8d27u5e01u8f6cu6362u683cu5f0fString.MONEY_FORMAT=#,
解决方案:
,
解决方案:
,
解决方案:
.00#.u8bbeu7f6eu6839u7ad9u70b9u8defu5f84String.SITE_ROOT=/#.u8bbeu7f6eu670du52a1u5668u56feu7247u6d4fu89c8uff08u76f8u5bf9uff09u8defu5f84String.PIC_IMAGES_PATH=/uploadfile/images#.u8bbeu7f6eu6bcfu4e00u9875u663eu793au7684u5927u5c0fint.PAGE_SIZE=20#.u5b9au4e49u9996u9875u90e8u95e8u680fu76eeu5217u6570int.indexcoluncount=2#.u5b9au4e49u9996u9875u90e8u95e8u680fu76eeu5217u6570int.icolumnpagesize = 9#.u5b9au4e49u7ad9u70b9u5217u8868u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.iwebsitepagesize=9#.u5b9au4e49u5185u5bb9u5217u8868u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.icontentpagesize=20#.u5b9au4e49u5185u5bb9u5217u8868u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.imediacenterpagesize=9#.u5b9au4e49u5a92u4f53u5217u8868u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.icontenttypepagesize=9#.u5b9au4e49u6a21u677fu6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.itemplatepagesize=9#.u5b9au4e49u5df2u53d1u5e03u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.ialreadypagesize=9#.u5b9au4e49u7528u6237u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.icmsuserpagesize=9#.u5b9au4e49u89d2u8272u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.irolepagesize=9#.u5b9au4e49u5e10u6237u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.iaccountpagesize=9#.u5b9au4e49u529fu80fdu9879u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.ifucdefinepagesize=9#.u5b9au4e49u90e8u95e8u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.ideptmentpagesize=9#.u5b9au4e49u5ba1u6838u3001u53d1u5e03u3001u672au53d1u5e03u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.ipublishpagesize=9#.u5b9au4e49u6279u91cfu53d1u5e03u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.ibatchpublishpagesize=19#.u5b9au4e49u8fdcu7a0bu6293u53d6u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.iromotepagesize=9#..u5b9au4e49u5728u7ebfu7edfu8ba1u7684u7cfbu6570int.Stat_Coefficient=1#.u5b9au4e49u7ad9u70b9u4e0bu6700u65b0u5185u5bb9u7684u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.iwebsitenearcontentpagesize=10#.u5b9au4e49u5168u6587u68c0u7d22u7ed3u679cu96c6u6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.PER_PAGE=15#.u5b9au4e49u5185u5bb9u5217u8868uff0cu6bcfu4e00u9875u663eu793au7684u8bb0u5f55u6570int.LIST_PAGE=15#.u5b9au4e49u83dcu5355u9875uff08left.[u6700u65b0u56feu6587]u8bb0u5f55u6570int.MENU_LEFT_NUM=3#.u5b9au4e49u65b0u95fbu7cfbu7edfu53d1u5e03u540eu6709u6548u5929u6570int.PUB_CONT_DNUM=3#.u5b9au4e49u83dcu5355u9875uff08left [u6700u65b0u56feu6587]u8bb0u5f55u6570int.SHORTCUT_MAIN_CONT_NUM = 6#.u5b9au4e49u7cfbu7edfu9ed8u8ba4u7684u7ad9u70b9u6d41u7a0bint.CONTENTFLOWDEFINEID = 1#.u5b9au4e49u680fu76eeu4e0bu9ed8u8ba4u7684u5185u5bb9u6570int.COLUMN_CONTNUM = 6#.u5b9au4e49u7f51u4e0au6295u7968u7684u6743u503cint.VOTE_POWER = 1#.u8bbeu7f6eu83b7u5f97u5929u6c14u9884u62a5u7684u7f51u7ad9URLString.WEATHER_URL = http://weather.news.qq.com/inc/07_dc79.htm#.u5b9au4e49u6570u636eu5e93u7c7bu578bu8fdbu884cu65f6u95f4u8fd4u56deu7684u5b57u7b26u4e32u5904u7406 1u3001u4ee3u8868oracleu6570u636eu5e93; 2u3001u4ee3u8868Mysqlu6570u636eu5e93;3u3001u4ee3u8868DB2u6570u636eu5e93int.DATABASE_FLAG = 3#.u5b9au4e49u9ed8u8ba4u53d1u5e03u7684u65f6u95f4u957fu5ea6/u5355u4f4du4e3au5929int.PUBLISH_DATELENGTH=36000#.u5b9au4e49u5e94u7528u670du52a1u5668u7c7bu578bu8fdbu884cu5b57u7b26u4e32u5b57u7b26u8f6cu7801u7b49u7684u64cdu4f5cu5904u7406 1u3001u4ee3u8868tomcatu670du52a1u5668; 2u3001u4ee3u8868websphereu670du52a1u5668;3u3001u4ee3u8868weblogicu670du52a1u5668int.CONTAINER_FLAG = 1#.u5b9au4e49u5185u5bb9u6392u5e8fu7684u65b9u5f0f asc;descu5347u5e8f/u964du5e8fString.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=gbkoutput.encoding=gbk

解决方案

把数据库配置文件hibernate-context.xml贴出来,确定数据库用户名密码是否正确,http://www.db2china.net/home/space.php?uid=4884&do=blog&id=9949
解决方案:
你修改了DB2的的数据库登陆用户名和密码,所以错误,解决办法如下打开控制面板,找到db2的服务--属性--重新填写修改过后的用户名密码,重启服务。

时间: 2024-10-15 14:11:09

DB2 SQL error: SQLCODE: -1117, SQLSTATE: 57019, SQLERRMC:SWZCYJS的相关文章

MS SQL Could not obtain information about Windows NT group/user &amp;#39;domain\login&amp;#39;, error code 0x5. [SQLSTATE 42000] (Error 15404)

最近碰到一个有趣的错误:海外的一台数据库服务器上某些作业偶尔会报错,报错信息如下所示: ------------------------------------------------------------------------------------------------------------------------------------------------- 日期 2013/9/15 12:00:00 日志 作业历史记录 (JOB_SYNCHRONIZING_ESCM_DATA

MS SQL Could not obtain information about Windows NT group/user &#039;domain\login&#039;, error code 0x5. [SQLSTATE 42000] (Error 15404)

最近碰到一个有趣的错误:海外的一台数据库服务器上某些作业偶尔会报错,报错信息如下所示: ------------------------------------------------------------------------------------------------------------------------------------------------- 日期 2013/9/15 12:00:00 日志 作业历史记录 (JOB_SYNCHRONIZING_ESCM_DATA

SQL Error: 17008, SQLState: null

问题描述 每次程序运行一段时间以后,就报此错08-08-17 09:55:29 WARN JDBCExceptionReporter:71 - SQL Error: 17008, SQLState: null08-08-17 09:55:29 ERROR JDBCExceptionReporter:72 - 关闭的连接08-08-17 09:55:29 WARN JDBCExceptionReporter:71 - SQL Error: 17008, SQLState: null08-08-17

MySQL出现SQL Error (2013)连接错误的解决方法_Mysql

现象描述今天用heidisql登陆虚拟机的MySQL,登陆不上去.等待约一两分钟后出现错误提示:SQL Error (2013): Lost connection to MySQL server at 'waiting for initial communication packet', system error: 0,如下图所示: 开始以为是远程TCP/IP  root只能通过localhost访问 ,后来新建用户,改为%后还是无果.尝试修改my.ini配置问题后问题消失. 解决办法在my.i

SQL error: cannot use the special principal &#039;sa&#039;

 SQL error: cannot use the special principal 'sa' 解决方案: use dbname EXEC sp_changedbowner 'dbname' 参考:https://msdn.microsoft.com/en-us/library/ms178630.aspx

SQL Error: 933, SQLState: 42000

问题描述 执行程序的时候报出这个问题,麻烦各位帮我看看:2011-01-2009:00:56,062WARN[org.hibernate.util.JDBCExceptionReporter]-SQLError:933,SQLState:420002011-01-2009:00:56,062ERROR[org.hibernate.util.JDBCExceptionReporter]-ORA-00933:SQL命令未正确结束2011-01-2009:00:56,078WARN[org.apach

Cannot generate SSPI context---MS SQL ERROR

  http://www.cnblogs.com/newr2006/archive/2011/08/25/2153253.html Additional error information from SQL Server is included below.  Cannot generate SSPI context. ConnectionString:'Data Source=sqlxxxxx;Initial Catalog=master;Integrated Security=True;Po

java jdbc 对 DB2 数据库 做CRUD 操作

问题描述 java jdbc 对 DB2 数据库 做CRUD 操作 本人想通过 java 的jdbc 连接 DB2 数据库,并对数据库进行操作,操了好几天了, 是这样的报错 的 DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: null 自己也去找了这个报错是什么意思, 网上是这样解释的 : -805 在计划中没有发现DBRM或程序包名 解决的办法就是重新绑定 然后自己又去 找 怎么绑定的方法. 我之前一直用的 sql server

跟屌丝学DB2 第二课 建立数据库以及添加用户

在安装DB2 之后,就可以在 DB2 环境中创建自己的数据库.首先考虑数据库应该使用哪个实例.实例(instance) 提供一个由数据库管理配置(DBM CFG)文件控制的逻辑层,可以在这里将多个数据库分组在一起.DBM CFG 文件包含一组 DBM CFG 参数,可以使用它们对实例进行调优.在每个工作站上可以创建多个实例,在每个实例中可以创建多个数据库.屌丝学习当然要创建屌丝实例Windows先创建DB2实例的方法 在Windows下,通过如下命令即可创建DB2实例:db2icrt insta