lotterywebpay.log.2008-08-12.svn-base

项目支付宝批量打款,采用httpclient+spring +quarz实现.

org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call Web_tkxxth ( ? )}]; nested exception is java.sql.SQLException: 过程 'Web_tkxxth' 需要参数 '@czUser'，但未提供该参数。
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:108)
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:927)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:939)
	at com.szhelper.pay.dao.impl.BaseDaoImpl.executeProcess(BaseDaoImpl.java:228)
	at com.szhelper.pay.dao.impl.PayUploadDaoImpl.rollbackLoad(PayUploadDaoImpl.java:33)
	at com.szhelper.pay.service.impl.PayProxyServiceImpl.rollbackPrepareSendUploadPM(PayProxyServiceImpl.java:213)
	at com.szhelper.pay.service.impl.PayProxyServiceImpl.prepareSendUploadPM(PayProxyServiceImpl.java:205)
	at com.szhelper.pay.quartz.job.PayUploadJob.execute(PayUploadJob.java:38)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.sql.SQLException: 过程 'Web_tkxxth' 需要参数 '@czUser'，但未提供该参数。
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:780)
	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.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at $java.sql.CallableStatement$$EnhancerByProxool$$7fb0630a.executeQuery(<generated>)
	at com.szhelper.pay.dao.impl.BaseDaoImpl$1.doInCallableStatement(BaseDaoImpl.java:237)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:911)
	... 8 more
ERROR 2008-08-12 11:48:01,921 org.quartz.core.ErrorLogger - Job (groupRead.readPayDataJob threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call Web_tkxxth ( ? )}]; nested exception is java.sql.SQLException: 过程 'Web_tkxxth' 需要参数 '@czUser'，但未提供该参数。]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call Web_tkxxth ( ? )}]; nested exception is java.sql.SQLException: 过程 'Web_tkxxth' 需要参数 '@czUser'，但未提供该参数。
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:108)
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:927)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:939)
	at com.szhelper.pay.dao.impl.BaseDaoImpl.executeProcess(BaseDaoImpl.java:228)
	at com.szhelper.pay.dao.impl.PayUploadDaoImpl.rollbackLoad(PayUploadDaoImpl.java:33)
	at com.szhelper.pay.service.impl.PayProxyServiceImpl.rollbackPrepareSendUploadPM(PayProxyServiceImpl.java:213)
	at com.szhelper.pay.service.impl.PayProxyServiceImpl.prepareSendUploadPM(PayProxyServiceImpl.java:205)
	at com.szhelper.pay.quartz.job.PayUploadJob.execute(PayUploadJob.java:38)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	... 1 more
