Tuesday, April 12, 2011

Update Version of Derby



  • shutdown the app replace derby.jar with newer version
  • append following to connection string  
upgrade=true
  • Start the app and that's all 
  • check it with following in sql 
values syscs_util.syscs_get_database_property( 'DataDictionaryVersion' );

Share Article : Update Version of Derby
Share/Save/Bookmark

Monday, April 11, 2011

Derby sequence with Hibernate







Derby sequence

CREATE SEQUENCE MD_USER_SEQ
AS INT
START WITH 1;


Hibernate mapping to get User_id from sequence

<id name="userId" type="integer" column="USER_ID" >
<generator class="sequence">
<param name="sequence">MD_USER_SEQ</param>
</generator>
</id>

[update:]
after all there is an issue with DerbyDialect of hibernate.
So need the following fix. 



package entity;


import org.hibernate.dialect.DerbyDialect;


/**
 *
 * @author Srinath
 */
public class MyDerbyDialect extends DerbyDialect{


    @Override
public String getSequenceNextValString(String sequenceName) {
        return "values next value for " + sequenceName;
}
}


Then in hibernate config

  <property name="hibernate.dialect">entity.MyDerbyDialect</property>




Share Article : Derby sequence with Hibernate
Share/Save/Bookmark