java.sql.Date; nested exception is java.sql.SQLException: Value '0000-00-00 00:00:00'
can not be represented as java.sql.Date
碰到这问题开始不知道觉的很怪，设置show_sql后把打印出来的语句放到mysql客户端运行正确，但在eclipse
中junit调试就报错，后来发现时表中的data类型字段里面不能为“0000-00-00”这样的格式，否则就会
报以上错误
知道原因修正方法当然就简单了，要不把“0000-00-00”格式内容写成null
或者把格式“0000-00-00”改成类似“2011-03-10”，再次运行就正确了。
分享到：
相关推荐
异常：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 ...
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 ...
A meaningful modification for the Tang-Toennies potential model: Application to He-He potential，盛晓伟，... In addition, the repulsive potential represented by a Born-Mayer term in the Tang-Toennies pot
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 ...
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. ...
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 ...
It has MEX interfaces for Matlab, but can also be used (with possible future modifications) from Python and directly from C++. It can also be used for approximate nearest neighbor search, especially ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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...
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 ...
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...
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...
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 ...
In case Matlab is not installed or Matlab license is not available (for instance on a computer cluster), we provide standalone executables that can be used in conjunction with the Matlab Compiler ...