org.springframework.jdbc.uncategorizedsqlexception请求的转化无效。是什么错误 10
org.springframework.jdbc.UncategorizedSQLException:CallableStatementCallback;uncatego...
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
问题我自己解决了是由于传参数类型不正确造成的 展开
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
问题我自己解决了是由于传参数类型不正确造成的 展开
展开全部
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>
<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>
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询