`
hqman
  • 浏览: 354599 次
  • 性别: Icon_minigender_1
  • 来自: 苏州
社区版块
存档分类
最新评论

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

阅读更多
[20:40.376] cms - could not read column value from result set: birthTime301_; Value '0000-00-00' can not be represented as java.sql.Date
[20:40.377] cms - SQL Error: 0, SQLState: S1009
[20:40.377] cms - Value '0000-00-00' can not be represented as java.sql.Date
[09:20:40.382] javax.servlet.ServletException: javax.servlet.ServletException:

终于找到了 这个问题的原因

Value '0000-00-00' can not be represented as java.sql.Date
数据库里的时间类型不能为以上形式

空的时候 设置成null 就没问题了
分享到:
评论
2 楼 hqman 2007-06-26  
没有深入下去,只是解决问题。
1 楼 wutao8818 2007-06-26  
最近刚看了一本书mysql的书里正好写到这个问题,记的不太清楚,大致的意思是0000-00-00这个时间是可以记录的,而且有个参数可以控制是否接受某些类型的日期,当然上面说的是数据库方面的日期范围。
java.sql.Date是不是允许这个我就不清楚了

相关推荐

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

    SQL1992标准(pdf)

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

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

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

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

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

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

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

    A survey of Uncertain Data Algorithms and Applications

    Thus each aggregate record can be represented by a probability distribution.  In some cases, data attributes are constructed using statistical method such as forecasting. In such case , the ...

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

    Dynamical Processes on Complex Networks

    Internet, can be represented as large complex networks. This book will interest graduate students and researchers in many disciplines, from physics and statistical mechanics, to mathematical biology ...

    a project model for the FreeBSD Project.7z

    This project model is not meant to be a tool to justify creating impositions for developers, but as a tool to facilitate coordination. It is meant as a description of the project, with an overview of...

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

    ATL_User_Manual

    It also considers that the different kinds of handled items (such as the tools, the repositories, etc.) can be viewed and represented as models. The model-driven approach supposes to provide model ...

    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