Consider Java object has startDate attribute; Oracle Table has start_date field. How to save an object with sysdate(current date and time) value in database table using HIBERNATE?

Hi 141748,

Could you elaborate the scenario so that more ideas can be shared!

Set them to System.currentTimeMillis() in your program (either right before saving or inside the constructor), use a default value at the database (SYSDATE) or a trigger that fills in SYSDATE if no value is provided externally.

I am a beginner in Hibernate tech.

I want to insert current date and time( e-g 8/17/2010 5:33:00 PM) in Oracle table.

Table structure
table name - BATCH_Q
job_id number(7);
start_date date;



My Object will be,

public class JobStatusObject{
private long jobId;
private Date startDate;
getters and setters for that
}

Mapping file will be,

<class name="com.test.JobStatusObject" table="BATCH_Q">
<meta attribute="class-description"></meta>
<id name="jobId" type="long" column="JOB_ID" unsaved-value="null">
<generator class="sequence">
<param name="sequence">JOB_ID</param>
</generator>
</id>
<property name="startDate" type="date" column="START_DATE" />
</class>

Client class code

main(){
JobStatusObject obj = new JobStatusObject();
obj.setStartDate(new Date); -- it inserts date alone.
session.save(obj);
}

But it inserts date alone. I want the time also to be inserted along with date field.
I should not use any trigger in database
Could you please provide a solution as how to insert current date and time in oracle table.

You can use TIMESTAMP instead of DATE.

Hi CDillinger,

Thanks.Changed date to timestamp value. It is working fine now.