Caused by: java.sql.SQLException: 过程 'Web_tkxxth' 需要参数 '@czUser'，但未提供该参数。
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:780)
	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.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at $java.sql.CallableStatement$$EnhancerByProxool$$7fb0630a.executeQuery(<generated>)
	at com.szhelper.pay.dao.impl.BaseDaoImpl$1.doInCallableStatement(BaseDaoImpl.java:237)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:911)
	... 8 more
 INFO 2008-08-12 11:49:04,406 org.logicalcobwebs.proxool.lotteryWebPay - Shutting down 'lotteryWebPay' pool immediately [ContainerBackgroundProcessor[StandardEngine[Catalina]]]
 INFO 2008-08-12 11:49:04,406 org.logicalcobwebs.proxool.PrototyperController - Stopping Prototyper thread
 INFO 2008-08-12 11:49:04,406 org.logicalcobwebs.proxool.HouseKeeperController - Stopping HouseKeeper thread
 INFO 2008-08-12 11:49:04,406 com.szhelper.pay.quartz.action.PayUploadServlet - ------- Shutting Down PayProxy ... -----------------
 INFO 2008-08-12 11:49:04,406 com.szhelper.pay.quartz.action.PayUploadServlet - ------- Shutting Down ---------------------
 INFO 2008-08-12 11:49:04,406 org.quartz.core.QuartzScheduler - Scheduler TestScheduler_$_NON_CLUSTERED shutting down.
 INFO 2008-08-12 11:49:04,406 org.quartz.core.QuartzScheduler - Scheduler TestScheduler_$_NON_CLUSTERED paused.
 INFO 2008-08-12 11:49:04,406 org.quartz.simpl.SimpleThreadPool - There are still 30 worker threads active. See javadoc runInThread(Runnable) for a possible explanation
 INFO 2008-08-12 11:49:04,406 org.quartz.core.QuartzScheduler - Scheduler TestScheduler_$_NON_CLUSTERED shutdown complete.
 INFO 2008-08-12 11:49:04,406 com.szhelper.pay.quartz.action.PayUploadServlet - ------- Shutdown Complete -----------------
 INFO 2008-08-12 11:49:04,421 com.szhelper.pay.quartz.action.PayUploadServlet - Executed 1 jobs.
 INFO 2008-08-12 11:49:04,421 com.szhelper.pay.quartz.action.PayUploadServlet - ------- Shutting Down PayProxy Complete -----------------
 INFO 2008-08-12 11:49:04,421 org.springframework.web.context.support.XmlWebApplicationContext - Closing org.springframework.web.context.support.XmlWebApplicationContext@da0c91: display name [Root WebApplicationContext]; startup date [Tue Aug 12 11:34:31 CST 2008]; root of context hierarchy
 INFO 2008-08-12 11:49:04,421 org.springframework.beans.factory.support.DefaultListableBeanFactory - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@be568b: defining beans [dataSource,paygateway,partner,key,acount,seqPreFix,uploadPayConfig,baseDao,payUploadDao,daoFactory,PayProxyService]; root of factory hierarchy
 INFO 2008-08-12 11:49:06,156 org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization started
 INFO 2008-08-12 11:49:06,312 org.springframework.web.context.support.XmlWebApplicationContext - Refreshing org.springframework.web.context.support.XmlWebApplicationContext@473f55: display name [Root WebApplicationContext]; startup date [Tue Aug 12 11:49:06 CST 2008]; root of context hierarchy
 INFO 2008-08-12 11:49:06,562 org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/resource.xml]
 INFO 2008-08-12 11:49:06,718 org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
 INFO 2008-08-12 11:49:06,781 org.springframework.web.context.support.XmlWebApplicationContext - Bean factory for application context [org.springframework.web.context.support.XmlWebApplicationContext@473f55]: org.springframework.beans.factory.support.DefaultListableBeanFactory@194ac91
 INFO 2008-08-12 11:49:06,968 org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@194ac91: defining beans [dataSource,paygateway,partner,key,acount,seqPreFix,uploadPayConfig,baseDao,payUploadDao,daoFactory,PayProxyService]; root of factory hierarchy
 INFO 2008-08-12 11:49:07,437 org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC driver: org.logicalcobwebs.proxool.ProxoolDriver
 INFO 2008-08-12 11:49:08,015 org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 1859 ms
 INFO 2008-08-12 11:49:08,031 com.szhelper.pay.LotterywebServletContextListener - ApplicationContext has been initialized successfully.
 INFO 2008-08-12 11:49:08,093 org.logicalcobwebs.proxool.ProxoolFacade - Proxool 0.9.0RC3 (10-Jan-2007 01:38)
 INFO 2008-08-12 11:49:28,375 org.logicalcobwebs.proxool.lotteryWebPay - Shutting down 'lotteryWebPay' pool immediately [ContainerBackgroundProcessor[StandardEngine[Catalina]]]
 INFO 2008-08-12 11:49:28,375 org.logicalcobwebs.proxool.PrototyperController - Stopping Prototyper thread
 INFO 2008-08-12 11:49:28,375 org.logicalcobwebs.proxool.HouseKeeperController - Stopping HouseKeeper thread
 INFO 2008-08-12 11:49:28,375 org.springframework.web.context.support.XmlWebApplicationContext - Closing org.springframework.web.context.support.XmlWebApplicationContext@473f55: display name [Root WebApplicationContext]; startup date [Tue Aug 12 11:49:06 CST 2008]; root of context hierarchy
 INFO 2008-08-12 11:49:28,375 org.springframework.beans.factory.support.DefaultListableBeanFactory - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@194ac91: defining beans [dataSource,paygateway,partner,key,acount,seqPreFix,uploadPayConfig,baseDao,payUploadDao,daoFactory,PayProxyService]; root of factory hierarchy
 INFO 2008-08-12 11:49:29,312 org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization started
 INFO 2008-08-12 11:49:29,453 org.springframework.web.context.support.XmlWebApplicationContext - Refreshing org.springframework.web.context.support.XmlWebApplicationContext@21b936: display name [Root WebApplicationContext]; startup date [Tue Aug 12 11:49:29 CST 2008]; root of context hierarchy
 INFO 2008-08-12 11:49:29,671 org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/resource.xml]
 INFO 2008-08-12 11:49:29,781 org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
 INFO 2008-08-12 11:49:29,828 org.springframework.web.context.support.XmlWebApplicationContext - Bean factory for application context [org.springframework.web.context.support.XmlWebApplicationContext@21b936]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1fe4af1
 INFO 2008-08-12 11:49:29,984 org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1fe4af1: defining beans [dataSource,paygateway,partner,key,acount,seqPreFix,uploadPayConfig,baseDao,payUploadDao,daoFactory,PayProxyService]; root of factory hierarchy
 INFO 2008-08-12 11:49:30,140 org.springframework.jdbc.datasource.DriverManagerDataSource - Loaded JDBC driver: org.logicalcobwebs.proxool.ProxoolDriver
 INFO 2008-08-12 11:49:30,421 org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 1109 ms
 INFO 2008-08-12 11:49:30,437 com.szhelper.pay.LotterywebServletContextListener - ApplicationContext has been initialized successfully.