Hibernate generate timestamp on create and update

[Anand Loni]

Hi,

I am using hibernate/JPA annotations. I need to have two fields creation time and modified time in the table which will be updated by hibernate. I tried using @generated, but its not updating the fields. Any other simple approach to update the fields automatically.

   

	  @Generated(GenerationTime.ALWAYS)
	  @Temporal(TemporalType.TIMESTAMP)
	  @Column(name = "MODIFIED_DATE", updatable = false, insertable = false)
	  private Date modifiedDate;
	  
	  @Generated(GenerationTime.INSERT)
	  @Temporal(TemporalType.TIMESTAMP)
	  @Column(name = "CREATED_DATE", insertable = false) 
	  private Date createdDate;

 

Thanks in advance.

[Nikita Protsenko]

I assume that the following clause gets in the way: "updatable = false, insertable = false". I think it stops the Hibernate from writing these fields into the database.

[Anand Loni]

If I remove updatable and insertable fields, I am getting below error while deploying...

Substituted for missing class org.hibernate.AnnotationException - Cannot have @Generated property and insertable columns: modifiedDate   

[Nikita Protsenko]

The following works for me:

...
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "MODIFIED_DATE", insertable = false)
    private Date modifiedDate;

    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "CREATED_DATE", updatable = false)
    private Date createdDate;
...

I am using Hibernate/JPA too. I've skipped the @Generated annotation, though.

Here is the test code:

...
        TestObj test = new TestObj();
        test.setValue("value");
        em.persist(test);
        em.flush();
        em.detach(test);
        test.setValue("value1");
        em.merge(test);
        em.flush();
...

...and the output:

Hibernate: insert into TestObj (CREATED_DATE, value) values (?, ?)
Hibernate: select testobj0_.id as id4_0_, testobj0_.CREATED_DATE as CREATED2_4_0_, testobj0_.MODIFIED_DATE as MODIFIED3_4_0_, testobj0_.value as value4_0_ from TestObj testobj0_ where testobj0_.id=?
Hibernate: update TestObj set MODIFIED_DATE=?, value=? where id=?

Everything seems to be working. Hope that'll help you.

[Anand Loni]

Hi Nikita,

Thanks for the reply.

I did the things you mentioned..but its not working for me

[Nikita Protsenko]

Hello, Anand!

I've found that there was a bug in some versions of Hibernate that looks very similar to your problem.

Link to the JIRA page

Which version of Hibernate do you use? I am using 3.5.1-Final. Maybe it is a root of the problem?

Best regards,
Nikita Protsenko

[Anand Loni]

Hi Nikita,

Thanks for the reply.

I m using hibernate v 3.2.5. I will updates jars from 3.5.0 and will check.

Thanks Again,

[Anand Loni]

Hi,

Now I am using Hibernate v3.5.0 jars, but I am not able to deploy war to my weblogic server.

I am getting below error

    
<May 5, 2010 7:38:34 PM IST> <Error> <Deployer> <BEA-149265> <Failure occurred i
n the execution of deployment request with ID '1273068494208' for task '21'. Err
or is: 'weblogic.application.ModuleException: '
weblogic.application.ModuleException:
        at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.jav
a:1399)
        at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
        at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
teDriver.java:425)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:83)
        at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
eDriver.java:119)
        Truncated. see log file for complete stacktrace

Caused By: java.lang.NoSuchMethodError: javax.persistence.OneToMany.orphanRemova
l()Z
        at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(Annotati
onBinder.java:1830)
        at org.hibernate.cfg.AnnotationBinder.processIdPropertiesIfNotAlready(An
notationBinder.java:762)
        at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:72
6)
        at org.hibernate.cfg.AnnotationConfiguration.processArtifactsOfType(Anno
tationConfiguration.java:636)
        at org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(Annotatio
nConfiguration.java:359)
        Truncated. see log file for complete stacktrace
>
<May 5, 2010 7:38:34 PM IST> <Error> <Deployer> <BEA-149202> <Encountered an exc
eption while attempting to commit the 1 task for the application 'dgmtApp'.>
<May 5, 2010 7:38:34 PM IST> <Warning> <Deployer> <BEA-149004> <Failures were de
tected while initiating deploy task for application 'dgmtApp'.>
<May 5, 2010 7:38:34 PM IST> <Warning> <Deployer> <BEA-149078> <Stack trace for
message 149004
weblogic.application.ModuleException:
        at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.jav
a:1399)
        at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
        at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
teDriver.java:425)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:83)
        at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
eDriver.java:119)
        Truncated. see log file for complete stacktrace

Caused By: java.lang.NoSuchMethodError: javax.persistence.OneToMany.orphanRemova
l()Z
        at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(Annotati
onBinder.java:1830)
        at org.hibernate.cfg.AnnotationBinder.processIdPropertiesIfNotAlready(An
notationBinder.java:762)
        at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:72
6)
        at org.hibernate.cfg.AnnotationConfiguration.processArtifactsOfType(Anno
tationConfiguration.java:636)
        at org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(Annotatio
nConfiguration.java:359)
        Truncated. see log file for complete stacktrace
>
<May 5, 2010 7:38:34 PM IST> <Error> <Console> <BEA-240003> <Console encountered
 the following error weblogic.application.ModuleException:
        at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.jav
a:1399)
        at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
        at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
teDriver.java:425)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:83)
        at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
eDriver.java:119)
        at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedMod
uleDriver.java:200)
        at weblogic.application.internal.flow.ModuleListenerInvoker.start(Module
ListenerInvoker.java:247)
        at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleSta
teDriver.java:425)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:83)
        at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStat
eDriver.java:119)
        at weblogic.application.internal.flow.StartModulesFlow.activate(StartMod
ulesFlow.java:27)
        at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.ja
va:1267)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineD
river.java:83)
        at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.
java:409)
        at weblogic.application.internal.SingleModuleDeployment.activate(SingleM
oduleDeployment.java:39)
        at weblogic.application.internal.DeploymentStateChecker.activate(Deploym
entStateChecker.java:161)
        at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(Ap
pContainerInvoker.java:79)
        at weblogic.deploy.internal.targetserver.operations.AbstractOperation.ac
tivate(AbstractOperation.java:569)
        at weblogic.deploy.internal.targetserver.operations.ActivateOperation.ac
tivateDeployment(ActivateOperation.java:150)
        at weblogic.deploy.internal.targetserver.operations.ActivateOperation.do
Commit(ActivateOperation.java:116)
        at weblogic.deploy.internal.targetserver.operations.AbstractOperation.co
mmit(AbstractOperation.java:323)
        at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploym
entCommit(DeploymentManager.java:844) ....

I googled for this error..but I am not able to solve it. >

[Nikita Protsenko]

It seems like you are using JPA 2.0 in the compile time, but your appserver provides only JPA 1.0 in the runtime. Here is a couple of links that may give you a clue about the error:

http://opensource.atlassian.com/projects/hibernate/browse/HHH-4955
http://stackoverflow.com/questions/2511997/i-am-getting-an-error-with-a-onetomany-association-when-using-annotations-with-gi

The prospect looks gloomy, though.