ibatis添加数据的时候报错
[Roxinf]2011-07-13 11:15:02 DEBUG Connection[debug]:27 - {conn-100041} Preparing Statement: insert into fileinfo (breakerno,filename,filetime,filetype,actiontype,filephase,fileinfo) values (?, ?,?, ?, ?,?, ?)
[Roxinf]2011-07-13 11:15:02 INFO XmlBeanDefinitionReader[loadBeanDefinitions]:323 - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[Roxinf]2011-07-13 11:15:02 INFO SQLErrorCodesFactory[<init>]:128 - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
org.springframework.dao.TransientDataAccessResourceException: SqlMapClient operation; SQL [];
--- The error occurred in ibatis/fileinfo_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the fileInsert-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in ibatis/fileinfo_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the fileInsert-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
at com.roxinf.commons.dao.AbstractIbatisDAO.insert(AbstractIbatisDAO.java:102)
at com.bjwise.analysis.service.impl.BreakerDaoImpl.addFileInfo(BreakerDaoImpl.java:147)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)实体类
public class FileInfo
{ private Integer id; // 自动id
private String breakerno; // 设备编号
private String fileName; // 文件名称
private String fileTime; // 文件时间
private String fileType; // 文件类型
private String actionType; // 动作类型
private String filePhase; // 动作相数
private String fileInfo; // 文件信息set/get方法都有}ibatis配置文件<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="fileinfo"> <select id="selectAll" resultClass="com.bjwise.analysis.domain.FileInfo">
SELECT * FROM fileinfo WHERE breakerno LIKE #breakerno:VARCHAR# AND filetype LIKE #fileType:VARCHAR# ORDER BY id DESC
</select> <select id="selectByPrimaryKey" resultClass="com.bjwise.analysis.domain.FileInfo" parameterClass="com.bjwise.analysis.domain.FileInfo">
select *
from fileinfo
where Id = #id:INTEGER#
</select> <delete id="deleteByPrimaryKey" parameterClass="com.bjwise.analysis.domain.FileInfo">
delete from fileinfo
where Id = #id:INTEGER#
</delete>
<delete id="deleteByPrimarybreakerId" parameterClass="com.bjwise.analysis.domain.FileInfo">
delete from fileinfo
where breakerno = #breakerno:VARCHAR#
</delete> <insert id="fileInsert" parameterClass="com.bjwise.analysis.domain.FileInfo">
insert into fileinfo (breakerno,filename,filetime,filetype,actiontype,filephase,fileinfo) values
(#breakerno:VARCHAR#, #fileName:VARCHAR#,#fileTime:VARCHAR#, #fileType:VARCHAR#, #actionType:VARCHAR#,#filePhase:VARCHAR#, #fileInfo:VARCHAR#)
</insert></sqlMap>
[Roxinf]2011-07-13 11:15:02 DEBUG Connection[debug]:27 - {conn-100041} Preparing Statement: insert into fileinfo (breakerno,filename,filetime,filetype,actiontype,filephase,fileinfo) values (?, ?,?, ?, ?,?, ?)
[Roxinf]2011-07-13 11:15:02 INFO XmlBeanDefinitionReader[loadBeanDefinitions]:323 - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[Roxinf]2011-07-13 11:15:02 INFO SQLErrorCodesFactory[<init>]:128 - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
org.springframework.dao.TransientDataAccessResourceException: SqlMapClient operation; SQL [];
--- The error occurred in ibatis/fileinfo_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the fileInsert-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in ibatis/fileinfo_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the fileInsert-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
at com.roxinf.commons.dao.AbstractIbatisDAO.insert(AbstractIbatisDAO.java:102)
at com.bjwise.analysis.service.impl.BreakerDaoImpl.addFileInfo(BreakerDaoImpl.java:147)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)实体类
public class FileInfo
{ private Integer id; // 自动id
private String breakerno; // 设备编号
private String fileName; // 文件名称
private String fileTime; // 文件时间
private String fileType; // 文件类型
private String actionType; // 动作类型
private String filePhase; // 动作相数
private String fileInfo; // 文件信息set/get方法都有}ibatis配置文件<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="fileinfo"> <select id="selectAll" resultClass="com.bjwise.analysis.domain.FileInfo">
SELECT * FROM fileinfo WHERE breakerno LIKE #breakerno:VARCHAR# AND filetype LIKE #fileType:VARCHAR# ORDER BY id DESC
</select> <select id="selectByPrimaryKey" resultClass="com.bjwise.analysis.domain.FileInfo" parameterClass="com.bjwise.analysis.domain.FileInfo">
select *
from fileinfo
where Id = #id:INTEGER#
</select> <delete id="deleteByPrimaryKey" parameterClass="com.bjwise.analysis.domain.FileInfo">
delete from fileinfo
where Id = #id:INTEGER#
</delete>
<delete id="deleteByPrimarybreakerId" parameterClass="com.bjwise.analysis.domain.FileInfo">
delete from fileinfo
where breakerno = #breakerno:VARCHAR#
</delete> <insert id="fileInsert" parameterClass="com.bjwise.analysis.domain.FileInfo">
insert into fileinfo (breakerno,filename,filetime,filetype,actiontype,filephase,fileinfo) values
(#breakerno:VARCHAR#, #fileName:VARCHAR#,#fileTime:VARCHAR#, #fileType:VARCHAR#, #actionType:VARCHAR#,#filePhase:VARCHAR#, #fileInfo:VARCHAR#)
</insert></sqlMap>
解决方案 »
- mina 怎么判断 调用close方法关闭和网络断开关闭
- javamail 收邮件时候内容重复 怎么过滤重复内容.... 100分给了.
- xfire webservice中用spring注入sessionFactory报错
- 请问谁有java写的打印功能源码吗?
- Hibernate中的java.lang.IllegalAccessError 异常
- JNDI,通过连接池 lookup 的 javax.sql.DataSource 在整个应用程序中,是不是 loogup 一次,就可以?
- 最简单的Hibernate3例子,什么总是报错???
- 有没有java 做些别的产品啊,老做些操作数据库的管理类软件,无聊死了,(j2me我知道)j2se技术呢?
- 求有关于JFreeChart的资料
- 请教一个tomcat的问题
- STRUTS2中json的一个问题
- EJB3.0中怎样调用xFire开发的WebService??在线等。。。。。。
我也碰到过这种read-only的情况,以前是ssh2整合的时候 事务那边的问题