我在使用下面的代码时将一行插入数据库(oracle 10g xe,jar：ojdbc14.jar)
String sql = "INSERT INTO SPONSOR_TB(ID,NAME,INDUSTRY_TYPE,IS_REPORTING_SPONSOR,IS_NOT_SOLICITE) VALUES(SEQ_SPONSOR_ID.NEXTVAL,:NAME1,:INDUSTRY_TYPE,:IS_REPORTING_SPONSOR,:IS_NOT_SOLICITE)";MapsqlParameterSource paramSource = new MapsqlParameterSource();paramSource.addValue("NAME1",sponsor.getName());paramSource.addValue("INDUSTRY_TYPE",sponsor.getIndustryType());paramSource.addValue("IS_NOT_SOLICITE",sponsor.getNotSoliciteFlag()?'Y':'N');paramSource.addValue("IS_REPORTING_SPONSOR",sponsor.getReportingFlag()?'Y':'N');KeyHolder generatedKeyHolder = new GeneratedKeyHolder();namedParameterJdbcTemplate.update(sql,paramSource,generatedKeyHolder,new String[]{"ID"});int id = generatedKeyHolder.getKey().intValue();
表的结构是：
create table SPONSOR_TB(id INTEGER not null,name VARCHAR2(20),industry_type INTEGER not null,is_reporting_sponsor CHAR(1) not null,is_not_solicite CHAR(1) not null)
和SEQ_SPONSOR_ID是序列
赞助商类是：
public class Sponsor{private int id;private String name;private boolean reportingFlag;private boolean notSoliciteFlag;private int industryType;//getter setter}
spring-servlet.xml中的db配置是：
我得到以下异常：
SEVERE: Servlet.service() for servlet [spring] in context with path [/GroupSolution] threw exception [Request processing Failed; nested exception is org.springframework.jdbc.UncategorizedsqlException: PreparedStatementCallback; uncategorized sqlException for sql [INSERT INTO SPONSOR_TB (ID,?,?)]; sql state [null]; error code [17004]; Invalid column type; nested exception is java.sql.sqlException: Invalid column type] with root causejava.sql.sqlException: Invalid column type at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwsqlException(DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9168) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8749) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9471) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9454) at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:351) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:216) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:127) at org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.setValues(PreparedStatementCreatorFactory.java:298) at org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.createPreparedStatement(PreparedStatementCreatorFactory.java:251) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:581) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:843) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:288) at com.groupsolution.dao.SponsorDaoImpl.createSponsor(SponsorDaoImpl.java:55) at com.groupsolution.service.SponsorServiceImpl.createSponsor(SponsorServiceImpl.java:31) at com.groupsolution.controller.SponsorController.addSponsor(SponsorController.java:38) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
最佳答案
您可能想尝试使用字符串而不是CHAR(1)Y / N字段的字符.
