`
venus224
  • 浏览: 208064 次
  • 性别: Icon_minigender_1
  • 来自: 厦门
社区版块
存档分类
最新评论

ERROR - Connection is read-only.

    博客分类：
  • j2ee
SQLJavaHibernateJDBC 
阅读更多
今天在serviceImpl的查询中,调用了一样更新的操作!
结果出现如下错误! 
ERROR - Connection is read-only. Queries leading to data modification are not allowed
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute update query; uncategorized SQLException for SQL [update t_node set fact_people=1 where node_id='200825000001' and enterprise_id=200825]; SQL state [S1009]; error code [0]; Connection is read-only. Queries leading to data modification are not allowed; nested exception is java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
Caused by: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

检查代码,没有问题!
忽然想到配置文件上,查询的话,是只读的! 
<prop key="query*">PROPAGATION_REQUIRED,readOnly</prop>

只要把它改为 
<prop key="query*">PROPAGATION_REQUIRED</prop>

再做更新和查询,没有问题了!:)
分享到：
| mysql数据库,把年份设置为year,返回前台 ...
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    FlexGraphics_V_1.79_D4-XE10.2_Downloadly.ir

    is written to stream, which is then read by the flex-property, for which the Assign method is called. - ADD: In TIdPool (module FlexUtils), added the method NextUsed (allows iterating all taken ...

    BURNINTEST--硬件检测工具

    is only available under Windows 2000 and Windows XP professional (the other RAM tests are supported under the other OS's). Users must have administrator privileges. Windows 98 and Windows ME ======...

    spring-boot-reference.pdf

    12. What to Read Next III. Using Spring Boot 13. Build Systems 13.1. Dependency Management 13.2. Maven 13.2.1. Inheriting the Starter Parent 13.2.2. Using Spring Boot without the Parent POM 13.2.3. ...

    php.ini-development

    error_reporting ; Default Value: E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED ; Development Value: E_ALL ; Production Value: E_ALL & ~E_DEPRECATED & ~E_STRICT ; html_errors ; Default Value: On ; ...

    Sakemail

    ‘ now (before it was ‘,‘ only).1.7.1- Roger F. Reghin has sended me a pair of nice patches that resolve in a good behavior when the destination address is something like &quot;Roger Reghin&quot; ...

    k7 SRIO参考例程

    - CR#546424 - Using READ_FIRST mode for buffer BRAMs - need to update to WRITE_FIRST mode for Spartan-6 and Virtex-6 based on characterization. - VHDL example design simulation error when CRF bit...

    Oracle sqldeveloper without jdk (win+linux)

    If the locale of the operating system is not English, a few UI elements, like default wizard buttons and Oracle error messages, may show up in the language of this locale. If the locale of the ...

    Bochs - The cross platform IA-32 (x86) emulator

    [3053542] 64 bit mode: far-jmp instruction is error [3011112] error compile vs2008/2010 with X2APIC [3002017] compile error with vs 2010 [3009767] guest RFLAGS.IF blocks externel interrupt in VMX ...

    JLink_Windows_V648.zip

    DLL: JTAG: When only having 1 TAP in the JTAG chain and its matches the one for the configured CPU core but the TAP-ID was unknown, connect did not work. Fixed. DLL: Linux: Delayed / slowed execution ...

    php_6_fast_and_easy_web_development.pdf

    Appendix CWriting Your...How PHP Is Parsed. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 PHP Start and End Tags. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...

    计算机网络第六版答案

    22. Five generic tasks are error control, flow control, segmentation and reassembly, multiplexing, and connection setup. Yes, these tasks can be duplicated at different layers. For example, error ...

    win 3.11 for workgroup tcpip支持

    mechanism is used only with TCP (connection-oriented traffic). Therefore, utilities like PING will only use the first default gateway. Notice that t his only applies to IP datagrams that have to be ...

    微软内部资料-SQL性能优化3

    Another type of table lock is a schema stability lock (Sch-S) and is compatible with all table locks except the schema modification lock (Sch-M). The schema modification lock (Sch-M) is incompatible ...

    MySQL 5.6 Reference Manual

    Table of Contents Preface, Notes, Licenses . . . . . . . . ....1. Licenses for Third-Party Components ....1.1. FindGTest.cmake License ....1.2. LPeg Library License ....1.3. LuaFileSystem Library License ....

    TscExcelExport 3.6 full source

    - Added read only property with row number of last data row - Added property with the Excel tabsheet so after the export it is possible to access the cells in Excel - Added event OnExportRecords ...

    利用 Oracle 和 PHP 管理分布式跟踪文件

    The supplied create script is for demo purposes only. You will need to specify a password and you may also want to assign alternative default and temporary tablespaces. create the external library ...

    word自动转化为chm

    A connection to Microsoft Word is required by Word-2-CHM while loading a Word document. The connection may be blocked by the anti-virus plug-in for Microsoft Office or other security software. Word-2-...

    数据库工具类DatabaseUtil.java

    * these objects must have a method signature is void close(). * * @param resource - * jdbc resouce to close */ public void closeJDBCResource(Object resource) { try { Class&lt;? extends Object&gt; ...

    Sortable前端框架

    Sortable is a &lt;s&gt;minimalist&lt;/s&gt; JavaScript library for reorderable drag-and-drop lists. Demo: http://rubaxa.github.io/Sortable/ ## Features * Supports touch devices and [modern]...

    建伍378G写频软件

    1. When "Read from radio" is selected, the "Read from radio" window opens. 2. Select "[OK]" or "[Cancel]". Note1: If communication with the transceiver is not possible for any reason, the "Check ...

Magicbox
Global site tag (gtag.js) - Google Analytics