Mybatis连接Oracle主键自增的问题

dai_zhuo_ 2013-04-11 03:35:41 
Mapper配置文件中

<insert id="addBulletin" parameterType="com.mm.entity.Bulletin">

		<selectKey 	resultType="java.lang.Integer" keyProperty="bid" order="BEFORE">

			select bulletin_id.nextval as bid from dual

		</selectKey>

		insert into bulletin(<include refid="columns"/>)

		values(${bid},#{bTitle,jdbcType=VARCHAR},#{bContent,jdbcType=VARCHAR},#{bSendtime,jdbcType=DATE})

	</insert>

JavaBean中

private int bid;

	

	private String bTitle;

	

	private String bContent;

	

	private Date bSendtime;



Action中

	@RequestMapping(value="/addBulletin",method=RequestMethod.POST)

	public String addBulletin(@Valid Bulletin bulletin){

		bulletin.setbSendtime(new Date());

		bulletinService.addBulletin(bulletin);

		return "bulletin";

	}
数据库中


BID	NUMBER	N			

B_TITLE	VARCHAR2(255)			

B_CONTENT	VARCHAR2(1000)		

B_SENDTIME	DATE		



 异常

java.sql.SQLException: ORA-01861: 文字与格式字符串不匹配



	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)

	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)

	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212)

	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:951)

	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159)

	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)

	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3389)

	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)

	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)

	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)

	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:88)

	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:122)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:111)

	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:350)

	at $Proxy6.insert(Unknown Source)

	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:232)

	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:59)

	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:25)

	at $Proxy12.addBulletin(Unknown Source)

	at com.mm.service.BulletinService.addBulletin(BulletinService.java:25)

	at com.mm.controller.BulletinAct.addBulletin(BulletinAct.java:45)

	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.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)

	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:100)

	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:604)

	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:565)

	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

	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:637)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)

	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:600)

	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1703)

	at java.lang.Thread.run(Thread.java:619)

求大神降临解决问题
...全文
234 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
dai_zhuo_ 2013-04-11
  • 打赏
  • 举报
 回复 
<insert id="addBulletin" parameterType="com.mm.entity.Bulletin">
		<selectKey 	resultType="java.lang.Long" keyProperty="bid" order="BEFORE">
			select bulletin_id.nextval as bid from dual
		</selectKey>
		insert into bulletin(<include refid="columns"/>)
		values(${bid},#{bTitle,jdbcType=VARCHAR},#{bContent,jdbcType=VARCHAR},#{bSendtime,jdbcType=DATE})
	</insert>
当我办Mapper中resultType改成这样的时候会出现 

java.lang.IllegalArgumentException: argument type mismatch
	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.ibatis.reflection.invoker.MethodInvoker.invoke(MethodInvoker.java:22)
	at org.apache.ibatis.reflection.wrapper.BeanWrapper.setBeanProperty(BeanWrapper.java:152)
	at org.apache.ibatis.reflection.wrapper.BeanWrapper.set(BeanWrapper.java:36)
	at org.apache.ibatis.reflection.MetaObject.setValue(MetaObject.java:120)
	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:54)
	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processBefore(SelectKeyGenerator.java:26)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:58)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:43)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:56)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:28)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:88)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:122)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:111)
	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:350)
	at $Proxy6.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:232)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:59)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:25)
	at $Proxy12.addBulletin(Unknown Source)
	at com.mm.service.BulletinService.addBulletin(BulletinService.java:25)
	at com.mm.controller.BulletinAct.addBulletin(BulletinAct.java:45)
	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.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:100)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:604)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:565)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	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:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:600)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1703)
	at java.lang.Thread.run(Thread.java:619)
Oracle主键自增的办法
用于Oracle的主键进行自增的办法，有触发器 和序列机制
mybatis自增主键文档
mybatis进行插入操作时，如果表的主键是自增的，...基本上经常会遇到的就是 Oracle Sequece 和 Mysql 自增主键，至于其他的手动生成唯一主键的问题在这里就不讨论了，这里主要说明下在mybatis中对于自增主键的配置。
Java学习指南21 MyBatis框架
本篇主要包含以下内容： * 在项目中加入 MyBatis 支持 * 基于 MyBatis 的查询 * 基于 MyBatis 的插入，自增主键的配置 * 基于 MyBatis 的更新与删除操作 * ResultMap 自定义结果映射 * Dynamic SQL 动态可变的SQL *...
MyBatis Oracle 自增序列的实现方法
给大家分享MyBatis Oracle 自增序列的实现方法及mybatis配置oracle的主键自增长的方法，非常不错具有一定的参考借鉴价值，感兴趣的朋友一起看看吧
最新Mybatis插入数据返回自增主键详细配置
Mybatis插入数据返回自增主键 Mybatis插入数据以后只会返回影响的数据库行数，如果是插入一条数据成功则返回1，失败返回零，插入多条返回插入成功的数量。 通过注解或者xml配置无法直接返回自增的主键。Mybatis插入...
Web 开发

81,092

社区成员

341,716

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章