`
pengfeifei26
  • 浏览: 245375 次
  • 性别: Icon_minigender_1
  • 来自: 北京
文章分类
社区版块
存档分类
最新评论

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

阅读更多
Value '0000-00-00' can not be represented as java.sql.Timestamp
关键字: 数据库字段为datetime类型时默认值为:0000-00-00 00:00:00
mysql
数据库字段为datetime类型时默认值为:0000-00-00 00:00:00
查询时异常
java.sql.SQLException:Value '0000-00-00' can not be represented as java.sql.Date
解决方法在url后添加 &zeroDateTimeBehavior=convertToNull
datasource.url=jdbc:mysql://localhost:3306/pe?useUnicode=true&characterEncoding=gbk&zeroDateTimeBehavior=convertToNull

注意 &->&
分享到:
评论

相关推荐

    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 ...

    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 ...

    AnsoftQ3D_v7-full_book.pdf

    To create complex objects, primitives can be used as “tools” to cut holes, carve away, or join. The operations that are performed with these “tools” are often referred to as Boolean operations. ...

    Speech Encoding - Frequency Analysis MATLAB.zip_As One_HMM word_

    The speech signal for the particular isolated word can be viewed as the one generated using the sequential generating probabilistic model known as hidden Markov model (HMM). Consider there are n ...

    Image super-resolution

    The mapping is represented as a deep convolutional neural network (CNN) [15] that takes the low- resolution image as the input and outputs the high-resolution one. We further show that traditional ...

    OTA COM Type Library

    Other assets can be represented as user assets or resources: A user asset is an entity that is conceptually part of another entity and so owned by that entity. It is therefore automatically copied ...

    ISO14229-1.pdf

    established has the right to be represented on that committee. International organizations, governmental and non-governmental, in liaison with ISO, also take part in the work. ISO collaborates closely...

    kgb档案压缩console版+源码

    the leading digits can be output as they become known. For decompression, as the digits of x are read, the set of possible y satisfying (1) is restricted to an increasingly narrow lexicographical ...

    json.js_json2.js

    value represented by the name/value pair that should be serialized, or undefined if nothing should be serialized. The toJSON method will be passed the key associated with the value, and this will ...

    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 ...

    DBGridPro new

    Multilevel layout of column titles - fields of dataset record can be represented as several rows in the grid to enhance the display of information to end-users at runtime. Column layout can be easily...

    android dex format

    ### Android DEX (Dalvik Executable) 格式详解 #### 概述 DEX(Dalvik Executable)格式是Android平台特有的程序文件格式,用于存储一系列类定义及其相关的辅助数据。这种格式专为Android设备上的Dalvik虚拟机...

    EMD.rar_As One_EMD

    This is an implementation of the Earth Movers Distance, as described in [1]. The EMD computes the distance between two distributions, which are represented by signatures. The signatures are sets of ...

    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 ...

    ISO26262-1

    established has the right to be represented on that committee. International organizations, governmental and non-governmental, in liaison with ISO, also take part in the work. ISO collaborates closely...

    计算机网络英文题库(附答案)chapter5.pdf

    error checking method, with a four-bit generator G = 1011 and data D = 10101010, the value of R (the remainder) is calculated by XORing the data with the polynomial represented by G. The calculation ...

    EhLib-delphi

     can send SQL expressions on the server through the corresponding access engine.  It is TBDEDataDriverEh, TIBXDataDriverEh, TDBXDataDriverEh and TADODataDriverEh  component.  There are a ...

    Hidden Markov Models Fundamentals

    How can we apply machine learning to data that is represented as a sequence of observations over time? For instance, we might be interested in discovering the sequence of words that someone spoke ...

Global site tag (gtag.js) - Google Analytics