`

'0000-00-00 00:00:00' can not be represented as java.sql.Timestamp error

 
阅读更多
### Cause: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
; SQL []; Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp; nested exception is java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
org.springframework.dao.TransientDataAccessResourceException: 
### Error querying database.  Cause: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

 

最简单的解决办法:

在jdbc的连接中增加:zeroDateTimeBehavior=convertToNull

分享到:
评论

相关推荐

    SNMP_Tag_Library-Suggested.pdf

    Implementing an SNMP-based Ethernet control network monitoring system can be challenging, especially when deciding which tags are important to monitor. COI Software has compiled a database of ...

    mysql datetime查询异常问题解决

    异常:Value ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp (2011-05-25 11:38:40) 描述:非空无默认值的Datetime类型字段,查询时程序报以下错误: Value ‘0000-00-00 00:00:00’ can ...

    iOS Fuondation Framework Reference

    - `- (id)objectValue`: Returns the object value of the descriptor if it can be represented as an Objective-C object. **Constants**: Constants related to Apple Event types and formats. --- ##### ...

    Senfore_DragDrop_v4.1

    Earlier versions of Delphi and C++ Builder will not be supported. If you need Delphi 3 or C++ Builder 3 support you will have to revert to version 3.7 of the Drag and Drop Component Suite. The ...

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

    Contents Module Overview 1 Lesson 1: Memory 3 Lesson 2: I/O 73 Lesson 3: CPU 111 ... It should be pointed out that SQL Server was linked using the /LAREGEADDRESSAWARE flag and can leverage ...

    Raize.Components-v6.1.12 FullSource(2009-XE8) Part2/2

    not be displayed correctly when using a custom VCL Style in XE6 or XE7. * Added LightenUnselectedColoredTabs property to TRzPageControl and TRzTabControl. When this property is True, a non-active ...

    Introduction_to_Optimum_Design.pdf

    The chapter also includes several examples, such as the design of a can, insulated spherical tank, saw mill operation, two-bar bracket, cabinet, tubular column, cylindrical tank, coil springs, and a ...

    Raize.Components-v6.1.12 FullSource(2009-XE8) Part1/2

    not be displayed correctly when using a custom VCL Style in XE6 or XE7. * Added LightenUnselectedColoredTabs property to TRzPageControl and TRzTabControl. When this property is True, a non-active ...

    Model Driven Architecture.pdf

    - **CORBA 3.0**: This version of CORBA added component-model technology, enabling integration across diverse computing platforms such as the Internet, Java, Windows, and SQL backends. - **Specialized ...

    大学英语预备级精读课后答案与题干翻译.doc

    - 被动语态 (`is represented by`, `can be converted to`, `is decided by`) - 条件状语从句 (`He will be hired depending on the interview.`) - 定语从句 (`When asked where his mother was...`) 4. **句子...

    Cours-VB-NET-2010-Developpez-com

    Objects are real-world entities that can be represented in programming. For example, a car can be considered an object with properties (color, make, model) and behaviors (drive, stop). ##### 2. In ...

    英语六级重点词汇表

    - She can hardly abide his presence. #### Abolish (v.) - **定义与用法**:意为废除某项制度、法律或习俗。 - **例句**:The government decided to abolish capital punishment. #### Absent (a.) - **定义与...

    56991795TIMIT-speech-database.rar

    3- All the dialect(方言的) regions should be represented in both subsets, with at least 1 male and 1 female speaker from each dialect. 4- The amount of overlap of text material in the two subsets...

    C Bath University Course Material

    - **Images as Functions:** Images can be represented mathematically as functions that map spatial coordinates to intensity values. - **Images as Frequencies:** Fourier transforms can be used to ...

    ObjCRuntimeGuide

    - **Property Type and Functions:** Properties can be declared with specific types, such as `strong`, `weak`, `copy`, etc., which determine how the referenced object is managed. The document explains ...

    wide terminal type flat chip resistors

    - Additional information about packaging options can be found in Appendix A. #### Resistance Values and Tolerances The WK73R series offers a range of resistance values with different tolerances: -...

Global site tag (gtag.js) - Google Analytics