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

Update Version of Derby

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

Derby sequence with Hibernate