java - hibernate saveOrUpdate : no SqlStatement when a field is present -
strange behavior hibernate saveorupdate :
- when
- the field eqfcomment (string) of entity null,
- and modify field eqfdt (java.util.date, hour part modified),
- then can see update sqlstatement generated hibernate in log, , row modified in database ;
- when
- the field eqfcomment not null, single normal character, instance "t"
- and modify hour of field eqfdt
- then there no sqlstatement in log , row not modified in database.
i can see value of modified field in log both cases.
entity :
@entity @table(name = "sit_evenement_qf") public class evenementqf { @id @column(name = "eqf_id", unique = true, nullable = false) private long eqfid; @temporal(temporaltype.date) @column(name = "eqf_dt", nullable = false, length = 7) private date eqfdt; @column(name = "eqf_comment", length = 4000) private string eqfcomment; ... } dao :
public void saveorupdate(evenementqf entity) throws eqfdaoexception { try { if (entity.getid() != null) { this.getsession().evict(this.get(entity.getid())); } this.getsession().saveorupdate(entity); } catch (hibernateexception var4) { this.log.info("erreur hibernate " + var4); throw var4; } catch (exception var5) { this.log.error("erreur inattendue : " + var5); throw var5; } } hibernate log in debug mode :
without field eqfcomment, , update statement :
org.hibernate.internal.util.entityprinter (entityprinter.java:114) - listing entities: org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.siotypelid{tlilib=ligne simple, tlicod=l, siolids=<uninitialized>} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.evenementqf{eqfcomment=, eqfindmarqnat=n, lid=com.rte.siquael.dao.entity.lid#1476, eqftypemateriel=null, eqfessno=null, evtgrdampleur=null, eqfreprise=null, eqfindrht=n, bloccoupure=null, eqfconstructeur=null, poste=null, sitperturbations=[], eqfcod=17003430, eqfindmarqloc=o, indicateurzone=n, eqfcommentairerh=null, eqfcommentairerj=null, eqfdt=sun sep 10 10:10:10 cest 2017, gesrid=null, eqfid=352082, eqfirtsyst=n, sitcourtcircuits=[com.rte.siquael.dao.entity.courtcircuit#337101], tessid=null, statut=e, sitanomalies=[], eqfcommentairerht=null, sitevenementcbs=[], eqfindtraitement=n, eqfesrno=null, motcleid=null, contrainteid=402, eqfrje=null, eqfmarquagedt=mon sep 11 16:08:09 cest 2017, sitstatutat=com.rte.siquael.dao.entity.sitstatutat#e, eqfdtms=0, eqfdtcreat=2017-09-11, eqfindrj=n, clientid=null, eqfindrh=n, eqfnoega=null, sitecartexploits=[], eqfavtincid=null, complementregionaux=null, eqfdtmscal=212371812122000, eqfbloque=n, eqfouvntnlib=null, gessid=null, eqfdtmaj=tue sep 12 09:54:46 cest 2017, eqfindmarqreg=n, sitactionsuivirexes=<uninitialized>, eqfouvlib=null, eqfdatemiseenservice=null, tesrid=null, responsableid=463} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.poste{posindicecur=null, clients=<uninitialized>, bloccoupures=<uninitialized>, posadr=partenay les bonobonos, siotypesite=com.rte.siquael.dao.entity.typesite#p, poscoordonneex=926619.18, poscoordonneey=6514695.25, posetat=existant, posdtin=1970-01-01, posid=1214, posnumnat=004, cdfidtypprop=297, posdpde=1970-01-01, posdrfe=null, sioniveautensions=<uninitialized>, posdrde=1970-01-01, structurechargeeexploitation=com.rte.siquael.dao.entity.structure#103, structureadm=com.rte.siquael.dao.entity.structureadm#1312, commentaire=injection-soutirage , sioouvrage=<uninitialized>, siopays=com.rte.siquael.dao.entity.pays#f, siopsts=<uninitialized>, poscodnat=a.bai, posdatemodifinforef=2017-02-15, posdpfe=null, tranchesbt=<uninitialized>, complementregionaux=null, poslibcrt=partenay les bonobonos, posdths=null, posdtcre=1997-11-07, posdtmaj=2017-03-16, structurechargeeconduite=com.rte.siquael.dao.entity.structure#8, poscur=13800b670a522054e043a3681e7c2054} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.poste{posindicecur=null, clients=<uninitialized>, bloccoupures=<uninitialized>, posadr=partenay les bonobonos, siotypesite=com.rte.siquael.dao.entity.typesite#p, poscoordonneex=null, poscoordonneey=null, posetat=existant, posdtin=1974-01-01, posid=1215, posnumnat=145, cdfidtypprop=304, posdpde=1989-01-01, posdrfe=null, sioniveautensions=<uninitialized>, posdrde=1989-01-01, structurechargeeexploitation=com.rte.siquael.dao.entity.structure#103, structureadm=com.rte.siquael.dao.entity.structureadm#1312, commentaire=null, sioouvrage=<uninitialized>, siopays=com.rte.siquael.dao.entity.pays#f, siopsts=<uninitialized>, poscodnat=a.ba5, posdatemodifinforef=2014-12-12, posdpfe=null, tranchesbt=<uninitialized>, complementregionaux=null, poslibcrt=partenay les bonobonos, posdths=null, posdtcre=1997-11-07, posdtmaj=1998-05-29, structurechargeeconduite=com.rte.siquael.dao.entity.structure#8, poscur=13800b670a512054e043a3681e7c2054} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.lid{sitanomalies=<uninitialized>, sitevenementqfs=<uninitialized>, lidnumnat=55s003300, siotypelid=com.rte.siquael.dao.entity.siotypelid#l, sitevenementcbs=<uninitialized>, sitevenementexploits=<uninitialized>, liddths=null, liddtin=1974-01-01, siotranchetcds=<uninitialized>, structurecheffile=com.rte.siquael.dao.entity.structure#103, liddtmaj=2001-07-31, liddtcre=1997-11-07, lidter=n, commentaire=null, lidid=1476, silacaouvrages=<uninitialized>, sioouvrages=<uninitialized>, sioniveautension=com.rte.siquael.dao.entity.sioniveautension#3, silactioncorrs=<uninitialized>, postea=com.rte.siquael.dao.entity.poste#1214, siolits=<uninitialized>, posteb=com.rte.siquael.dao.entity.poste#1215, sitcourtcircuits=<uninitialized>, lidcodnat=a.bail31a.ba5, structurechargeeconduite=com.rte.siquael.dao.entity.structure#8, lidlib=63kv partenay les bonobonos} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.structure{siopostesforstridcep=<uninitialized>, strlib=gdp de longefan, strcmp=0, siopostesforstridccp=<uninitialized>, clients=<uninitialized>, sitanomalies=<uninitialized>, strdtcre=1992-02-01, silpersonnesforstrid=<uninitialized>, siqcodifications=<uninitialized>, ssdtfin=null, strindicecur=-, sitevenementexploits=<uninitialized>, strdir=5, stross=25, siolidsforstridcfd=<uninitialized>, sitsauveetatsaisies=<uninitialized>, ssdtdeb=null, strsun=s, silactionameliorations=<uninitialized>, sioutilisateurs=<uninitialized>, strcur=d86ac36be9af4798937552ae34228317, strdtsup=null, strloc=st jean de maurienne, siofiltrestds=<uninitialized>, strnumordre=5, strcodpos=73300, silacaouvrages=<uninitialized>, silgroupeclients=<uninitialized>, siostructures=<uninitialized>, strid=103, sioprofils=<uninitialized>, sioprofils_1=<uninitialized>, siolidsforstridccd=<uninitialized>, siteqfcresrexes=<uninitialized>, siolits=<uninitialized>, structure=com.rte.siquael.dao.entity.structure#41, stradr2=cedex 1708, typestructure=com.rte.siquael.dao.entity.typestructure#gdp, stradr1=x, strfax=04xxxxxxxx, strvis=o, silpersonnesforstridapp=<uninitialized>, strtel=04xxxxxxxx} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.structure{siopostesforstridcep=<uninitialized>, strlib=lyon, strcmp=null, siopostesforstridccp=<uninitialized>, clients=<uninitialized>, sitanomalies=<uninitialized>, strdtcre=1992-02-01, silpersonnesforstrid=<uninitialized>, siqcodifications=<uninitialized>, ssdtfin=null, strindicecur=-, sitevenementexploits=<uninitialized>, strdir=5, stross=95, siolidsforstridcfd=<uninitialized>, sitsauveetatsaisies=<uninitialized>, ssdtdeb=null, strsun=null, silactionameliorations=<uninitialized>, sioutilisateurs=<uninitialized>, strcur=40e5174e8faf449a82eeb7328647a127, strdtsup=null, strloc=marteau cedex 03, siofiltrestds=<uninitialized>, strnumordre=null, strcodpos=69399, silacaouvrages=<uninitialized>, silgroupeclients=<uninitialized>, siostructures=<uninitialized>, strid=8, sioprofils=<uninitialized>, sioprofils_1=<uninitialized>, siolidsforstridccd=<uninitialized>, siteqfcresrexes=<uninitialized>, siolits=<uninitialized>, structure=null, stradr2=bp 3109, typestructure=com.rte.siquael.dao.entity.typestructure#cres, stradr1=3 bis, rue des matelots, strfax=04xxxxxxxx, strvis=o, silpersonnesforstridapp=<uninitialized>, strtel=04xxxxxxxx} org.hibernate.engine.jdbc.spi.sqlstatementlogger (sqlstatementlogger.java:109) - update sit_evenement_qf set bcp_id=?, cli_id_resp=?, cpl_id=?, cdf_id_contr=?, eqf_avt_incid=?, eqf_bloque=?, eqf_cod=?, eqf_comment=?, eqf_commentaire_rh=?, eqf_commentaire_rht=?, eqf_commentaire_rj=?, eqf_constructeur=?, eqf_date_mise_en_service=?, eqf_dt=?, eqf_dt_creat=?, eqf_dt_maj=?, eqf_dt_ms=?, eqf_dt_mscal=?, eqf_esr_no=?, eqf_ess_no=?, eqf_ind_marq_loc=?, eqf_ind_marq_nat=?, eqf_ind_marq_reg=?, eqf_ind_rh=?, eqf_ind_rht=?, eqf_ind_rj=?, eqf_ind_traitement=?, eqf_irtsyst=?, eqf_marquage_dt=?, eqf_no_ega=?, eqf_ouv_lib=?, eqf_ouv_ntn_lib=?, eqf_reprise=?, eqf_rje=?, eqf_type_materiel=?, ega_cod=?, cdf_id_gesr=?, cdf_id_gess=?, eqf_ind_zone=?, lid_id=?, cdf_id_motcle=?, pos_id=?, cdf_id_resp=?, stt_cod=?, cdf_id_tesr=?, cdf_id_tess=? eqf_id=? org.hibernate.engine.transaction.internal.jdbc.jdbctransaction (jdbctransaction.java:113) - committed jdbc connection org.hibernate.engine.transaction.internal.jdbc.jdbctransaction (jdbctransaction.java:126) - re-enabling autocommit org.hibernate.engine.jdbc.internal.jdbccoordinatorimpl (jdbccoordinatorimpl.java:201) - hhh000420: closing un-released batch org.hibernate.engine.jdbc.internal.logicalconnectionimpl (logicalconnectionimpl.java:246) - releasing jdbc connection org.hibernate.engine.jdbc.internal.logicalconnectionimpl (logicalconnectionimpl.java:264) - released jdbc connectionwith value in field eqfcomment, , without sqlstatement :
org.hibernate.internal.util.entityprinter (entityprinter.java:114) - listing entities: org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.siotypelid{tlilib=ligne simple, tlicod=l, siolids=<uninitialized>} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.evenementqf{eqfcomment=t, eqfindmarqnat=n, lid=com.rte.siquael.dao.entity.lid#1476, eqftypemateriel=null, eqfessno=null, evtgrdampleur=null, eqfreprise=null, eqfindrht=n, bloccoupure=null, eqfconstructeur=null, poste=null, sitperturbations=[], eqfcod=17003430, eqfindmarqloc=o, indicateurzone=n, eqfcommentairerh=null, eqfcommentairerj=null, eqfdt=sun sep 10 07:08:09 cest 2017, gesrid=null, eqfid=352082, eqfirtsyst=n, sitcourtcircuits=[com.rte.siquael.dao.entity.courtcircuit#337101], tessid=null, statut=e, sitanomalies=[], eqfcommentairerht=null, sitevenementcbs=[], eqfindtraitement=n, eqfesrno=null, motcleid=null, contrainteid=402, eqfrje=null, eqfmarquagedt=mon sep 11 16:08:09 cest 2017, sitstatutat=com.rte.siquael.dao.entity.sitstatutat#e, eqfdtms=0, eqfdtcreat=2017-09-11, eqfindrj=n, clientid=null, eqfindrh=n, eqfnoega=null, sitecartexploits=[], eqfavtincid=null, complementregionaux=null, eqfdtmscal=212371812122000, eqfbloque=n, eqfouvntnlib=null, gessid=null, eqfdtmaj=tue sep 12 10:40:22 cest 2017, eqfindmarqreg=n, sitactionsuivirexes=<uninitialized>, eqfouvlib=null, eqfdatemiseenservice=null, tesrid=null, responsableid=463} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.poste{posindicecur=null, clients=<uninitialized>, bloccoupures=<uninitialized>, posadr=partenay les bonobonos, siotypesite=com.rte.siquael.dao.entity.typesite#p, poscoordonneex=926619.18, poscoordonneey=6514695.25, posetat=existant, posdtin=1970-01-01, posid=1214, posnumnat=004, cdfidtypprop=297, posdpde=1970-01-01, posdrfe=null, sioniveautensions=<uninitialized>, posdrde=1970-01-01, structurechargeeexploitation=com.rte.siquael.dao.entity.structure#103, structureadm=com.rte.siquael.dao.entity.structureadm#1312, commentaire=injection-soutirage , sioouvrage=<uninitialized>, siopays=com.rte.siquael.dao.entity.pays#f, siopsts=<uninitialized>, poscodnat=a.bai, posdatemodifinforef=2017-02-15, posdpfe=null, tranchesbt=<uninitialized>, complementregionaux=null, poslibcrt=partenay les bonobonos, posdths=null, posdtcre=1997-11-07, posdtmaj=2017-03-16, structurechargeeconduite=com.rte.siquael.dao.entity.structure#8, poscur=13800b670a522054e043a3681e7c2054} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.poste{posindicecur=null, clients=<uninitialized>, bloccoupures=<uninitialized>, posadr=partenay les bonobonos, siotypesite=com.rte.siquael.dao.entity.typesite#p, poscoordonneex=null, poscoordonneey=null, posetat=existant, posdtin=1974-01-01, posid=1215, posnumnat=145, cdfidtypprop=304, posdpde=1989-01-01, posdrfe=null, sioniveautensions=<uninitialized>, posdrde=1989-01-01, structurechargeeexploitation=com.rte.siquael.dao.entity.structure#103, structureadm=com.rte.siquael.dao.entity.structureadm#1312, commentaire=null, sioouvrage=<uninitialized>, siopays=com.rte.siquael.dao.entity.pays#f, siopsts=<uninitialized>, poscodnat=a.ba5, posdatemodifinforef=2014-12-12, posdpfe=null, tranchesbt=<uninitialized>, complementregionaux=null, poslibcrt=partenay les bonobonos, posdths=null, posdtcre=1997-11-07, posdtmaj=1998-05-29, structurechargeeconduite=com.rte.siquael.dao.entity.structure#8, poscur=13800b670a512054e043a3681e7c2054} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.lid{sitanomalies=<uninitialized>, sitevenementqfs=<uninitialized>, lidnumnat=55s003300, siotypelid=com.rte.siquael.dao.entity.siotypelid#l, sitevenementcbs=<uninitialized>, sitevenementexploits=<uninitialized>, liddths=null, liddtin=1974-01-01, siotranchetcds=<uninitialized>, structurecheffile=com.rte.siquael.dao.entity.structure#103, liddtmaj=2001-07-31, liddtcre=1997-11-07, lidter=n, commentaire=null, lidid=1476, silacaouvrages=<uninitialized>, sioouvrages=<uninitialized>, sioniveautension=com.rte.siquael.dao.entity.sioniveautension#3, silactioncorrs=<uninitialized>, postea=com.rte.siquael.dao.entity.poste#1214, siolits=<uninitialized>, posteb=com.rte.siquael.dao.entity.poste#1215, sitcourtcircuits=<uninitialized>, lidcodnat=a.bail31a.ba5, structurechargeeconduite=com.rte.siquael.dao.entity.structure#8, lidlib=63kv partenay les bonobonos org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.structure{siopostesforstridcep=<uninitialized>, strlib=gdp de longefan, strcmp=0, siopostesforstridccp=<uninitialized>, clients=<uninitialized>, sitanomalies=<uninitialized>, strdtcre=1992-02-01, silpersonnesforstrid=<uninitialized>, siqcodifications=<uninitialized>, ssdtfin=null, strindicecur=-, sitevenementexploits=<uninitialized>, strdir=5, stross=25, siolidsforstridcfd=<uninitialized>, sitsauveetatsaisies=<uninitialized>, ssdtdeb=null, strsun=s, silactionameliorations=<uninitialized>, sioutilisateurs=<uninitialized>, strcur=d86ac36be9af4798937552ae34228317, strdtsup=null, strloc=st jean de maurienne, siofiltrestds=<uninitialized>, strnumordre=5, strcodpos=73300, silacaouvrages=<uninitialized>, silgroupeclients=<uninitialized>, siostructures=<uninitialized>, strid=103, sioprofils=<uninitialized>, sioprofils_1=<uninitialized>, siolidsforstridccd=<uninitialized>, siteqfcresrexes=<uninitialized>, siolits=<uninitialized>, structure=com.rte.siquael.dao.entity.structure#41, stradr2=cedex 1708, typestructure=com.rte.siquael.dao.entity.typestructure#gdp, stradr1=x, strfax=0479644607, strvis=o, silpersonnesforstridapp=<uninitialized>, strtel=0479640532} org.hibernate.internal.util.entityprinter (entityprinter.java:121) - com.rte.siquael.dao.entity.structure{siopostesforstridcep=<uninitialized>, strlib=lyon, strcmp=null, siopostesforstridccp=<uninitialized>, clients=<uninitialized>, sitanomalies=<uninitialized>, strdtcre=1992-02-01, silpersonnesforstrid=<uninitialized>, siqcodifications=<uninitialized>, ssdtfin=null, strindicecur=-, sitevenementexploits=<uninitialized>, strdir=5, stross=95, siolidsforstridcfd=<uninitialized>, sitsauveetatsaisies=<uninitialized>, ssdtdeb=null, strsun=null, silactionameliorations=<uninitialized>, sioutilisateurs=<uninitialized>, strcur=40e5174e8faf449a82eeb7328647a127, strdtsup=null, strloc=lyon cedex 03, siofiltrestds=<uninitialized>, strnumordre=null, strcodpos=69399, silacaouvrages=<uninitialized>, silgroupeclients=<uninitialized>, siostructures=<uninitialized>, strid=8, sioprofils=<uninitialized>, sioprofils_1=<uninitialized>, siolidsforstridccd=<uninitialized>, siteqfcresrexes=<uninitialized>, siolits=<uninitialized>, structure=null, stradr2=bp 3109, typestructure=com.rte.siquael.dao.entity.typestructure#cres, stradr1=3 bis, rue des matelots, strfax=04xxxxxxxx, strvis=o, silpersonnesforstridapp=<uninitialized>, strtel=04xxxxxxxx} org.hibernate.engine.transaction.internal.jdbc.jdbctransaction (jdbctransaction.java:113) - committed jdbc connection org.hibernate.engine.transaction.internal.jdbc.jdbctransaction (jdbctransaction.java:126) - re-enabling autocommit org.hibernate.engine.jdbc.internal.logicalconnectionimpl (logicalconnectionimpl.java:246) - releasing jdbc connection org.hibernate.engine.jdbc.internal.logicalconnectionimpl (logicalconnectionimpl.java:264) - released jdbc connection
any idea ? or perhaps hints investigate more ?
with @temporal annotation able store time,date , timestamp
in particular , @temporal(temporaltype.date) ignore time, example if have bean mapping database table field mapped date , see time @ db in way 00:00:00
with @temporal(temporaltype.timestamp) time not ignored .
note: when check date field @ db see date if have stored in timestamp way , depend of client , example in sqldeveloper can enable or disable view show date time in field.
Comments
Post a Comment