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.<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
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.<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
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.<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---属性文件初始化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.<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
问题补充:#####################################\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
相关推荐
在DB2中,错误码通常由SQLCODE和SQLSTATE两部分组成: - **SQLCODE**:是一个整数值,用来表示错误或警告的状态。正数表示警告,负数表示错误。 - **SQLSTATE**:是一个五字符的字符串,用来提供关于错误或警告的更...
DB2SQLError: SQLCODE=-290, SQLSTATE=55039, SQLERRMC=null, DRIVER=3.50.152 消息:不允许访问表空间。SQLCODE=-290, SQLSTATE=55039, DRIVER=3.50.152 ``` 此错误提示中的`SQLCODE=-290`和`SQLSTATE=55039`表明...
db2 数据库错误对照文档,错误分析及解决办法,常见的都有。db2数据库开发者最好的帮助文档。
4. **配置问题**:DB2的安全策略或配置设置可能过于严格,导致某些正常操作无法执行。 **解决方法** 1. **检查权限**:首先,你需要确认用户是否拥有执行所需操作的适当权限。可以使用`DB2 Authorization`命令来...
在DB2中,SQLCODE和SQLSTATE是用来表示SQL语句执行结果的状态码。其中: - **SQLCODE**:是IBM DB2系统定义的一个整型变量,用于返回SQL语句执行的结果状态。 - **SQLSTATE**:是一个由五位字符组成的字符串,用来更...
+098 01568 动态SQL语句用分号结束 +100 02000 没有找到满足SQL语句的行 +110 01561 用DATA CAPTURE定义的表的更新操作不能发送到原来的子系统 +111 01590 为2型索引设置了SUBPAGES语句 +117 01525 要插入的值的...
因此,本文旨在整理 DB2 的 SQL、sqlcode、sqlstate 错误码大全,提供详细的错误码说明和用户响应方法,帮助用户快速解决问题,提高工作效率。 SQL0000 - SQL0099 在 DB2 中,SQL0000 - SQL0099 错误码系列主要...
本文将详细介绍一系列常见的SQLCODE和SQLState错误信息及其含义,旨在帮助用户更好地理解这些错误,并能够自行分析问题的原因。 #### SQL CODE和SQL State简介 SQL CODE和SQL State是DB2中用于表示SQL语句执行状态...
### DB2常用错误信息解析 #### 一、概述 DB2是IBM开发的一款关系型数据库管理系统,因其稳定性和高效性而在企业级应用中占据重要地位。然而,在使用DB2过程中,用户可能会遇到各种各样的错误信息,这些错误信息...
在DB2中,SQLCODE和SQLSTATE经常一起使用,以确保SQL语句的执行结果能够被准确地解读。 在提供的文件内容中,DB2 SQLCODE大全列出了大量可能的SQLCODE值及其对应的SQLSTATE值和说明。以下是文件内容中部分知识点的...
这些错误提示通常包含一个SQLCODE和SQLSTATE值,用来指示具体发生了什么类型的错误。理解这些错误码的意义对于快速定位问题、解决问题至关重要。下面我们将详细解释一些常见的DB2错误码及其含义。 #### 00000 - SQL...
本文将深入解析一系列由DB2产生的SQLCode及其对应的SQLState,帮助数据库管理员、开发者及运维工程师更准确地识别与处理数据库操作中出现的问题。 #### 一、SQLCode与SQLState概览 在DB2中,每当执行SQL语句时,...
在IT行业中,数据库管理系统(DBMS)是至关重要的组成部分,而IBM DB2作为一款高性能、高可靠性的数据库系统,被广泛应用于各种企业级应用中。在DB2的日常管理和维护过程中,遇到错误是难以避免的,而理解这些错误代码...
- **语法错误**:当SQL语句不符合DB2的语法规则时,DB2会返回一个语法错误的SQLCODE。 - **权限错误**:如果你没有足够的权限执行某个操作,如更新、删除数据,DB2会返回相应的权限错误代码。 - **数据错误**:...
DB2 报错:SQL10007N Message "-1390" could not be retrieved. Reason code 的解决方案 在安装 DB2 9.7 之后,某人发现 db2inst1 用户下无法运行一切 db2 命令,如果跑到 db2 的 bin 目录下运行 db2 命令,会给出...
DB2通过返回`sqlcode`和`sqlstate`来告知用户具体的错误信息,帮助开发者和管理员理解并解决问题。`sqlcode`是一个整数值,通常负值表示错误,正值表示警告,而`sqlstate`则是一个五位的字母数字代码,提供了更详细...
1、DB2(DataBase2DataBase)开发常遇到一些错误,汇总了几百个常见的错误信息,用以查错使用。 2、可以按需检索,检索错误码或者关键字都可以。 3、资源内容列举: 关键字:SQL0084 SQLCODE -84 说明: SQL statement...
以上所述是小编给大家介绍的详解DB2 sqlstate 57016 SQLCODE=-668 原因码 “7”错误的快速解决办法,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对软件开发网网站...
本文将基于提供的DB2错误信息(按sqlcode排序),详细介绍部分常见错误代码的意义、发生场景以及可能的解决方案。 #### 一、成功类错误码 **SQLCODE:** 000 **SQLSTATE:** 00000 **说明:** SQL语句成功完成。 ...
DB2错误信息通常由SQLCODE和SQLSTATE组成,其中SQLCODE用于表示错误的具体类型,而SQLSTATE则提供了关于错误发生的更详细信息。接下来我们将逐一分析这些错误信息。 ##### 1. **成功完成 (00000)** - **SQLCODE**:...