I saved a record into a table.Once saved,i Like to get the object ID (maximum of ID in table) ,pLease suggest how it can be done?

hi,

just execute the following query you will get the max value

select max(alias.columnname) from TableName as alias

Hope this may help you

thanks for ur reply.In my code I use the statement "hibernateTemplate.save(transientInstance)".Once saved ,I will execute the
"select max(alias.columnname) from TableName".In my application,it has many table,for every table i have to execute the query once data saved?.Is there any easy approach for this?

SessionFactory factory = new Configuration().configure().buildSessionFactory();
sess = factory.openSession();
String queryStr = "select
max(columnName)from Object";
Query query = sess.createQuery(queryStr);
List list = query.list();
System.out.println("max value of that column is : " + list.get(0));
sess.close();