hibernate - Spring Boot insert invalid datetime into MariaDB results in null, on not nullable field -


i have problem in spring boot project, have table created this:

create table task (     id int auto_increment         primary key,     title varchar(50) not null,     content text not null,     control_time datetime not null, );

and entity this:

@entity data class task(         @id @generatedvalue var id: long = 0,         @column(length = 50) var title: string = "",         @column(columndefinition = "text", length = 65535) var content = "",         @temporal(temporaltype.timestamp) var controltime: date = date())

i have endpoint takes task parameter, jackson converts json task object, works fine looking @ debug logs.

so problem if give date outside legal range(eg. above year 9999), hibernate persists without error, field ends containing null, shouldn't possible when it's not nullable field. assume mariadb throws error if persist outside legal range, when manually, somehow hibernate manages it, , ends being null.

trace hibernate:

26543 --- [nio-8080-exec-1] o.h.p.entity.abstractentitypersister     : dehydrating entity: [something.model.task#<null>] 2017-08-15 14:28:22.220 trace 26543 --- [nio-8080-exec-1]     o.h.type.descriptor.sql.basicbinder      : binding parameter [1] [timestamp] - [tue aug 15 14:28:22 cest 2017] 2017-08-15 14:28:22.221 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [2] [varchar] - [niklas] 2017-08-15 14:28:22.221 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [3] [timestamp] - [null] 2017-08-15 14:28:22.222 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [4] [timestamp] - [null] 2017-08-15 14:28:22.222 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [5] [varchar] - [null] 2017-08-15 14:28:22.222 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [6] [timestamp] - [null] 2017-08-15 14:28:22.222 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [7] [bigint] - [null] 2017-08-15 14:28:22.222 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [8] [varchar] - [] 2017-08-15 14:28:22.223 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [9] [timestamp] - [mon sep 10 05:06:44 cest 12439173] 2017-08-15 14:28:22.224 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [10] [boolean] - [null] 2017-08-15 14:28:22.224 trace 26543 --- [nio-8080-exec-1] o.h.type.descriptor.sql.basicbinder      : binding parameter [11] [varchar] - [] 2017-08-15 14:28:22.228 debug 26543 --- [nio-8080-exec-1] o.h.id.identifiergeneratorhelper         : natively generated identity: 2 2017-08-15 14:28:22.228 trace 26543 --- [nio-8080-exec-1] o.h.r.j.i.resourceregistrystandardimpl   : releasing result set [org.mariadb.jdbc.internal.queryresults.resultset.mariaselectresultset$1@1c4fe495] 2017-08-15 14:28:22.228 debug 26543 --- [nio-8080-exec-1] o.h.r.j.i.resourceregistrystandardimpl   : hhh000387: resultset's statement not registered 2017-08-15 14:28:22.228 trace 26543 --- [nio-8080-exec-1] o.h.r.j.i.resourceregistrystandardimpl   : closing result set [org.mariadb.jdbc.internal.queryresults.resultset.mariaselectresultset$1@1c4fe495] 2017-08-15 14:28:22.228 trace 26543 --- [nio-8080-exec-1] o.h.r.j.i.resourceregistrystandardimpl   : releasing statement [hikariproxypreparedstatement@639958422 wrapping sql : 'insert task (created_at, created_by, deleted_at, updated_at, updated_by, closed_at, closed_by, content, control_time, is_successful, title) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', parameters : ['2017-08-15 14:28:22.147','niklas',<null>,<null>,<null>,<null>,<null>,'','12439173-09-10 05:06:44.928',<null>,'']] 2017-08-15 14:28:22.229 trace 26543 --- [nio-8080-exec-1] o.h.r.j.i.resourceregistrystandardimpl   : closing prepared statement [hikariproxypreparedstatement@639958422 wrapping sql : 'insert task (created_at, created_by, deleted_at, updated_at, updated_by, closed_at, closed_by, content, control_time, is_successful, title) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', parameters : ['2017-08-15 14:28:22.147','niklas',<null>,<null>,<null>,<null>,<null>,'','12439173-09-10 05:06:44.928',<null>,'']] 2017-08-15 14:28:22.229 trace 26543 --- [nio-8080-exec-1] o.h.e.jdbc.internal.jdbccoordinatorimpl  : starting afterquery statement execution processing [on_close] 2017-08-15 14:28:22.231 debug 26543 --- [nio-8080-exec-1] o.h.e.t.internal.transactionimpl         : committing 2017-08-15 14:28:22.231 trace 26543 --- [nio-8080-exec-1] cresourcelocaltransactioncoordinatorimpl : resourcelocaltransactioncoordinatorimpl#beforecompletioncallback 2017-08-15 14:28:22.231 trace 26543 --- [nio-8080-exec-1] org.hibernate.internal.sessionimpl       : sessionimpl#beforetransactioncompletion() 2017-08-15 14:28:22.232 trace 26543 --- [nio-8080-exec-1] org.hibernate.internal.sessionimpl       : automatically flushing session 2017-08-15 14:28:22.232 trace 26543 --- [nio-8080-exec-1] o.h.e.i.abstractflushingeventlistener    : flushing session

i don't know how bold relevant parts, can see inserts datetime "12439173-09-10 05:06:44.928" without complaining. when in database value of "control_time" null.

has ever encountered problem, or know how happen?

edit: there mismatches between entity in definition , hibernate trace, because definition simplified.


Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more