Question

org.springframework.jdbc.uncategorizedsqlexception请求的转化无效。是什么错误

org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; u
ncategorized SQLException for SQL [{? = call ctais.P_WBJK_FP_YJ(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; SQL state [null]; error code [17132]; 请求的转换无效; nested ex
ception is java.sql.SQLException: 请求的转换无效
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952)
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985)
at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:117)
at com.inspur.tax.common.jdbc.CommProcDaoforCatis.execFun(CommProcDaoforCatis.java:200)
at com.inspur.tax.common.jdbc.CommProcDaoforCatis.execFun(CommProcDaoforCatis.java:122)
at com.inspur.tax.service.FpYjService.fpyjbc(FpYjService.java:245)
at com.inspur.tax.service.FpYjService.fpyjbc_pl(FpYjService.java:258)
at jsp_servlet._jsp._arm._yj.__fpyjbc._jspService(__fpyjbc.java:150)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:1077)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
问题我自己解决了是由于传参数类型不正确造成的

Answer 1

jdbc和连接池对于你这个场景来说，都足够，既然用spring管理了，建议还是使用连接池，另外，spring自身没有实现连接池，一般都是对第三方连接池的包装，常见的有C3P0，dbcp以及最近比较流行的boneCP等，这几个配置都差不多太多，以boneCP为例：
<bean id="dataSource" class="com.jolbox.bonecp.BoneCPDataSource"
destroy-method="close">
<property name="driverClass" value="${jdbc.driverClass}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="username" value="${jdbc.user}" />
<property name="password" value="${jdbc.password}" />
<property name="idleConnectionTestPeriod" value="60" />
<property name="idleMaxAge" value="240" />
<property name="maxConnectionsPerPartition" value="30" />
<property name="minConnectionsPerPartition" value="10" />
<property name="partitionCount" value="2" />
<property name="acquireIncrement" value="5" />
<property name="statementsCacheSize" value="100" />
<property name="releaseHelperThreads" value="3" />
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>